Finding Records in Standard R1 with Queries and Filters

Find records in Standard with an exact match or using parameters and limits. Standard’s query syntax is designed to read naturally, making it straightforward to build precise filters for any dataset.

Query Format

To find exact matching records, provide the constraint values in parentheses (without a +):

[std_name] (const1, const2, [...])

To find records using parameters, use angle brackets:

[std_name] <const1 val, const2 val, [...]>

To limit the number of results returned, add a LIMIT to your parameter query:

[std_name] <const1 val, const2 val, [...], LIMIT 5>

Examples

Find a vehicle by exact match across all constraints:

[vehicle] ("VINNUM", "Honda", "Accord", "Green")

Check the count of exact matches:

count [vehicle] ("VINNUM", "Honda", "Accord", "Green")

Find all Hondas using a parameter filter:

[vehicle] <make "Honda">

#Count all Hondas
count [vehicle] <make "Honda">

Find the first five Hondas, then narrow the results further:

[vehicle] <make "Honda", LIMIT 5>

#Get more specific
[vehicle] <make "Honda", model "Accord", LIMIT 5>

Finding with Conditions

Finding Standard conditions reads like English. Enter the condition keyword between the constraint name and its value:

[vehicle] <year GREATER THAN 1997, LIMIT 5>

The following conditions are available:

STARTS WITH
ENDS WITH
CONTAINS
GREATER THAN
GREATER THAN OR EQUAL TO
LESS THAN
LESS THAN OR EQUAL TO
AND
OR

Get Started

Infrastructure

Authentication

Standards

Records

Finding Records in Standard R1 with Queries and Filters

Query Format

Examples

Finding with Conditions

​Query Format

​Examples

​Finding with Conditions

Query Format

Examples

Finding with Conditions