You add a crossover domain when you want to return a value from a field in one
application to a field in another application.
About this task
Ensure that the SQL statements that you use in this procedure are valid. The
application does not validate SQL statements.
Procedure
- Open the Domains application.
- In the Domains table window, add a domain and select Add New CROSSOVER
Domain.
- Specify a name and description for the domain.
- In the Crossover Domain table window, insert a row and define details for the crossover
domain:
Field |
Description |
Object |
Select the name of the object that contains the attribute that you want to create a domain
from. For example, to obtain values from the ASSET object, select ASSET. |
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.
|
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%'
|
- 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.
- Optional: To apply a domain to a specific organization or site, specify
values in the Organization and Site fields. To allow
access to users in all organizations and sites, clear all values from these fields.
- Select fields for the crossover domain:
- In the Crossover Fields table window, add a row.
- In the Source Field list, select an attribute of the object
that you specified in the Object field.
This attribute represents the field from which you want to return values.
- In the Destination Field text box, specify the field to which
you want values to be returned.
- Optional: Select the Accept NULL Value checkbox to
copy the value from the source field when the value of the target attribute is
empty.
This function overwrites the previous value.
- Optional: Select the No Overwrite checkbox to copy
the value of the source attribute when it is null.
- Optional: Specify conditions for the source object or the destination object,
or both:
- In the Condition on Source field, select a condition or use the
Conditional Expression Manager to build the condition for the source object of the
crossover.
If a condition is specified, the source object must meet the condition before
the crossover occurs.
- In the Condition on Destination field, select a condition or
use the Conditional Expression Manager to build the condition for the destination object of the
crossover.
If a condition is specified, the destination object must meet the condition
before the crossover occurs.
- In the Sequence field, type a numeric value to specify the
order that the crossover occurs when multiple crossovers are defined.
Crossovers with
lower values occur before crossovers with higher values.
- 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, and no further configuration is
needed.
If you use a domain in any other context, adding a domain
requires additional tasks.
- In the Database Configuration application, associate the new domain with an
attribute and configure the database. After you onboard a tenant, the tenant can change the domains
that you provide or create their own domains. These domains are tenant-specific and are not
available to other tenants.
- In the Database Configuration application, associate the new domain with an
attribute and configure the database.
- In the Application Designer application, modify the user interface as needed. 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.