302 Found

Found

The document has moved here.

Articles

Articles of interest to QuickBase folks

Referencing a Saved Query

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.

Comments

RE: 'How to query against a qid?'

Hi Rich,

 

You wouldn't actually "query against a query/qid", because the result would just be a more specific query. In your example, you could go into your app to biuld a report which only shows work orders 12345 and 23456, or you could use API_DoQuery (http://www.quickbase.com/api-guide/index.html#do_query.html) to manually build the report outside of QuickBase.

 

Thanks,

Brian

Intuit QuickBase

How to query against a qid?

This article (http://quickbase.intuit.com/developer/articles/referencing-saved-query) is fine if all you want to do is pull ALL the data from a QuickBase report. But what if you want to query against that report, e.g., ONLY work orders 12345 and 23456 from a report of ALL work orders? What to do?

Post new comment

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.
302 Found

Found

The document has moved here.