http_api

Syndicate content
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
Column List (clist) Parameter

The clist specifies which columns will be included in each returned record and how they are ordered in the returned record aggregate. Heres what a clist looks like:

<clist>4.7.9.11</clist>

or in URL-ese:

October 13th, 2009 - 2:10 PM
How to Return ALL of the columns

Specify the value a in the clist param to get all the columns returned.

October 13th, 2009 - 2:10 PM
Sort List (slist) Parameter

Sort List (slist) Parameter

The slist determines the order in which the returned records are displayed. Heres what an slist looks like:

<slist>7</slist>

October 13th, 2009 - 2:10 PM
Options Parameter

You use the options parameter to further control the return of records. You can use any or all of the options, separating the options with a period. Here are the available options:

October 13th, 2009 - 2:10 PM
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

© 1997-2014 Intuit Inc. All Rights Reserved.

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