API

Syndicate content
About the Sort Order Option

About the Sort Order Option

You can apply a different sort order to different returned columns in the clist by supplying several period delimited sort order params:

<options>sortorder-A.sortorder-D.sortorder-D.sortorder-A</options>

October 13th, 2009 - 2:10 PM
How Do I Construct a View?

How Do I Construct a View?

Detailed instructions for constructing views, reports, and queries are provided in the QuickBase online help.

October 13th, 2009 - 2:10 PM
The Components of a Query

A query typically includes the following parameters:

October 13th, 2009 - 2:10 PM
How to Supply the Query Parameter

The query parameter is the main parameter in a query because it determines which records will come back. In contrast, the other parameters affect the look of the query results or further narrow the query results in some way.

There are two ways to provide the query string:

October 13th, 2009 - 2:10 PM
Constructing the Query String

When you construct a query you must build at least one query string. A query string is composed of a field ID (fid), comparison operator, and the value to be compared against (see the table below for a list of available operators). Each of these components of the query string are separated by a period, and the whole query string enclosed in curly braces, like this:

October 13th, 2009 - 2:10 PM
Handling Special Characters for a Query Field Value

Handling Special Characters for a Query Field Value

What happens if you are querying for a value that has double quotes, for example, Joe B. Briggs? You need to double the quotes on each side, like this:

Joe B. Briggs

October 13th, 2009 - 2:10 PM
Querying on Dates and Times

Querying on Dates and Times

Notice that you can query on dates (yyyy-MM-dd) or on times in milleseconds, but you cannot query on date-time values in the standard format yyyy-MM-dd hh:mm:ss.

October 13th, 2009 - 2:10 PM
Special Matching Values in a Query String

Certain field types use special values with a given comparison operator. For example, what if you wanted to query on a checkbox? How would you specify only those records with the checkbox checked?(Answer: {'fid'.EX.'0'} for unchecked, {'fid'.EX.'1'} for checked: you need to replace fid with your checkbox field id.)

October 13th, 2009 - 2:10 PM
Referencing a Saved Query

October 13th, 2009 - 2:10 PM
API Calls That Dont Use the Application Token

The following calls use a ticket only, no application token:

October 13th, 2009 - 2:10 PM

© 2016 QuickBase, Inc. All Rights Reserved.

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