302 Found

Found

The document has moved here.

Articles

Articles of interest to QuickBase folks

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.)

These special Matching Values are not always obvious, so we put them in the following table:

 

Field Type

Matching Value

Description

CheckBox

1

or

0

Used to filter records by the checked or unchecked status of the checkbox.
1 = Is checked
Example: {'17'.EX.'1'}

0 = Is unchecked
Example: {'17'.EX.'0'}

Date and Date/Time

today

or

<num> days ago

or

-<num> days ago

or

mm-dd-yyyy

Filter records by a date criteria.

today = Todays date. Example:{'13'.EX.'today'}

Number of days in the past as measured by the current date. Example: {'13'.EX.'2 days ago'}

Number of days in the FUTURE as measured from the current date, with a negative sign in front of the number to denote the future-ness of the date. Example: for tomorrows date, {'13'.EX.'-1 days ago'}

A specific date. For example: {'13'.EX.'05-18-2008'}

user

_curuser_

Used to get records owned or created by the current user.

For example, {'20'.TV.'_curuser_'}

Comments

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.