| Info |
|---|
Use the Cloudaware list view builder to customize existing default list views or create a new one from scratch. |
...
Select 'JSON field' type to filter the fields containing JSON data, pick the one under question and click Apply. You can also use JSONPath expressions in the box 'Field JSON Path' to focus your search.
  |   |
| Note |
|---|
JSONPath expressions start with $ and can contain the dot- (a) or the bracket-notation (b) for input paths: a) $.Fieldname[0].Fieldname b) $["fieldname"]["fieldname"][0]["fieldname"] - where [0] is the number of an element in the array.
|
...
equals | Use for an exact match |
not equal | Use for an exact match with a certain value excluded |
greater than | Use when you want results that exceed the value you enter |
greater or equal | Use for results that match or exceed the value you enter |
less than | Use for results that are less than the value you enter |
less or equal | Use for results that match or are less than the value you entered |
contains | Use for fields that include your search string |
not contains | Use to eliminate records that don’t contain the value you enter |
like | Use to locate records that include the exact value you enter or type % to include a certain part of the value entered, e.g. `Account`.`Account Name` like test will search for all account names containing test |
not like | Use to locate records that exclude the exact value you enter or type % to exclude a certain part of the value entered, e.g. `Instance Name or ID` not like %environ% will search for all instance names and IDs, except the ones containing -environ- |
starts with | Use for results that start with a certain value |
...