topic Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output in ThingWorx Developers

How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

MM_10159448 — Thu, 29 Jun 2023 11:31:37 GMT

Hi Team,

I am facing this issue mentioned below:

I want to prevent sort ascending order .Please help on this and provide solution

Thingworx Version-V8.5.6

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

PaiChung — Thu, 29 Jun 2023 16:54:40 GMT

If you are generating this in a service, then you can apply your desired sort in the service before setting it to result.

Hope that helps.

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

MM_10159448 — Fri, 30 Jun 2023 06:53:14 GMT

Hi PaiChung,

Thank you for your reply

Applying desired sort means,not understood clearly, can u please explain or share some code if you have as an examples?

Currently, I am not applying any sort in service, You can see in screenshot, Whatever , I am sending as an input sequence, same I want in infotable service output. without sort ascending order

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

TravisPickett — Fri, 30 Jun 2023 14:32:00 GMT

Hello,

Can you provide some code snippets from your service to help us understand how you are building the infotable. My assumption from your screen shot and using "Dynamic Columns" is that you are creating the data shape for the info table on the fly either entirely or adding columns to an existing data shape using AddField or fieldDefinitions.

In either case column order is not guaranteed to be in add order by default. If you want to guarantee columns are in a specific order you must specify the ordinal property when adding the column. Please see the following support cases for examples: CS313173 CS388066

Thanks,

Travis

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

MM_10159448 — Thu, 06 Jul 2023 15:52:06 GMT

Hi Team,

Thank you for providing to set ordinal property information.

Now, Service giving desired output when executing service manually from composer but when checked in runtime 'Developer Tools' not getting desired output

Pls check both screenshot

Let me know any solution on it

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

nmutter — Fri, 07 Jul 2023 22:09:43 GMT

A json object does not account property order. (https://stackoverflow.com/a/16870531)

The "ordinal" property is a twx-specific metadata which twx toolings will consider. The "wanted" order you can see in developer tools response in "datashape" (your screenshot shows the "rows" of the response)

May I ask the use case why you rely on the order of the properties?

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

MM_10159448 — Fri, 28 Jul 2023 08:41:26 GMT

Because, Order of Input can be anything, ascending OR descending, the service should provide output whatever input order coming.

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

slangley — Fri, 11 Aug 2023 15:00:06 GMT

Hi @MM_10159448.

Why are you concerned with the order displayed in Dev Tools if Composer is displaying in the desired order? Dev Tools is strictly the response that is returned. It may not present in the desired order determined by the ordinal.

Regards.

--Sharon

Re: How To Prevent Sort Ascending Order Of Dynamic Column Name in Services Output

MM_10159448 — Tue, 28 Nov 2023 15:43:24 GMT

After applying ordinal logic, Service giving desired result based on input any sequence provided but same checked in runtime 'Devtools' preview tab,It is again converting to ascending order

This is the problem