Data Selection

Use data selection to limit the number of records that are retrieved from the JD Edwards EnterpriseOne database. Define data selection to include only specific, relevant records in the detail section. For example, define data selection to display records for hourly employees only.

JD Edwards EnterpriseOne filters data in a detail section by any column that is included in the attached business view, regardless of whether you included the column in the section layout.

Define data selection using options that are available for each of these components:

• Operator

  The operator for the first line of the data selection is Where. You have a choice between And and Or for additional lines of data selection.

• Left operand

  The left operand must be a column from the attached business view.

• Comparison

  • is equal to.

  • is equal to or empty.

  • is greater than.

  • is greater than or equal to.

  • is less than.

  • is less than or equal to.

  • is not equal to.

• Right operand

  The options that are available in the right operand column depend on the selection that you made in the comparison column.

  This table identifies the available options:

  Option	Description
  <Blank>	Enters a blank (space) value.
  <Literal>	Enables you to enter specific values.
  <Null>	Indicates that no value is associated with the field.
  <Zero>	Enters a value of zero.
  BC	Indicates a business view column.
  RI	Indicates a value that is passed through a report interconnect to this report.
  PC	Indicates a previous business view column.
  PO	Indicates a processing option value that is available for this report.
  PV	Indicates the previous value for the variable.
  RC	Indicates a constant from this report.
  RV	Indicates a variable from this report.
  SV	Indicates a system variable.
  SL	Indicates a system value.
  TV	Indicates a text variable.
  VA	Indicates an event rule variable.

When you select the Literal option for the right operand, the system presents you with a Single value form. This form includes tabs that are based on the comparison option that you selected. The tab options might include:

• Single value

  Indicates a single value such as company 00060.

• Range of values

  Indicates a range of values such as companies 00001 to 00060. When using a range of values, the only valid comparisons are is equal to and is not equal to.

• List of values

  Indicates a list of values that are not sequential. You must click Add or press Enter after each entry. To delete a value, select the value and then click Delete.

  A list of values might include several user-defined codes for search types such as C for Customers, E for Employees, and V for Suppliers. When you are using a list of values, the only valid comparisons are is equal to and is not equal to.

You can lock the data selection that you define by individual row. Click the data selection row to highlight it. Right-click the row and select Advanced from the menu. On the Data Selection Protection form, select the Locked option.

The user can clear the locked option from the JD Edwards Batch Versions application, from either the Row menu or at runtime. The locked option sends a visual to the user that the defined data selection might be required for the report to function as designed. The locked option is particularly beneficial when a section of the report adopts it's data selection from another section.