TracCloudGuideListingsSymbols: Difference between revisions

"Search Symbols" can be utilized to specify how you want to search for data in TracCloud. Whether that be all MAT% registrations, or students of all Majors except for #Mathematics, these symbols should help to narrow down your search.

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 separated by a space, and the keyword should be quote protected. The example below shows the process for searching for Major and class.

Combining Multiple Symbols
Multiple symbols can be used at once as well. In the example below, we're searching for all students with a major that does not contain the phrase "Engineering." This would exclude students who have a major of Electrical Engineering, Chemical Engineering, Etc.

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
&&	And / Combine multiple searches at once. Only applies to Reports.	Major: #Mathematics&&#Biology
[null]	Search for a null value	#sql:In-State#=[null]
blankornull	Search for a blank OR null value, only applies to Power Search.	Student.Major: blankornull

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
...	Date range, used without specifying a field.	2021-01-01…2021-12-31

Special/Twig
Option	Description	Example
{{GetDatePlusDays(0)}}	Add or subtract days from the current date.	Visits.TimeIn=>"{{GetDatePlusDays(-20)}}"

@@ Line 1: / Line 1: @@
 {{TracCloudGuideTabs}}
-{| style="width:100%; vertical-align:top; "
+<div class="tcWidgetPage">
-| style="width:250px; vertical-align:top; padding:2px 15px 2px 2px;" | {{TracCloudGuideListingsTOC}}
+<div class="categoryWide">
-| style="vertical-align:top; padding:20px 20px 20px 2px;" |
+{{TracCloudGuideListingsTOC}}
-{| style="width:100%; vertical-align:top; "
+</div>
 <big><b>Search Symbols</big></b><br>
 "Search Symbols" can be utilized to specify how you want to search for data in TracCloud. Whether that be all <b>MAT%</b> registrations, or students of all Majors except for <b>#Mathematics</b>, these symbols should help to narrow down your search.
+<div class="line"></div>
+<big>Combining Multiple Searches</big><br>
+Multiple statements can be used in sequence to find records that match more than one value at a time. The searches are separated by a space, and the keyword should be quote protected. The example below shows the process for searching for Major <b>and</b> class.
+[[File:1822108.png|700px]]
+<div class="line"></div>
+<big>Combining Multiple Symbols</big><br>
+Multiple symbols can be used at once as well. In the example below, we're searching for all students with a major that does not contain the phrase "Engineering." This would exclude students who have a major of Electrical Engineering, Chemical Engineering, Etc.
+[[File:5979775.png|600px]]
+<div class="line"></div>
 <onlyinclude>
@@ Line 41: / Line 55: @@
 |-
 | ... || Date range, used without specifying a field. || 2021-01-01<b>…</b>2021-12-31
+|}
+{| class="wikitable"
+|+ Special/Twig
+|-
+! <b>Option</b> !! <b>Description</b> !! <b>Example</b>
+|-
+| <nowiki>{{GetDatePlusDays(0)}}</nowiki> || Add or subtract days from the current date. || <span style="color:grey">Visits.TimeIn=</span><b><nowiki>>"{{GetDatePlusDays(</nowiki></b>-20<b><nowiki>)}}"</nowiki></b>
 |}
 </onlyinclude>
-<hr>
-<big>Combining Multiple Searches</big><br>
-Multiple statements can be used in sequence to find records that match more than one value at a time. The searches are separated by a space, and the keyword should be quote protected. The example below shows the process for searching for Major <b>and</b> class.
-[[File:1822108.png|700px]]
-<hr>
-<big>Combining Multiple Symbols</big><br>
-Multiple symbols can be used at once as well. In the example below, we're searching for all students with a major that does not contain the phrase "Engineering." This would exclude students who have a major of Electrical Engineering, Chemical Engineering, Etc.
-[[File:5979775.png|600px]]
-|}
 [[Category:TracCloud]]
+</div>

TracCloudGuideListingsSymbols: Difference between revisions

From Redrock Wiki

Latest revision as of 10:59, 15 November 2023

Listings