I intend to incorporate the below functionality to the grid
Sorting on all columns. Now the sorting is intended to hit the DB every time on click of "Coloum sort". Is there a way to make my Stored procedure dynamically do this. This was possible if I used a select query in the SQL call builder instead of a procedure.
- How do I force a DB call on click of Column Sort in the data grid
- How could I fetch the column name and ascending /descending values to pass it to the stored proc if my Stored proc is able to return sorted values based on these input parameters.
I intend to use Service Provider and Service Consumer approach for implementing the same. SQL call in the provider model with DCM at the consumer end would take care of formatting, labelling and a data page to display the table grid.On Column sort click, need to make a call to the provider model passing the column name and ascending/descending option.