Forum Post: RE: sorting performance with joined tables

  • Thread starter Thread starter pauldownie
  • Start date Start date
Status
Not open for further replies.
P

pauldownie

Guest
Thank you. I'm not sure this is what you had in mind but I was thinking along the lines of using the getQueryColumns and getQuerySort methods to determine if there is a filter active and what fields are in the sort. It seems that if I use an override on the applyFilter in the smartFilter I'll either be too early to determine what filter criteria is about to be applied or too late to stop the query from executing with the sort. The best I have been able to come up with is to use the CHOOSE OF btnBlank trigger on the smartFilter to publish an event and determine at that time whether I need to clear the sort. It will mean that the sort will be lost regardless of whether new filter criteria was entered before the filter was applied but I think I can live with it.

Continue reading...
 
Status
Not open for further replies.
Back
Top