Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By nadobii
#825975
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
13.png (11.59 KiB) Viewed 1134 times
thanks for your guidance
User avatar
By amosbatto
#825987
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
By nadobii
#826026
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
User avatar
By amosbatto
#826029
nadobii wrote: Fri Aug 16, 2019 5:46 pm 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.
By nadobii
#826036
thanks for your help.
I will be so appreciated if you explain and share an example about this in a right time.
User avatar
By amosbatto
#826058
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, PMUsers.com is down.

It would be nice if ProcessMaker can let us know w[…]

Hi, What is your server config? Is your server Wi[…]

Hi, It's not possible, because processmaker set s[…]

Filtering Grids For Parallel Tasks

Hi, You must create a grid for example @=tempGrid[…]