> ## Documentation Index
> Fetch the complete documentation index at: https://docs.standardcomputers.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Finding Records in Standard R1 with Queries and Filters

> Query Standard records with exact matching, parameter-based filters, limits, and English-language conditions like GREATER THAN and CONTAINS.

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 `+`):

```text theme={null}
[std_name] (const1, const2, [...])
```

To find records using parameters, use angle brackets:

```text theme={null}
[std_name] <const1 val, const2 val, [...]>
```

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

```text theme={null}
[std_name] <const1 val, const2 val, [...], LIMIT 5>
```

## Examples

Find a vehicle by exact match across all constraints:

```text theme={null}
[vehicle] ("VINNUM", "Honda", "Accord", "Green")
```

Check the count of exact matches:

```text theme={null}
count [vehicle] ("VINNUM", "Honda", "Accord", "Green")
```

Find all Hondas using a parameter filter:

```text theme={null}
[vehicle] <make "Honda">

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

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

```text theme={null}
[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:

```text theme={null}
[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`