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

Link to this comparison view

action type - record change [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Did records change? ======
 +This evaluation will pass if all of the [[Record|records]] from the [[Query Builder|query]] have changed, and will fail if all of these records have not changed. A "​change"​ occurs when at least one [[Field|field]] associated with the record 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 |}}
 +Record changed evaluations are used to execute a set of actions if certain records have changed, and another set of actions if those records have not changed.
 +Example : Suppose an application has the requirement of a high level of security, logging whom changes which records and when.  To accomplish this, the builder can create a record changed evaluation on the [[Automation Trigger|automation trigger]] at the [[Table|table]] level that is triggered when records in that table are updated, and check for the 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 records to evaluate ====
 +Use the query builder to define which records to evaluate for a change.
 +{{ ::​action_recordchanged_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 - record change.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020