[nadobii]

Hi,
a user should be able to sort a grid based on a specified field (every column) in ascending or descending order in dynaform, i want to have ascending and descending icons on the top of columns and use them for sorting:

13.png (11.59 KiB) Viewed 6312 times

thanks for your guidance

[amosbatto]

You can do sorting in grids with JavaScript:
viewtopic.php?f=44&t=736737&p=824701#p824701
https://www.pmusers.com/index.php/Sort_grid_by_column

If you want to sort a table of data with arrows in the column headers, then you can use datatables or paramquery in a panel.
See:
viewtopic.php?f=44&t=736737&p=824742#p824701

[nadobii]

thanks, the first solution is ok,
but i can't use paramquery in my grid
can you please explain in detail about this?
thanks for your consideration

[amosbatto]

but i can't use paramquery in my grid
can you please explain in detail about this?

You have to create a Panel control in your Dynaform and put the table of data inside the panel. You can save the data as a JSON string in a hidden field inside your Dynaform.
I don't have any examples right now that I can share.

[nadobii]

thanks for your help.
I will be so appreciated if you explain and share an example about this in a right time.

[amosbatto]

Go to https://paramquery.com/demos# and click on the "Sorting" section in the sidebar to see a demo.

To get grid sorting, you need to get the paid version of ParamQuery Grid Pro, which costs $129.
See:
https://paramquery.com/pro/download
https://paramquery.com/pro/download/evaluate

[amosbatto]

I created an example of sorting by clicking the column headers in grids in ProcessMaker:
https://www.pmusers.com/index.php/Sort_ ... ing_header

[nadobii]

Hi,
Thanks so much