Understanding Multiple Criteria


Concept


Steps:

  1. When your query includes multiple criteria, link them using either AND, AND NOT, OR, or OR NOT.

    Step 1
  2. By default, PeopleSoft Query assumes that you want rows that meet all of the criteria that you specify. When you add a new criterion, PeopleSoft Query displays AND in the Logical column.

     

    To link the criterion using one of the other options instead, select the appropriate option from the Logical list.

    Step 2
  3. The first criterion that you define does not have a value in the Logical column.

    Step 3
  4. Any rows after the first row must include either an AND or OR logical value to specify whether you want the rows to meet this criterion in addition to other criteria that you have defined or as an alternative criterion.

    Step 4
  5. The AND option in the Logical field returns rows of data if criteria are true. That means, when you link two criteria with AND, a row must meet the first and the second criterion for PeopleSoft Query to return it. 

     

    For instance, a query may want all employees and non-employees who are in the U.S. and those employees and nonemployees who have a capital D in their names.

    Step 5
  6. The AND NOT option does not return rows of data if the criteria are true.

     

    For instance, a query may want all employees and non-employees who are in the U.S. except for those employees and nonemployees who have a capital D in their names.

     

    The results are all from the U.S., none of whom have the letter D in their names.

    Step 6
  7. The OR option returns rows of data if any of the rows in the criteria are true. That means, when you link two criteria with OR, a row must meet the first or the second criterion, but not necessarily both.

     

    For instance, if OR is used in a query, it returns all employees and nonemployees who are in the U.S. or those having capital Ds in their names.

    Step 7
  8. The OR NOT option does not return rows of data if any of the rows in the criteria are true.

     

    For instance, if OR NOT is used in a query, it returns all employees and nonemployees who are in the U.S. and people whose names that don’t start with D even if they are not in the U.S.

    Step 8
  9. When your query includes multiple criteria, PeopleSoft Query checks the criteria according to the rules of logic: it evaluates criteria that are linked by ANDs before those that are linked by ORs.

     

    When all the criteria are linked by ANDs, this order always returns the correct results. When you include one or more ORs, however, this is not always what you want.

    Step 9
  10. Understanding how Query Manager processes criteria in a certain order based on the way in which the system applies Boolean expressions—enables you to retrieve the results that you need.

     

    Query Manager uses these rules when processing criteria.

    Step 10
  11. Grouping Criteria is another feature that you can use when adding criteria.

     

    When you have more than one criteria row, you can use the Group Criteria feature to control the order in which Query Manager runs the criteria row.

     

    The open and close parentheses in the appropriate text boxes on the Edit Criteria Grouping page indicate the criteria group.

    Step 11

You have successfully reviewed the Understanding Multiple Criteria topic.

Table of Contents  Start Topic