Reports With API Filters Launched From URL Link Lose Filter Criteria
We have several report buttons on dashboards and forms in our apps that are coded to call the report and also apply various filters in the URL. However, if the resulting report data set has more than one page of results, when a user clicks to see the next page of records, the report filters are lost when the screen refreshes. URL to load the report: https://hardermech.quickbase.com/db/bjjkii2fm?a=q&qid=227&query={9.EX.299008}AND{179.XEX.1}AND{281.LT.100} Table Name: Milestone Data Report 227 fid 9: [Job] fid 179: [Delete This Milestone] fid 281: [Scope % Comp] When I run this report the result is three pages of records. After I click on the link for the second page of records, the URL changes to this: https://hardermech.quickbase.com/db/bjjkii2fm?a=q&qid=227&qskip=50&qrppg=50 And now the report is showing all the unfiltered records (460 pages). One of the other developers, Jim, had a thought that maybe we could store and reference the filter criteria for the report in a javascript service worker, such that those values are stored in a stable location. Any insight on how to overcome this report behavior would be greatly appreciated! ------------------------------ Jon Froderberg PRIME Developer Harder Mechanical Contractors https://www.harder.com Portland, OR 503.382.4413 ------------------------------ #APIsandcustomcode #queryparameters #customreportbuttons
