SDS:Advanced search.php - Revision history

Chris.kloosterman: moved SDS advanced search.php to SDS:Advanced search.php

2011-05-30T20:38:01Z

moved SDS advanced search.php to SDS:Advanced search.php

← Older revision	Revision as of 13:38, 30 May 2011
(No difference)

Chris.kloosterman: 4 revisions

2011-04-04T22:34:02Z

4 revisions

New page

This page lets you search and create lists for very specific criteria concerning students, parents, and addresses.

==Adding Search Terms==
When you first come to the page, you will see a drop-down list, and a button that says "Add search term". The list contains every criterion that it's possible to search on, and is grouped by student properties, parent properties, and address properties. To add a search term, decide what criterion you want to search on, select it and hit the button. You can continue doing this until you've selected all the criteria you want.

==Configuring Search Terms==
===Specifying Search===
Each search term has an operator list and a term box. The operator list contains such options as "=", "≠", ">", "<", etc. The term box is either an empty textbox or a list, to the right of the operator.

To make sure your term is constructed correctly, just try reading the line out loud. For example:

<blockquote><code>'''student:''' legal_first_name > M</code></blockquote>

Means "the student's legal first name is (alphabetically) greater than the letter M".

===Relating Terms===
If you have more than one search term, subsequent terms will also have a relation list in front of them, with the options of "And" or "Or". By default, these will all be set to "And", and therefore all of the search terms will be required to be true. If you set some of these to "Or", you will create groups of optional search terms. For example:

<blockquote><code>
term1 
AND term2 
OR term3 
OR term4 
AND term5</code></blockquote>

Is evaluated as:

<blockquote><code>term1 AND (term2 OR term3 OR term4) AND term5</code></blockquote>

==Hints==
Hit "Delete" to remove a search term.

If you want to search only for enrolled students, add "status" as one of the search terms.

The results will be formatted differently, depending on whether you're searching for student, parent, or address information. If you have terms relating to more than one of these, you will have another list next to the search button, entitled "Show results for", which lets you choose the output format.

From the results page, press the "Back" link at the bottom of the page, instead of the Back button in your browser.

TimeStamp dates should be selected from date dropdowns.
e.g. TimeStamp > 1-January-2009 will give you all the addresses that have been changed or created since January 1st, 2009.

==Example==
If you want to get a list of all the addresses belonging to enrolled students who live in Victoria, and were either born before 1991 or are in grade 8:
# Select "status" under the "student" header, and hit "Add search term".
# Do the same with "birth_date" under the "student" header.
# Do the same with "grade" under the "student" header.
# Do the same with "city" under the "address" header.
# The first term defaults to "<code>'''student:''' status = Enrolled</code>", so leave this as it is.
# Set the second term to "<code>And '''student:''' birth_date < 1-January-1991</code>".
# Set the third term to "<code>Or '''student:''' grade = 8</code>".
# Set the fourth term to "<code>And '''address:''' city = Victoria</code>".
# Set "Show results for" to "address".
# Click "Search!".

Richard.stern: /* Hints */

2009-11-06T00:22:56Z

Hints

← Older revision		Revision as of 17:22, 5 November 2009
Line 36:		Line 36:

	From the results page, press the "Back" link at the bottom of the page, instead of the Back button in your browser.		From the results page, press the "Back" link at the bottom of the page, instead of the Back button in your browser.

			TimeStamp dates must be of the format "YYYY-MM-DD HH:MM:SS". You may omit the clock and just use YYYY-MM-DD.
			e.g. TimeStamp > 2009-01-01 will give you all the addresses that have been changed or created since January 1st, 2009.

	==Example==		==Example==

10.20.10.78 at 18:57, 23 June 2006

2006-06-23T18:57:13Z

← Older revision		Revision as of 11:57, 23 June 2006
Line 34:		Line 34:

	The results will be formatted differently, depending on whether you're searching for student, parent, or address information. If you have terms relating to more than one of these, you will have another list next to the search button, entitled "Show results for", which lets you choose the output format.		The results will be formatted differently, depending on whether you're searching for student, parent, or address information. If you have terms relating to more than one of these, you will have another list next to the search button, entitled "Show results for", which lets you choose the output format.

			From the results page, press the "Back" link at the bottom of the page, instead of the Back button in your browser.

	==Example==		==Example==

10.20.10.78 at 18:54, 23 June 2006

2006-06-23T18:54:31Z

New page

This page lets you search and create lists for very specific criteria concerning students, parents, and addresses.

==Adding Search Terms==
When you first come to the page, you will see a drop-down list, and a button that says "Add search term". The list contains every criterion that it's possible to search on, and is grouped by student properties, parent properties, and address properties. To add a search term, decide what criterion you want to search on, select it and hit the button. You can continue doing this until you've selected all the criteria you want.

==Configuring Search Terms==
===Specifying Search===
Each search term has an operator list and a term box. The operator list contains such options as "=", "≠", ">", "<", etc. The term box is either an empty textbox or a list, to the right of the operator.

To make sure your term is constructed correctly, just try reading the line out loud. For example:

<blockquote><code>'''student:''' legal_first_name > M</code></blockquote>

Means "the student's legal first name is (alphabetically) greater than the letter M".

===Relating Terms===
If you have more than one search term, subsequent terms will also have a relation list in front of them, with the options of "And" or "Or". By default, these will all be set to "And", and therefore all of the search terms will be required to be true. If you set some of these to "Or", you will create groups of optional search terms. For example:

<blockquote><code>
term1 
AND term2 
OR term3 
OR term4 
AND term5</code></blockquote>

Is evaluated as:

<blockquote><code>term1 AND (term2 OR term3 OR term4) AND term5</code></blockquote>

==Hints==
Hit "Delete" to remove a search term.

If you want to search only for enrolled students, add "status" as one of the search terms.

The results will be formatted differently, depending on whether you're searching for student, parent, or address information. If you have terms relating to more than one of these, you will have another list next to the search button, entitled "Show results for", which lets you choose the output format.

==Example==
If you want to get a list of all the addresses belonging to enrolled students who live in Victoria, and were either born before 1991 or are in grade 8:
# Select "status" under the "student" header, and hit "Add search term".
# Do the same with "birth_date" under the "student" header.
# Do the same with "grade" under the "student" header.
# Do the same with "city" under the "address" header.
# The first term defaults to "<code>'''student:''' status = Enrolled</code>", so leave this as it is.
# Set the second term to "<code>And '''student:''' birth_date < 1991-Jan-01</code>".
# Set the third term to "<code>Or '''student:''' grade = 8</code>".
# Set the fourth term to "<code>And '''address:''' city = Victoria</code>".
# Set "Show results for" to "address".
# Click "Search!".