Page 1 of 1

Inquire Logs for Parameters

Posted: July 2nd, 2022, 10:54 am
by CathyC
I want to write logs for an item import to the batch job logs using the Info node of the inquire. I would like it to say:

Failed to Insert/Update Item Number X and Address Number X and Catalog Name X and Customer Group X, etc.

Here is what I have to do for that:
image.png
Its dependent on the order. Can the Info node of the parameters also return a parameter name so I can filter like this instead?
Parameters/Parameter[Name = 'UnitPrice']

Re: Inquire Logs for Parameters

Posted: July 5th, 2022, 12:28 pm
by SteveCap
This was added to RunQuery and other database services. Looks like Inquire was missed. I have added task #10594 to add this. So the logs will then start to have:

Code: Select all

<WorkData>
	<Inquire>
		<Info>
			<Result>
				<Parameters>
					<Parameter>
						<Name>Name1</Name>
						<DataType>AnsiString</DataType>
						<Value>ItemUnitPrice</Value>
						<ColumnName>UnitPrice</ColumnName>
					</Parameter>
				</Parameters>
			</Result>
		</Info>
	</Inquire>
</WorkData>
Once it has been completed.

Re: Inquire Logs for Parameters

Posted: July 5th, 2022, 4:10 pm
by CathyC
This is great! thank you!