Does a relationship exist?

Use the query builder's below to find two sets of records and then choose a relatonship table to look in for the existence of relationship records between all combinations of the records from the first query and those from the second query. This evaluation will pass if any relationship records are found and it will fail if no relationship records are found.

Explanation

Evaluations have two automation triggers associated with them : Then and Else. Actions under the “Then” automation trigger execute when the evaluation passes, and actions under the “Else” automation execute when the evaluations fails.

Relationship record exists evaluations are used to execute a set of actions if relationship records exist between two sets of records, and another set of actions if they don't.

Example : Suppose a field grid form on a page about a Contact should be editable if the current Contact has a relationship record between it and an Account, in the relationship table Employer to Employee. To accomplish this, the builder would edit the actions for the field grid form, and on the Security automation trigger add a relationship record exists action. In the first query builder, leave the context inherited to query the current Contact, and in the second query builder jump from the current Contact to an Account over the Employer to Employee relationship table. Then choose the Employer to Employee relationship table for which relationship table to look in. Under the “Then” automation trigger place the actions that should fire if the relationship record in question exists.

Example : Suppose an application allows Contacts to be imported, and once they are imported if any Contacts live in the state of Pennsylvania, a set of actions should execute. To accomplish this, the builder would first build the record import actions appropriately. After the record import actions are complete, they would then add a record exists evaluation, and query the Contact for all Contact records, filtering the state part of their Address field to be “PA”. Under the “Then” section they could add the actions for when there are Contacts in “PA” and under the “Else” section actions for when there are no Contacts in “PA”.

Settings

Query records to evaluate for a relationship record between

Use the query builders to find two sets of records.

Choose the relationship table to look for relationship record in

Select the relationship table you wish to look in for a relationship record connecting records from one query to records from the other query, above.

Describe this action

Useful as a comment, this description will overwrite the automatically generated description in the Action Manager.

Queue this action and children

When an action is queued, the subsequent actions continue to process without it. Meanwhile, the queued action and its children process separately. Queue actions that you don't want a user to wait for.

action type - relationship exist.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024