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

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

12-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.

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
12-Amethyst
(To:kahmeng96)

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

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

5 REPLIES 5
17-Peridot
(To:kahmeng96)

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

12-Amethyst
(To:raluca_edu)

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

17-Peridot
(To:kahmeng96)

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

12-Amethyst
(To:kahmeng96)

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

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

11-Garnet
(To:kahmeng96)

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

} );

Announcements
Top Tags