Understanding Comparison Values


Concept


Steps:

  1. Query criteria are like an equation. Like an equation, query criteria consist of a left side, an operator, and a right side.

     

    This diagram shows the comparison between equation and query criteria.

    Step 1
  2. The Choose Expression 1 Type group box determines whether the first part of the selection criteria is based on a field or an expression.

    Step 2
  3. If the value of Choose Expression 1 Type is Field, the value in the selected field is compared to the value in another field, usually a field in another record component.

    Step 3
  4. If the value of Choose Expression 1 Type is Expression, the value in the selected field is compared to an expression that you enter, which PeopleSoft Query evaluates once for each row before comparing the result to the value in the selected field.

    Step 4
  5. The Expression 1 group box contains the value for the first part of the selection criteria.

    Step 5
  6. The Condition Type group box determines how Query Manager compares the values of the first expression to the second expression.

    Step 6
  7. The Choose Expression 2 Type group box determines whether the second part of the selection criteria is based on a field, an expression, a constant, a prompt, or a subquery.

    Step 7
  8. The equal to condition finds rows of data with values that matches the constant that you specify in the Choose Expression 2 Type section.

     

    As shown in this example, there are five expression 2 types available when you select the equal to condition type.

    Step 8
  9. The like condition retrieves data that matches a portion of a character string.

     

    This diagram shows the expression 2 types when you select the like condition type.

    Step 9
  10. Use the between condition to filter data based on a range of two values that you specify in expression 2.

     

    This diagram shows the expression 2 types when you select the between condition type.

    Step 10
  11. Trees depict hierarchical structures that represent a group of summarization rules for a particular database field.

     

    The in tree condition provides access to Oracle PeopleSoft Tree Manager to retrieve hierarchical data for the query.

     

    This diagram shows the expression 2 types when you select the in tree condition type.

    Step 11
  12. The Expression 2 group box contains the value of the second part of the selection criteria.

    Step 12
  13. When you select Field as the comparison value in the Choose Expression 2 Type group box:

    • The Choose Record and Field section appears.

    • The Record Alias field lists all the records that are part of the current query.

     

    If you select the record and the field, the selected field name appears in the second Expression column of that field’s row.

    Step 13
  14. When you select Expression as the comparison value in the Choose Expression 2 Type group box, the Define Expression section appears.

     

    In the text box, enter a valid SQL expression.

     

    To add a field or user prompt to the expression, click the Add Field or Add Prompt link, respectively.

    Step 14
  15. When you select the Constant option as the comparison value in the Choose Expression 2 Type group box:

    •  The value in the selected field is compared to a single fixed value.

    •  The Define Constant section appears.

        In the text box, enter the value that you want to compare the first expression to. To add a value by selecting it from a list, click the Look Up button to display the Select a Constant page.

    Step 15
  16. When the Prompt option is selected, the value in the selected field is compared to a value that you enter when running the query.

     

    When you select Prompt as the comparison value, the Define Prompt section appears.

     

    Click the New Prompt link to move to the Edit Prompt Properties page. To modify an existing prompt, click the Edit Prompt link.

    Step 16
  17. If the Subquery option is selected, the value in the selected field is compared to the data that is returned by a subquery.

     

    When you select Subquery as the comparison value, the Define Subquery page appears.

     

    Click the Define/Edit Subquery link to move to the Records page to start a new query.

    Step 17
  18. If the in list option is selected, the value in the selected field is compared to a list of values that you enter.

     

    This value type is available only when the condition type is in list or not in list.

    Step 18
  19. When you select the in list option as your comparison value, the Edit List section appears.

     

    Use the Look Up button to display the Edit List page and search for the desired values.

    Step 19
  20. When the Tree Option is selected, the value in the selected field is compared to a selected set of tree nodes.

     

    This value type is available only when the condition type is in tree or not in tree.

    Step 20
  21. When you select the Tree Option as the comparison value, the Select Tree Node List section appears.

     

    Use this section to create a list of values for PeopleSoft Query to compare to the value from the first expression.

    Step 21

You have successfully reviewed the Understanding Comparison Values topic.

Table of Contents  Start Topic