iGrid 11.5 column sort options
A simple question with probably a complex answer.
I have a iGrid based off a Xacute time-based query. The user would like the ability to click on a column header to resort the iGrid. That part is easy using the columnselectionevent and passing the columnName back to the transaction. This method executes the transaction on each header click.
I do not want the transaction to run on each header click though. QueryCaching I don't think is a option as this is a time-based query.
Any ideas out there.?
Jeremy Good replied
We missed you and Tom down in Nashville last week.
You are correct - QueryCaching is ignored in a Time Based query since it would lead to excessive cache objects, which would probably never be matched again by a subsequent user request.
Column sorting with Ctrl+Click on the Column Heading has been added to the iGrid in upcoming version 12.1, but of course that doesn't help you today.
Without running the Transaction again you could however leverage the /Illuminator/StyleSheets/GenericSortFilter.xsl transform and enable QueryCaching. If you map your Transaction date properties in the Param.x location and it will not know that it is time based, but you of course will lose the SD/ED buttons and VCR control buttons in the toolbar and potentially take charge of the date logic in the BLS too.
Then from the ColumnSelectionEvent if you set one of the XParamValue.x settings it will use the cached query results and just reapply the sorting xsl. (Look at the params at the top of the xsl file to see the parameter name settings needed to map into your Xacute Query template below the Transform)