JSONPath Custom Consistency Check Query Examples

Use these examples to help you write valid JSONPath custom consistency check queries.

This query selects all permission entries under presentationTable where accessor is “Authenticated User” and access is “NO_ACCESS”.
```
$.presentationTable.permissions[?(@.accessor == "role:AuthenticatedUser" && @.access == "NO_ACCESS")]
```
This query selects presentationTable objects whose name field contains the substring “1”, “2”, or “3”. This query locates duplicate objects.
```
$.presentationTable[?(@.name contains '1'|| @.name contains '2'|| @.name contains '3')]
```
This query selects all logicalColumns of a logicalTable where dataType equals “VARCHAR”.
```
$.logicalTable.logicalColumns[?(@.dataType == 'VARCHAR')]
```
This query like the previous query selects all logicalColumns of a logicalTable where dataType equals “VARCHAR”, but uses different syntax.
```
$..logicalColumns[?(@.dataType == 'VARCHAR')]
```
This query selects all logicalLevels across the document whose name equals “Offices Company”.
```
$..logicalLevels[?(@.name == 'Offices Company')]
```
This query selects all permissions anywhere whose accessor starts with “roleBI:” (requires startsWith support or an approved alternative).
```
$..permissions[?(@.accessor contains "role:BI")]
```
This query selects all physicalMappings across the document where logicalTableSource equals “LTS1 Offices”.
```
$..physicalMappings[?(@.logicalTableSource == "LTS1 Offices")]
```