Logo: Wesleyan University
  • Tools
    • WesPortal
    • Directory
    • Library
    • OneStop
    • WesConnect
    • Calendar
    • WesMaps
    • WFS
    • Moodle
    • EMS
    • GApps
  • About
  • Admission & Financial Aid
  • Academics
  • Campus
  • Athletics
  • Give
  • Students
  • Alumni
  • Parents

Student Faculty Information System

PeopleSoft Campus Solutions

Feed on
Posts
Comments

Criteria Properties

Edit Criteria Properties Page

The Edit Criteria Properties page is the page on which you define the criteria for your query.

Edit Criteria Properties Page - simple

  • In addition to accessing the Edit Criteria Properties page from the Criteria page (by clicking on Add Criteria), you can also access it as follows:
  • On the Query page – Click the Use as Criteria button ()
  • On the Fields page or the Expressions page – Click the Add Criteria button ()
  • If the Expression 1 Field is an Effective Date field, there are additional special Effective Date operators that you can select.

 


Elements on the  Edit Criteria Properties Page

Choose Expression 1 Type

  • Determines whether the first part of the selection criteria is based on a field or an expression.
    • Field – Another field’s value that you want to base the selection criterion on.  This is usually a field in another record.
    • Expression – An expression which Query uses to evaluate before comparing the result to the value in the selected field.

Expression 1 (Choose Record and Field)

  • Contains the value of the first part of the selection criteria.

Condition Type

  • Determines how Query Manager compares the first expression value to the second expression value.
    • It contains a dropdown list of operators (see Condition Type chart below).
    • For each of the condition types, Query Manager offers a “not” option that reverses its effect.
      • For example, “Not equal to” returns all rows that “Equal to” would not return.
      • Note that it is always better to use the “Not” version of an operator rather than the NOT operator on the entire criterion.
      • When you use NOT, PeopleSoft Query cannot use SQL indexes to speed up the data search.
      • When you use the “Not” version of an operator, PeopleSoft Query can translate it into a SQL expression that enables it to use the indexes.

Choose Expression 2 Type

  • Determines whether the second part of the selection criteria is based on a field, an expression, a constant, a prompt, a subquery, and so on.
    • Field – Another field’s value that you want to base the selection criterion on.  This is usually a field in another record.
    • Expression – An expression which Query uses to evaluate before comparing the result to the value in the selected field.
    • Constant – A single, fixed value.
    • Prompt – A prompt value
    • Subquery – The value in the selected field is compared to the data returned by a subquery.

Expression 2 (Choose Record and Field)

  • Contains the value of the second part of the selection criteria.


 Condition Type:

The options for selecting the appropriate Operator (Condition Type) are summarized in the following chart:

Go to top

Comments are closed.