Configuring Advanced Conditions

Select System Configuration > System Management to view the Common Profile Configuration screen.

Tip:

The Common Profile folder appears in a tree-view on the left panel. The components are categorized as folders. Each folder contains all the field labels associated with that section.

To configure the rows to display on each page of an advanced condition screen, click the Advanced Conditions folder in the left panel.

Field Descriptions

The following table lists and describes the fields in Advanced Conditions Configuration.

Field or Control Name Description

Number of rows to display per page on the Advanced Condition Search screen

Enables you to specify the number of rows to be displayed on the Advanced Condition search screen.

Comma separated list of allowable parameters for custom advanced conditions

This feature allows the Advanced conditions to store and execute customer SQLs containing bind variables through the UI. The application supports the bind variables defined in a comma separated format. The bind variables defined here are case insensitive. This switch supports a maximum length of 1000 characters.

In OOTB configuration, the following bind variables are supported:

  • P_CASE_ID
  • P_SEQ_NUM
  • P_REG_RPT_ID
  • P_REG_REPORT_ID
  • P_REPORT_FORM_ID

Use the following procedure to configure Advanced Conditions.

  1. Enter the Number of rows to display per page on the Advanced Conditions Search screen.
  2. Click Save to save the changes made.