ResultsXML Doesnt maintain case

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
CathyC
Posts: 472
Joined: November 16th, 2021, 11:15 am
Contact:

ResultsXML Doesnt maintain case

Unread post by 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
TestRegularResults.PNG (77.28 KiB) Viewed 966 times
TestRegularResults.PNG
TestRegularResults.PNG (77.28 KiB) Viewed 966 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
TestResultsXML.PNG (83.03 KiB) Viewed 966 times
TestResultsXML.PNG
TestResultsXML.PNG (83.03 KiB) Viewed 966 times
Last edited by CathyC on June 27th, 2022, 12:31 pm, edited 1 time in total. word count: 150

Tags:
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:

Re: ResultsXML Doesnt maintain case

Unread post by SteveCap »

Task #10227 has been created. This post will be updated when it is completed.
word count: 14
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:

Re: ResultsXML Doesnt maintain case

Unread post by 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>
word count: 43
Post Reply