Skip to main content

Advanced Job Parameters

Paige Freeman
  • Updated

The Advanced Job Parameters is a powerful feature that allows staff to filter batch jobs to their exact needs and specifications. The Advanced Job Parameter section displays on the Job Submission page for most batch jobs.

This topic contains the following sections:

There are some batch jobs where Advanced Job Parameters are not available. due to no view entry in the app_meta_View table for that job. For those jobs, the Advanced button will not display on the Job Submission page.

Accessing Advanced Parameters

To access advanced parameters for a batch job:

  1. From the Job Submission page for the job you wish to run, select Advanced from the Advanced Job Parameters section.

    The Advanced Job Parameters page displays, as shown below.
    The filters that display and the view and column names available are based on the selected batch job and will vary between batch jobs.
  2. If you would like to add a new filter, select +Add Filter.
    A new filter row is added to the grid, as shown below.
    1. Select the View Name, if necessary.
      This field will automatically populate with the default View.
    2. Select the Column Name.
      Available columns are based on the selected View.
    3. Select the Operator.
      The selected Operator will effect the field type of the Value field. For more information, please see Control Used Based on Datatype and Operator.
  3. You can easily tell which row you are in by the blue indicator to the left of the grid.
  4. Similarly, if upon saving a syntax error is found, the row in error will be indicated within the grid with a red row number.
  5. You can view and edit additional details for each row by clicking the expand arrow to the right of the grid.
  6. You can quickly insert a row or delete a row using the contextual menu within the grid, as shown below.

Technical Details

Following are technical details for the Advanced Parameter page.

Operators

Following are the operators available when adding a filter to the Advanced Parameters.

  • =
  • >
  • >=
  • <
  • <=
  • <>
  • !=
  • Between
  • Is Null
  • Is Not Null
  • In
  • Not In
  • Begins
  • Ends
  • Contains

Control Used Based on Datatype and Operator

The Datatype and Operator you select when adding a filter to the Advanced Parameters will effect the control/value field type. The table below describes the different control types that display based on the selected datatype and operator.

Data Type/Operator Control

For ‘Null’ or ‘Not Null’ Operator

Disabled Textbox
The value field is disabled, as there is no value that needs to be selected.

String Datatype (No List sql)

For ('In', 'Not In')

Textbox (comma separated value)

For all other operators

Textbox

String Datatype (List sql)

For ('In', 'Not In')

Find Chooser with Multiselect

For all other operators

Find Chooser with single select

Numeric Datatype (Data validation for Begins, Ends, and Contains Operator)

For ('In', 'Not In')

Textbox (comma separated) with numeric data validation

For Between

Two Textboxes (user can type only numeric and decimal)

For (=, >, >=, <, <=, <>, !=)

Textbox (User can type only numeric and decimal)

Date Datatype (Data validation for Begins, Ends, and Contains Operator)

For ('In', 'Not In')

Textbox (comma separated) with date data validation

For Between

Two Date Pickers

For (=, >, >=, <, <=, <>, !=)

Date Picker