I'm using a stored procedure to return objects to an Aware IM query:
Code: Select all
EXEC_SP 'sp_queryIndicators' RETURN Indicator
The objects are well displayed to my Aware application, but the filtering (using the single filter-field on top of the grid) nor the sorting (clicking on the column-header of the grid) doesn't work out.
My data is refreshed, but not filtered/sorted as requested.
Do I have any any possibility to get the current filter- or sorting-parameter from the context, so I could call something like:
Code: Select all
EXEC_SP 'sp_queryIndicators' WITH '@pFilter'=CURRENT_FILTER, '@pSort'=CURRENT_SORT RETURN Indicator
Or is there another workaround possible (e.g. persist the current filter / sorting into the LoggedInRegularUser context)?