TracCloud: Search Symbols
From Redrock Wiki
Listings
Search Symbols
Search symbols can be used
| Symbol | Description | Example |
|---|---|---|
| % | Wildcard / Search for fields that contain this value. | Students.First_Name=Jo% |
| # | Not / Search for fields that don't match this value. | Students.First_Name=#John |
| | | Or / Search for more than one value at a time. Only applies to Power Search. | Students.Major: Biology|Photography |
| [null] | Search for a null value | #sql:In-State#=[null] |
| Symbol | Description | Example |
|---|---|---|
| > | Greater Than | Duration=>90 |
| < | Less Than | Duration=<90 |
| <= | Equal to or Less Than | Duration=<=90 |
| >= | Equal to or Greater Than | Duration=>=90 |
| ... | Range - (Dates only) | YYYY-MM-DD…YYYY-MM-DD |
| Combination | ||
| # = %% | Don’t Include This Data | Centers.Name=#%Learning% |
Combining Multiple Searches
Multiple statements can be used in sequence to find records that match more than one value at a time. The searches are simply separated by a space. The example below shows the process for searching for Major and class.
Combining Multiple Symbols
-