Forum Discussion
EvanWestbrook
6 years agoQrew Cadet
I work on Jon's team, and we wanted to share the resolution we found.
When one clicks to view the next Result Page on a multi-page query return, the parameters "qskip" and "qrppg" are appended to the end of the URL. This process overwrites any manual query parameters. This also occurs when sorting by a column header. We found that these parameters can be manually added into the URL for the report button.
For example:
Before:
https://YOURREALM.quickbase.com/db/YOURDBID?a=q&qid=113&query={29.EX.266501}AND{10.XEX.%27VOID%27}
After:
https://YOURREALM.quickbase.com/db/YOURDBID?a=q&qid=113&query={29.EX.266501}AND{10.XEX.%27VOID%27}&qskip=100&qrppg=100
https://YOURREALM.quickbase.com/db/YOURDBID?a=q&qid=113&query={29.EX.266501}AND{10.XEX.%27VOID%27}&qskip=100&qrppg=100&dlta=sd7~
We plan to add the qskip and qrppg parameters to our buttons with return parameters that meet the needs of our users. One can further customize URL based queries with the following parameters:
Query (q=)
------------------------------
Evan Westbrook
------------------------------
When one clicks to view the next Result Page on a multi-page query return, the parameters "qskip" and "qrppg" are appended to the end of the URL. This process overwrites any manual query parameters. This also occurs when sorting by a column header. We found that these parameters can be manually added into the URL for the report button.
For example:
Before:
https://YOURREALM.quickbase.com/db/YOURDBID?a=q&qid=113&query={29.EX.266501}AND{10.XEX.%27VOID%27}
After:
https://YOURREALM.quickbase.com/db/YOURDBID?a=q&qid=113&query={29.EX.266501}AND{10.XEX.%27VOID%27}&qskip=100&qrppg=100
https://YOURREALM.quickbase.com/db/YOURDBID?a=q&qid=113&query={29.EX.266501}AND{10.XEX.%27VOID%27}&qskip=100&qrppg=100&dlta=sd7~
We plan to add the qskip and qrppg parameters to our buttons with return parameters that meet the needs of our users. One can further customize URL based queries with the following parameters:
Query (q=)
- qskip (query skip)
- The smallest record index the page displays
- In our example, qskip=100 displays records starting on record index 101 out of 129
- qrppg (query records per page)
- How many records are displayed on the page
- In our example, qrppg=100 displays 100 records at a time.
- sd (sort down)
- The Field ID that is sorted (high to low)
- In our example, sd7~ sorts Field ID 7 high to low
- su (sort up)
- The Field ID that is sorted (low to high)
- In our example, sd7~ sorts Field ID 7 low to high
- ~
- Allows sorting by multiple fields
- For example, sd7~su8~ would sort by Field ID 7 high to low then by Field ID 8 low to high
------------------------------
Evan Westbrook
------------------------------