ResultsXML Doesnt maintain case

[CathyC]

I'm dynamically making the results of an inquire, so I need to use the ResultsXML, but when I do, the specified Column Names dont have their case maintained. Just like when you dont specify the column names in the results, they come back in all caps.

I ran a test with them hard coded and saw that when you use the ResultsXML it doesnt maintain the case like it does where you click + to add the results

Using the Regular Results with + and it comes out in mixed case like specified

TestRegularResults.PNG (77.28 KiB) Viewed 963 times

TestRegularResults.PNG (77.28 KiB) Viewed 963 times

useing the resultsxml it come out all caps
Also, its not keeping them in the same order, but it does do that with the regular results

TestResultsXML.PNG (83.03 KiB) Viewed 963 times

TestResultsXML.PNG (83.03 KiB) Viewed 963 times

[SteveCap]

Task #10227 has been created. This post will be updated when it is completed.

[SteveCap]

This is actually not a bug.

You are missing the root Results node. The ResultXml should look like:

Code: Select all

<Results>
	<Result>
		<Column>CategoryCode3</Column>
	</Result>
	<Result>
		<Column>CategoryCode3Value</Column>
	</Result>
	<Result>
		<Column>CategoryCode2</Column>
	</Result>
	<Result>
		<Column>CategoryCode2Value</Column>
	</Result>
</Results>