About Validation

You can validate job property items by using the Job Properties > Qualify tab. For example, you can validate against database tables maintained in the SQL Server of any external software application.

Configuring validation

To configure validation for existing job properties

  1. Start the Server Administrator.
  2. On the console, expand the Server Administrator tree and select Configuration > Job Properties, then click System, User or your Properties group.
  3. Double-click the property of interest. The Job Property page opens.
  4. Select the Qualify tab, from the Validation drop-down list, choose one of the following options.

    • None – Provides no validation.

    • Length – Validates minimum to maximum characters.

    • List – Validates against the list of Items on the Prompt UI tab of the Job Property page.

    • Database (ADO) – Validates against database-specific information. See step 7 below for an example of using Database (ADO) Validation.

    • Meditech Magic – Validates against Meditech-specific information.

    • Web Service – Validates against Web Validation Service URL.

    • Regular Expression – Validates against a specified Regular Expression.

Note: The Meditech Magic validation is part of a rarely-used special environment. Continue to Step 5 unless working in this environment.

For example, select Database from the Validation list.

  1. Click Configure. The Validation Properties page opens.
  2. For the Database example, on the General tab, select either the Mandatory: User must specify a valid value or the Optional: User may continue if not valid radio button.
  3. Select the User must confirm successful validations check box, if needed.
  4. Click the ADO tab.
  5. In the DSN text box, enter the following string.
    • Driver={Sql Server}; Server=[your SQL server name]; Database = [your database name]; User ID=””; Password=””;
  1. In the Query text box, enter the following string.
    • select [name] from [name field] where [name] = %name%
    • For example, for the Client field, you will enter:
    • Select ClientField from Cli­entTable where ClientField = %Client%
  1. Click Test to test the validation.
  2. Click OK to create the validation.
  1. Create a new job property. For instructions, see Creating job property.
  2. On the Job Property page, click the Qualify tab.
  3. In the Validation section, select a Validation type from the drop-down list.
  4. Select the message property you want to validate.
  5. Click OK to save your changes to the job property.

 

See also

About Job Properties

Creating Job Property

About Regular Expressions

About Lookup Job Property