This shows you the differences between two versions of the page.

Link to this comparison view

action type - relationship change [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Did a relationship change? ======
 +This evaluation will pass if all [[Relationship Record|relationship records]] from the [[Query Builder|query]] have changed, and will fail if any of these relationship records have not changed. A "​change"​ occurs when at least one [[Field|field]] associated with the relationship has had its value change during this operation. The "last modified date" field is excluded from this evaluation.
 +===== Explanation =====
 +Evaluations have two [[Automation Trigger|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.
 +{{ ::​action_evaluation_drop.png?​direct |}}
 +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|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.
 +===== Settings =====
 +==== Query relationship records to evaluate ====
 +Use the query builder to define which relationship records to evaluate for a change.
 +{{ ::​action_relationchanged_query.png?​direct |}}
 +==== Describe this action ====
 +Useful as a comment, this description will overwrite the automatically generated description in the [[Action Manager|Action Manager]].
 +==== Queue this action and children ====
 +When an action is [[Action Queue|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 14:19 (external edit)
Copyright WorkXpress, 2019