Advanced Job Parameters Paige Freeman April 14, 2023 18:12 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: Accessing Advanced Parameters Technical Details Control Used Based on Datatype and Operator 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: 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. If you would like to add a new filter, select +Add Filter.A new filter row is added to the grid, as shown below. Select the View Name, if necessary.This field will automatically populate with the default View. Select the Column Name.Available columns are based on the selected View. 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. You can easily tell which row you are in by the blue indicator to the left of the grid. Similarly, if upon saving a syntax error is found, the row in error will be indicated within the grid with a red row number. You can view and edit additional details for each row by clicking the expand arrow to the right of the grid. 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 TextboxThe 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