TracCloudGuideListingsSymbols: Difference between revisions

From Redrock Wiki

(Created page with "{{TracCloudGuideTabs}} {{TracCloudGuideListingsTOC}} <big><b>Search Symbols</big></b><br> Search symbols can be used {| class="wikitable" |+ Alphanumeric |- ! <b>Symbol</b>...")
(No difference)

Revision as of 12:25, 17 November 2021

Search Symbols

Search symbols can be used

Alphanumeric
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]
Numeric
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.

File:4725369.png



Combining Multiple Symbols
-