Behavior of Invalid records in RDM Approval workflow

Question

Dear Community,I have query regarding RDM approval workflow. In our project we have stages Initiator → Review → Publish .It has been noticed that when a record is invalid, its status is displayed as 'INVALID,' yet it progresses in the workflow for review. The reviewer has the option to accept this invalid record, and it moves to the Publish section. However, when the approver attempts to publish the record, an error occurs, stating that the record is invalid and cannot be published.The client is now requesting clarification on why an INVALID record is allowed to progress through these stages in the first place. They propose that it should not be permitted to move to the review state initially.Anyone faced this scenario before? Can we do something in approval workflow configuration that record should not move to review state if it is Invalid.Any help regarding this will be really helpful.Best regards,Ojaswini

OGordon100 · Accepted Answer

HIOjaswini.Unfortunately there is no way to prevent invalid records from entering the workflow/publish stages.The example you pictured would simply cause an “approve” workflow task to always appear. It’s good practice and I would always suggest its inclusion at the end of a workflow, but you would still have the issue of it being bypassable when invalid.However, you could use the second Condition (not with the arrow but in the Statements table). This condition prevents exiting a stage of the workflowunless a certain condition is met. (It is functionally different tothe arrowed condition, which places a condition on enteringthe stage of a workflow). If the table validations are simple, you could replicate them in this box and achieve your desired functionality.Hope this helps :)Oliver

OGordon100 · Answer

HiOjaswini.You’re absolutely right that an invalid record cannot be published, even if it has been approved in a workflow.I also agree that in your case, it makes sense to not allow an invalid record to enter a workflow.However, workflows are not just for approval, but also for data entry, too. This means that it’s entirely possible (and oftendesirable) for a workflow to change the status of a record from invalid to valid.As an example: Imagine we have a table with columns A andB. Both must be present for a record to be valid. We have a workflow with a step for another business unit to fill in column B.When we create arecord with only column A filled, it will be invalid. We then send to publish, and enter the workflow step to get the attention of the other business unit. Within the workflow, they fillcolumn B. The record is now valid and able to be published.If we were to change the product such that invalid records couldnotenter a workflow, this common design pattern would not be possible.However, I appreciate your point, and I have passed on your suggestion to the team :)Best,Oliver

Behavior of Invalid records in RDM Approval workflow

4 replies

Reply

Most Liked this week

Cookie policy

Cookie settings

Reply

Related topics

RDM Web App deleting the dataicon

Introduction to RDM - Part 2️⃣

RDM users in Approval workflow without email notificationsicon

Sending RDM Workflow Updates to Microsoft Teams & Slack

Introduction to RDM - Part 1️⃣

Most Liked this week

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings