Skip to Navigation

Reply to comment

What is a saved query? In the QuickBase UI, a user customizes a report (a query is called a report in the UI) by selecting Customize->Reports. After the user saves this as a shared report, it becomes available to you as a query, assuming that there is no role restriction in place. For lack of a better term, we call this a saved query. Each saved query has an ID (qid) and also a user-supplied name (qname).

Creating a saved query can be an easy and quick way to construct a query, compared to constructing a query string yourself.

To use a saved query, you just refer to it by its qid (e.g., <qid>3</qid>) or by the name you gave it when you saved it (e.g., <qname>My Custom View</qname>. For the qname value, notice that you dont replace blank space between words with underscore.

How do you get a querys qid or qname? Any invocation of API_DoQuery that uses the <fmt> param set to structured will return a list of all saved queries inside a <queries> aggregate, including their qid and qnames. You can also use API_GetSchema to get the qid or qname.

QuickBase tables have two default saved queries: List All, and List Changes.


The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit