2014-501 – Query Search Symbols in OPTO

Query search options:

Symbol Search Field that Example Result
[] followed by data criteria Containing data []ABC Finds all items in the selected field containing ABC
] followed by data criteria Starting with ]ABC Finds all items in the selected field starting with ABC
[ followed by data criteria Ending with [ABC Finds all items in the selected field ending with ABC
;  separates data criteria Matching either data ABC;200MM Finds all items which contains either ABC or 200MM
> followed by data criteria Data greater than This could be in relation to measurement, dates, or a number sequence.
< followed by data criteria Data less than
<>”or <>”” Data field not empty Find all selected fields that have data.
=”or =”” Data field empty Finds all selected fields that are empty in the selected records.
>= ???&<=??? All data equal to or greater than the first data and less than or equal to the second data.
By All data in alpha or numeric order
By-dsnd All data in descending order
By1 All data sorted by this field first
By2 All data sorted by this field second