Adding crossover domains

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

  1. Open the Domains application.
  2. In the Domains table window, add a domain and select Add New CROSSOVER Domain.
  3. Specify a name and description for the domain.
  4. 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%'

  5. 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.
  6. 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.
  7. Select fields for the crossover domain:
    1. In the Crossover Fields table window, add a row.
    2. 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.
    3. In the Destination Field text box, specify the field to which you want values to be returned.
    4. 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.
    5. Optional: Select the No Overwrite checkbox to copy the value of the source attribute when it is null.
  8. Optional: Specify conditions for the source object or the destination object, or both:
    1. 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.
    2. 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.
    3. 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.
  9. 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.