Add a New Crossover DomainAdd a New Crossover DomainA crossover domain returns a value from a field in one application to a field in another application.
Prerequisite: Ensure that the SQL statements that you use in this procedure are valid. The application does not validate SQL statements.
In the Domains table window, click Add New Domain and select Add New CROSSOVER Domain.
In the Domain field, specify a name for the domain.
Optional: In the Description field, type a short description for the domain.
Define details for the CROSSOVER domain:
In the CROSSOVER Domain table window, click New Row.
In the Object field, 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.
In the Validation Where Clause field, type the part of the clause that when queried against the object in the Object field will return at least one record if the value to be validated by this domain is considered valid. 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 type: ASSETNUM = :Z (the colon represents the bind variable).
In the List Where Clause field, type the part of the clause that specifies the value that you want to select based on the validation WHERE clause. 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.)
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: 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, click New Row.
In the Source Field list, select an attribute of the object that you specified in the Object field. This attribute represents the field that you want to return values from.
In the Destination Field text box, specify the field that you want values to be returned to.
Select the Accept NULL Value check box if you want to copy the value from the source field when the value of the target attribute is empty. This function overwrites the previous value.
Select the No Overwrite check box if you want 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. 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. The destination object must meet the condition before the crossover occurs.
Type a numeric value in the Sequence field to specify the order that the crossover occurs when multiple crossovers are defined. Crossovers with lower values occur before crossovers with higher values.
Click OK to add the crossover domain to the database.
Post-requisite: You must associate the domain to the attribute that you want the domain to be used with. Depending on how you want to use the crossover domain, there may be other post-requisite tasks, such as:
Configure the database.
Use the Application Designer application to modify the user interface as needed. New crossover domains may require new fields in the destination application.