Records Commit Setting
Do You Know How to Use the Records Commit Setting?
The Records Commit Setting in the Assignment Group (AG) is a powerful tool that allows Admins to control when changes made to records by an AG are committed in the Database. This setting can help you ensure that other processes that rely on those changes, such as follow-me rules in the same AG in the same job, external triggers, and flows, can all see the updated values from the database rather than the values before processing. The Records Commit Setting also directly impacts how many DML statements are used by an AG per job. The total number of DML statements allowed per job for Q-assign is 150.
In AG edit mode, you have three options for the Records Commit Setting:
-
Per Processed Record: Each modified record will be committed right after it's processed and before processing of the next record starts using one commit (DML statement) per record. If AG processes 10 records, then it will use 10/150 DML statements for changing ownership.
-
Per Assignment Group: All records modified by the AG will be committed after processing them all using only 1 commit (DML Statement) for all records modified by the AG. If AG processed 10 or any other number of records regardless, it will use a 1/150 DML statement.
-
Automatic: This is the default setting and based on any Action rules or Follow Me rules configured in AG, Q-assign will decide whether to use ‘Per Processed Record’ or ‘Per Assignment Group’. If there is any Action rule or Follow me rule defined in AG, then the 'Per Processed Record' setting will be used, otherwise ‘Per Assignment Group' setting will be preferred.
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8yMzgxLzQ0MDcvY2tmaW5kZXIvaW1hZ2VzL3F1L2ltYWdlKDU4KS5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3ODY2ODM2MDh9fX1dfQ__&Signature=LfouA-Ss8HCWaJcGL4l2LLfU6ej3jZ3lcNog8Qlr0ziyOvymnr2nPRZn6B15OcqxBt7yo98p~OsLuviEXl03VyoPtifBwOkA6lelWoRKVRozGUgaTChQys0TOdMn9UwEQtwgtkQuwdALIYGc1oR3jGlzsJ9Flw9dqLBw9LyvtTriefQEL5PHYvqJbDJRbnrjq4V562vRGN4cfBsUd5Djf16tZ79EPwPhZa0sVg28oPoBPiL2PgE4w~UMbb5sezfpSjkDPEr51-RjUFDfvIaSVQk~ajT20gKkRlltK6FghC74vF7SY8MvPfvqZG7z~99rUn0627j7R4YtZ8Amoa-dUA__&Key-Pair-Id=K2TK3EG287XSFC)
If you have any questions about the Records Commit Setting, please don’t hesitate to contact us at support@ortooapps.com. We’re here to help!