Page 1 of 1

Automatically Set Filter After Load?

PostPosted: Mon Jun 03, 2019 3:43 pm
by Moebius01
Let me preface this by saying that I have not worked in php or general Web coding in about 13 years, so a lot of this is new, and the rest is taking its time coming back. That said, I'm trying to see if there's a method that could be applied to set a default filter once a record set is loaded.

I know I can set a filter for the query with the setConfig('sqlfilters' option, but in this case I'm trying to do it after the initial query returns. The idea being that I don't want to limit the number of records returned in the query, but want to initially limit the records displayed. Then the user could clear/change the filter if he needed to see additional rows. Is this possible?

Re: Automatically Set Filter After Load?

PostPosted: Tue Jul 09, 2019 10:54 am
by KarelB
HI

I don't think this possible from the configuration.

Solutions i can think of :
- All the filters are in the URL, decode the url and set the filter there and encode again.
- Do the normal query and use the filters on the page to get to the state you want and hand the users the complete url