topic Re: Sorting an infotable in ascending order in ThingWorx Developers

Sorting an infotable in ascending order

kahmeng96 — Wed, 09 Oct 2019 06:43:20 GMT

Hi all, I am trying to sort an infotable in ascending order of a column, in this case the LegReaction column.

As shown in the infotable above, I want to put the value of LegReaction (45) between values 40 and 50 without manually modifying the infotable but by JavaScript programming. Any help is greatly appreciated!

Re: Sorting an infotable in ascending order

raluca_edu — Wed, 09 Oct 2019 07:21:31 GMT

Hi,

You should follow algorithm to insert object in a sorted array: https://www.geeksforgeeks.org/search-insert-and-delete-in-a-sorted-array/

Sorry, I don't have the code but this is the idea, implement the inserting operation in infotable via a service following the above algorithm.

Workaround: add a row in infotable, doesn't matter the position and then use the Sort function:

Resources["InfoTableFunctions"].Sort(params)

Hope it helps,

Raluca Edu

Re: Sorting an infotable in ascending order

kahmeng96 — Wed, 09 Oct 2019 07:21:49 GMT

Hi all, I have found the solution by tinkering with the sort function

data.sort(function(a, b){return a.LegReaction-b.LegReaction});

Re: Sorting an infotable in ascending order

kahmeng96 — Wed, 09 Oct 2019 07:43:11 GMT

Thanks for the advice, @raluca_edu! However, I found an easier solution which is the I accepted as the solution to my question.

Re: Sorting an infotable in ascending order

raluca_edu — Wed, 09 Oct 2019 07:45:59 GMT

You welcome! I saw your post after. Good luck!

Re: Sorting an infotable in ascending order

DuanGauche — Fri, 22 Oct 2021 11:00:02 GMT

Hi kahmeng96,

I know you already have a solution, but this might be an alternative...

//The code below sorts an infotable by the specified column.

var result = Resources["InfoTableFunctions"].Sort( {

sortColumn: "LegReaction", t: myInfoTable, ascending: true

} );