Hello -
I am trying to figure out the best way to solve a request from my users. We have a search page (read-only interactive grid) that allows our users to search on anything on an underlying View. When they first open the search page, they don't want the page to auto-query. They want to be able to apply filters either through other page items on the page or from the column header filters or from the action menu/filter option. They also don't want it to query after these filters are selected or removed. They only want the query to happen when they click the Go Button.
I can accomplish part of this with a hidden page item that I use in the where clause to stop records from being return on page load as well as when other page items are filled in. The part I am struggling to figure out is when the column header filters, action menu filters are being used. I tried using a dynamic action on page change event for the interactive grid to set the hidden page item. This worked well as long as the user didn't use the pagination. Once a fetch of the next set of records happens when paginating with either scroll or setting the page per row, the query fails. Returning all rows isn't an option since the view has over a million rows.
I was attempting to find the right javascript selector on-click dynamic action similar to what I am doing for the Go button and do it for the pagination buttons. I thought if I could know when the users are clicking a pagination button, I could set the hidden page item appropriately. I am not good with javascript however and am not sure how to formulate this.
Does anyone have suggestions on what else I can do to make either pagination work or another way to stop the column header filters/action menu filters from querying without clicking the Go button?
Thanks in advance!