Start a new topic
Discussions xDM xDM - Platform Configuration & Administration
Answered

Inhibit alteration of the same record in a parallel Workflow

I have a case where a customer wants to in-phase product records using the new data-driven workflows.


The idea is that a few attributes will be populated by an external load and that data stewards then manage the rest of the attributes in the workflow.


The data stewards consist of a group of end users which theoretically means that all of these can start a workflow and alter the same record. I need to avoid this by setting up some type of startup context stating that if a specific record is already being altered in a workflow instance, then another user should not be able to start an additional workflow instance on the same root record.


I have not been able to find a good way to accomplish this.


Is there a way to accomplish the above by for example utilizing the "wf_" metadata tables and a custom database script similar to what is discussed in the following thread: https://support.semarchy.com/en/support/discussions/topics/43000532026

Best Answer

Hi Sebastian, for the new workflows there are two tables that you can use instead of dl_batch. 


Here is a sample query to test. The query is written for Postgres but it should have all of the tables required.    



select sp.id from 
sa_person sp 
inner join wf_step_instance wsi 
on sp.b_loadid =wsi.curr_dataset_load_id 
inner join wf_workflow_instance wwi 
on wwi.initial_data_set_loadid = wsi.prev_dataset_load_id 
where wwi.status ='IN_PROGRESS'


3 CommentsSorted by Oldest First

Hi Sebastian!


Thanks for raising this question in the forums and for having a look at the existing answer!

Did you try the proposed solution provided in the other forum? I think it should work in your case as well as whenever the first user has to run an enricher or change the step of the workflow, data will be saved into SA in any case. If it doesn't work, I'll find the other tables to look at.


Thanks for confirming!

Stéphanie.

Hi Stéphanie, thank you for the reply.


You are correct in that changing steps adds a new row in the SA table. However, compared to the solution in the other thread, changing steps in data-driven workflow does not add a new row in the dl_batch table. That means that I have no way of checking if the new row in the SA table has the status "RUNNING" or not.


Achive my goal by using any of the new "WF_" tables instead of dl_batch?


BR,

Sebastian



Answer

Hi Sebastian, for the new workflows there are two tables that you can use instead of dl_batch. 


Here is a sample query to test. The query is written for Postgres but it should have all of the tables required.    



select sp.id from 
sa_person sp 
inner join wf_step_instance wsi 
on sp.b_loadid =wsi.curr_dataset_load_id 
inner join wf_workflow_instance wwi 
on wwi.initial_data_set_loadid = wsi.prev_dataset_load_id 
where wwi.status ='IN_PROGRESS'


Login to post a comment
More topics in xDM - Platform Configuration & Administration
See all 53 topics
Help Desk Software by Freshdesk