Add a New TABLE Domain

You use the TABLE Domain dialog box to add a new domain that draws its values directly from a column in the database. This is in effect a dynamic value list because the values it draws from the database may change. It is not a list of static values that you create.

To create a new TABLE domain:

  1. Open the Domains (SP) application.

  2. At the bottom of the Domains table window, click Add New Domain and select Add New TABLE Domain. The TABLE Domain dialog box opens.

  3. In the Domain field, enter a name for the domain.

  4. In the Domain Description field, enter a short description.

  5. Click New Row. The Row Details open.

  6. In the Object field, enter the name of the object or click Select Value . The object you want is the object containing the attribute from which you want to create a domain. For example, to obtain values from the ASSET object, you would enter:  ASSET

  7. In the List Where Clause field, enter the part of the clause that specifies the specific values you want to select based on the validation where clause. For example, to select asset records that begin with the numbers 114, you would enter:  assetnum like '114%'

Caution: The system does not validate your entry for syntax or any other errors. Be very sure you have entered a correct Where clause. If you make errors, they will not become apparent until you configure the database.

  1. In the Validation Where Clause field, enter the part of the clause that when queried against the object in the Object field should return at least one record if the value to be validated by this domain is considered valid. Usually, the clause involves a bind variable for the field that uses this domain for validation. The bind variable is represented by a colon (:) followed by the field name. For example, if you want a field named Z (attribute Z) to contain values from the assetnum field in the Assets (SP) application, you would enter:  assetnum = :z

  2. Optional: Specify a group value and a key value to select an error message to display when domain validation fails. (You define values for error messages in the Database Configuration application.)

  3. In the Error Message Group field, specify the group value of the error message.

  4. In the Error Message Key field, specify the key value of the error message.

  1. The system by default applies domains at the system level. If you want a domain value to apply to a specific organization or site, enter the relevant values in the Organization and Site fields.

Note: Either leave the Organization and/or Site fields empty for all values (users in all organizations and sites can access them) or specify organization and/or site for all values (only users in the specified organizations and/or sites can access them).

  1. Click New Row again to add more rows, or click Close Details .

  2. Click OK.

You have now added a new domain to the database. However, you must still attach the domain to the object/attribute you want the domain to be used with, as well as other tasks.

See Also

Domains (SP) application

Domain Post-requisites