Ascending/Descending is not working on query using EXEC_SP

himanshu

Hi,

I have found a serious issue in my development in Queries. When we create a new query on run-time the sorting of column ascending/descending or searching via filters works nicely. But when using EXEC_SP to fetch some complex data inside query has issue with sorting Ascending/Descending on the query grids.

I not able to sort or even filter data in the grid.

I assume whenever a query show the data into grid it store temp somewhere and whatever action or sorting of column do it make it works on client side.

please help or suggest.

yuri.rj

Had the same problem, but i think that your procedure is responsible for ordering and filtering...
I don't know if there is a solution to this, but i would like to know too...

Cheers

himanshu

But i think when query grid is invoked it call fetch the records and store temp on client side and action like search and sorting are performed on it.

if this it is not then could be a big issue for me.

himanshu

Hi Support Team,

Can you please help and advice?
None of our query grid forms are working when Stored Procedures are used and we have used SPs at most of the places. Need your inputs.

himanshu

https://www.awareim.com/forum/d/6634>

himanshu

himanshu wrote
https://www.awareim.com/forum/d/6634>

SP_EXEC Query: filter & sorting context>

aware_support

Yes, this is a limitation - standard sorting does not work for queries implemented as stored procedures.

himanshu

Thanks support for the reply. How about filteration as it is working on top right magnifier feature but does not work when filter are on the header of column grid.