cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting an infotable in ascending order

SOLVED
Highlighted
Amethyst

Sorting an infotable in ascending order

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

Capture.PNG

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!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sorting an infotable in ascending order

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

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

View solution in original post

4 REPLIES 4

Re: Sorting an infotable in ascending order

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

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

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

View solution in original post

Re: Sorting an infotable in ascending order

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

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

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________