These symbols are exceptionally helpful in areas such as inventory when the ability to find anything on hand greater than zero is needed.
These search commands are not programmable by Pacific Solutions as they are hard coded by Claris/FileMaker
Looking for | Symbol | Definition | Example |
Less Than | < | Less than a specified value for alpha/numeric/date | Less than 20: <20 |
Greater Than | > | Greater than a specified value for alpha/numeric/date | Greater than 20: >20 |
| Less than or equal to | <= | Less than or equal to a specified value for alpha/numeric/date | Less than or equal to 20: <=20 |
Greater than or equal to | >= | Greater than or equal to a specified value for alpha/numeric/date | Greater than or equal to 20: >=20 |
Exact Match | = | Specified whole words | "Interiors" located in all names: =interiors |
Range | ... | Data within a specified range | Created between 1/1 and 1/31 2014: 1/1/14...1/31/14 |
| Duplicate | ! | Multiple Exact Matches | duplicate entries: ! |
Today's Date | // | current date stamp in the search field | All items created today: // |
One Character | @ | Wild Card Character | Find Grey and Gray in customer names: gr@y |
| Zero or Unknown Characters | * | Variable Characters in a row | Find misspellings of Calgary: Cal*y |
Literal Text | "" | A sequence of characters in a row | Find a sequence of 'ander' in the name: "ander" |
Field Content Match | == | Data exactly as specified | all exactly 20 and not at 20=: ==20 |
Index | Ctrl+i | Values used or entered in the field | All values used in the manufacturer field: ctrl+i |