Did a relationship change?

This evaluation will pass if all relationship records from the query have changed, and will fail if any of these relationship records have not changed. A “change” occurs when at least one field associated with the relationship has had its value change during this operation. The “last modified date” field is excluded from this evaluation.


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 changed evaluations are used to execute a set of actions if certain relationship records have changed, and another set of actions if those relationship records have not changed.

Example : Suppose an application has the requirement of a high level of security, logging whom changes which relationship records and when. To accomplish this, the builder can create a relationship record changed evaluation on the automation trigger at the relationship table level that is triggered when records in that table are updated, and check for the relationship records' change. If it has changed, then run the appropriate actions to create an Audit Change record recording that this record was changed, what time and by whom.


Query relationship records to evaluate

Use the query builder to define which relationship records to evaluate for a change.

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 change.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024