How to reorder a custom collection using script.

[Former Member]

Let say I have a collection "ABC_T" in a Project which has two column Line No & Data.

Table: ABC_T

Line No	Data
1	Data 1
2	Data 2
3	Data 3
4	Data 4

I want to sort the table based on the 1st column line no in descending order. So the document should look like below when a user click on save.

Line No	Data
4	Data 4
3	Data 3
2	Data 2
1	Data 1

[Former Member]

Hi Pawan,

Custom Collection comes with a button called "Reorder List" where you can order the rows manually.

If you want to do through script then you need to copy all data into a HashMap or any other temporaray array.Sort it and create the collection newly by deleting the old entries.

Hope this works.

Thanks & Regards,

Rajiv Yadav.