Query

• Click Action… and select Add Condition. Add Condition screen displays.

A condition is like a mathematical formula. It looks at each record to be included in query, and compares it to the condition. If it matches the condition, it is included in query.

A condition has three main parts:

Part 1 - Property in query to examine.

Part 2 - Mathematical operation to use such as Equal or Not Equal

Part 3 - Value to use as criteria of a match.

Part 1

• Click Object and select. Only objects added to query are available for selection.

• Click Property and select. Any property of object may be used, not just properties added to query.

Part 2

Set mathematical operation by using Not and Operator columns together. Selecting Not just adds a Not before operator. For example, if Operator is set to Equal To and Not is selected, operation is set to Not Equal To.

• Click Not and select.

• Click Operator . Selections are:

• • Contains means property selected must contain value entered. For example, if Email was selected as property and value entered was yahoo, report would list all students with an e-mail address that contained letters yahoo anywhere ([email protected], [email protected], etc.) If Not was added, it would list all e-mail address that didn’t have yahoo in it ([email protected], [email protected], etc.)

  • Equal To means property selected must be exactly same as value entered. For example, if Home Language was selected as property and value entered was English, report would list all students whose Home Language was English. If Not was added, it would list all students whose Home Language was not English.

  • Ends With means property selected must end with value entered. For example, if section ID were created with Course and Period option and 01 was entered as value for section ID property in a report, report would list all sections for period 01. If Not was added, report would list all sections not in period 01.

  • Greater or Equal means property selected must be greater than or equal to value entered. For example, if Expected Graduation Year was selected as property and value entered was 2009, report would list all students with an expected graduation year of 2009 or greater (2009, 2010, etc.). If Not was added, report would list only students with an expected graduation year of 2008 or lower.

  • Greater Than means property selected must be greater than value entered. For example, if Expected Graduation Year was selected as property and value entered was 2009, report would list all students with an expected graduation year of 2010 or greater (2010, 2011, etc.). If Not was added, report would list only students with an expected graduation year of 2009 or earlier.

  • In List means property selected must include one of values entered in Value field. List values are entered in Value box separated by a comma. For example, if Grade was selected as property and values entered were 1, 2, 3, report would list all students in grades 1, 2, or 3. If Not was added, report would list students were not in grades 1, 2, or 3.

  • Less Than or Equal means property selected must be less than or equal to value entered. For example, if Age was selected as property and value entered was 15, report would list all students 15 or younger (15, 14, etc.). If Not was added, report would list only students older than 15 (16, 17, etc.)

  • Less Than means property selected must be less than value entered. For example, if Age was selected as property and value entered was 15, report would list all students younger than 15 (14, 13, etc.). If Not was added, report would list only students 15 or older (15, 16, 17, etc.)

  • Starts With means property selected must start with value entered. For example, if Enter Code was selected as property and value entered was R, report would list all students whose enter code started with R (R1, R2, R3, etc.). If Not was added, it would list all students with enter codes that didn’t’ start with R (E1, E2, etc.)

Part 3

• Click Type and select type of value to be compared. Type selections are:

• • Value (most common option)  is actual contents of property such as numbers or letters.

  • Property is status of property, such as an error code.

• Enter Value to use for condition. Value can be numbers or letters, and it is not case-sensitive.

• • Enter date formats MM/DD/YY or MM/DD/YYYY.

  • Enter either Code or its Description when using a value from a drop-down list. For example, for Gender enter either M or Male. When entering a value for a property with a checkbox, use Y for checked or N for not checked.

• Click .

Conditions are added as an “AND” condition group by default. An “AND” condition group means records must meet all of conditions in group to be included in query. The first condition must always be an “AND” condition group. Once initial condition has been added, “OR” condition groups can also be added. An “OR” condition group means that records must only meet one of conditions in group to be included in query.

To add another Condition Group

• Click Action … and select.

• Check New Group when saving a new condition, and select type of group from Condition Group Type .

Groups can be nested, and an unlimited number of groups and conditions can be added to create very complicated conditions. An example of a nested condition group is shown below. This grouping means records in query must have a birth date less than 9/1/1995 AND a birth country containing Canada OR US.

• Click existing condition under which to create a new group.

• Click Action… and select Add Condition to CONDITION.

• In Add Condition screen, enter new condition.

• Check New Group?.

• Click Condition Group Type and select to create new group with new condition.

To add a condition to an existing condition group

• Click group (AND) or (OR).

• Click Action… and select Add Condition to GROUP.

• In Add Condition screen, enter new condition.

• Click . New condition is added to selected group.