TracCloudGuideListingsSymbols and Reports:Registrations by: Difference between pages

From Redrock Wiki

(Difference between pages)
No edit summary
 
No edit summary
 
Line 1: Line 1:
{{TracCloudGuideTabs}}
<!-- table for the whole page -->
{| style="width:100%; vertical-align:top; "
{| style="width:100%; vertical-align:top; "
| style="width:250px; vertical-align:top; padding:2px 15px 2px 2px;" | {{TracCloudGuideListingsTOC}}
 
<!-- include the TOC as a template in the first column -->
| style="width:300px; vertical-align:top; padding:2px 15px 2px 2px;" | {{ReportsGuideRegTOC}}
 
<!-- here is the second column of the full wiki page - will contain content -->
| style="vertical-align:top; padding:20px 20px 20px 2px;" |
| style="vertical-align:top; padding:20px 20px 20px 2px;" |
<!-- here is a table for the content of the page -->
{| style="width:100%; vertical-align:top; "
{| style="width:100%; vertical-align:top; "
<big><b>Search Symbols</big></b><br>
| style="vertical-align:top; font-size:160%; color:#7c1911; " | '''Registrations by ??''' <HR>
|-
| style="vertical-align:top; font-size:120%; " | <BR />The Registrations by Report will display the course and the student enrolled in the course with the visits on the left. Additional field can be included to the report for more information.
 
 
'''GENERATE THE REPORT'''
 
 
To generate the Registrations by, click on Reports from the TutorTrac Main Menu. On the Reports Chooser, select Registrations from the pull down list of available categories. After selecting Registrations, choose Registrations by. Choose center(s) and then enter a date range for the time period that you would like to review in the report. Then click on the Generate Report button.
 
 
 
[[File:Regby.png|border|700px]]
 
 
[[File:Regby1.png|border|700px]]
 
 
 


"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.


<onlyinclude>
{| class="wikitable"
|+ Alphanumeric
|-
! <b>Symbol</b> !! <b>Description</b> !! <b>Example</b>
|-
| % || Wildcard / Search for fields that contain this value. || <span style="color:grey">Students.First_Name=</span>Jo<b>%</b>
|-
| # || Not / Search for fields that don't match this value. || <span style="color:grey">Students.First_Name=</span><b>#</b>John
|-
| <nowiki>|</nowiki> || Or / Search for more than one value at a time. Only applies to Power Search. || <span style="color:grey">Students.Major: </span>Biology<b><nowiki>|</nowiki></b>Photography
|-
| [null] || Search for a null value || <span style="color:grey"><nowiki>#sql:In-State#=</nowiki></span><b><nowiki>[null]</nowiki></b>
|-
| blankornull || Search for a blank OR null value, only applies to Power Search. || <span style="color:grey"><nowiki>Student.Major: </nowiki></span><b><nowiki>blankornull</nowiki></b>
|}


{| class="wikitable"
|+ Numeric
|-
! <b>Symbol</b> !! <b>Description</b> !! <b>Example</b>
|-
|-
| > || Greater Than || <span style="color:grey">Duration=</span><b>></b>90
| style="width:100%;" |
|-
| < || Less Than || <span style="color:grey">Duration=</span><b><</b>90
|-
| <= || Equal to or Less Than || <span style="color:grey">Duration=</span><b><=</b>90
|-
| >= || Equal to or Greater Than || <span style="color:grey">Duration=</span><b>>=</b>90
|-
| ... || Date range, used without specifying a field. || 2021-01-01<b>…</b>2021-12-31
|}
</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 simply separated by a space. The example below shows the process for searching for Major <b>and</b> class.


[[File:4725369.png|700px]]
<!-- this table appears at the bottom of the manual page and contains a previous page and next page link -->
{| style="width:70%; vertical-align:top; "
| style="width:50%; text-align:left;" | [[Reports:Students List|&larr; Previous Page]]
| style="width:50%; text-align:right;" | [[Reports:Progress Report Listing|Next Page &rarr;]]




<hr>
<!-- here is the end of the previous / next page table -->
<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]]
<!-- here is the end of the content table -->
|}


<!-- this line is the end of the table for the entire page -->
|}
|}
__NOTOC__
[[Category:Trac 4]]

Revision as of 16:52, 24 April 2023


Registrations by ??

The Registrations by Report will display the course and the student enrolled in the course with the visits on the left. Additional field can be included to the report for more information.


GENERATE THE REPORT


To generate the Registrations by, click on Reports from the TutorTrac Main Menu. On the Reports Chooser, select Registrations from the pull down list of available categories. After selecting Registrations, choose Registrations by. Choose center(s) and then enter a date range for the time period that you would like to review in the report. Then click on the Generate Report button.


Regby.png


Regby1.png




← Previous Page Next Page →