You add a table domain when you want to draw a single, dynamic value directly from a
column in the database. This process creates a dynamic value list because the values it draws from
the database might change. For example, you want to associate a lookup list with an extra field that
the product provides.
About this task
Table domains differ from crossover domains in that crossover domains are used for copying
multiple dynamic values from a table.
Procedure
- In the Domains application, in the Domains table window, add a domain and select
Add New TABLE Domain.
- Specify a unique identifier and a description for the domain.
- Insert a row and complete the following fields.
You can learn more about the data structures and relationships in the product in the Object
structures application.
Field |
Description |
Object |
Specify the name of the object that contains the attribute from which you want to create a
domain. For example, to obtain values from the ASSET object, specify ASSET.
|
List Where Clause |
The filter that specifies additional criteria that limits the values returned to the lookup
list. For example, to select asset records that begin with the numbers 114, type:
assetnum like '114%'
Note: Your entry is not validated now for syntax or any other errors. Be sure that you
specified a valid WHERE clause. If you make errors, errors do not become
apparent until you configure the database.
|
Validation Where Clause |
The 1:1 relationship to a value in the child object, which is specified in the
Object field. In the WHERE clause, specify the child attribute first. Then
specify the source attribute, prefixed with a colon. Be aware of the level at which data is
used. For example, an asset is added at the site level, so it is possible that identical asset
identifiers are used in more than one site. The clause to select the assetnum should also specify a
site identifier.
For example, if you want a field named Z (attribute Z) to contain values
from the assetnum field in the Assets application for the Concord site, type: assetnum =
:z and siteid =:Concord.
|
- 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.
- In the Error Message Group field, specify the group value of
the error message.
- In the Error Message Key field, specify the key value of the
error message.
- Optional: Apply a domain value to a specific organization and site by
specifying values in the Organization and Site
fields.
Domains are applied at the system level by default. You can allow users in all organizations
and sites to access the values by leaving the Organization and
Site fields empty.
- Optional: Add more rows.
- Save your changes.
What to do next
After you add a domain, you might still have several tasks to perform, depending on the domain
and how you want to display it.
In the Classifications application, you can associate a domain with an attribute in the
Attributes table window. Specify the table attribute and lookup name. No
further configuration is needed.
If you use a domain in any other context, adding a domain requires any
of the following tasks:
- Associate the new domain with an attribute in the Database
Configuration application.
- Configure the database in the Database Configuration application.
- Modify the presentations as needed with the Application Designer application. For example,
if you add an ALN domain for a field, you must add a Select Value control.
New crossover domains might require new fields in the destination application.