How to link workflows to the data processed in this workflow?
W
Wijden DAHMEN
started a topic
6 months ago
Hello ,
I am launching a workflow via an API and I need to retrieve the comment from the workflow related to the data that has been validated or rejected at this level.
This workflow consists of a single step.
I am trying to retrieve this comment based on the golden ID, batch ID, or load ID. Is there a way to link the workflows to the golden ID, batch ID, or load ID of the data processed in the workflow?
I have tried using the columns gd_snapshot_dataset_load_id, prev_dataset_load_id, or curr_dataset_load_id that exist in the wf_workflow_instance table, but I have not been able to find these load IDs in the GD table.
Thank you,
Best Answer
S
Subham Dixit
said
6 months ago
Hello Wijden,
It seems to be possible, where you need to create a function/procedure and call it in the stepper, for that you need a specific attribute which will store the value of comment.
Also you need to join couple of tables to to be able to populate the data-
1. DL_BATCH ( To get the B_LOADID and B_BATCHID values)
2. WF_WORKFLOW_INSTANCE ( To be able to retrieve the Start_comment of the workflow with the help of initial_dataset_loadid )
3. WF_STEP_INSTANCE ( To be able to calculate the value of loadid from curr_dataset_loadid according to your number of workflow steps )
4.SA_table (to be able to insert the value of comments in the related attribute which will be populated to the GD table automatically)
You need to try the above idea, I haven't tried it but seems to be possible, also you need to calculate the number of steps in your workflow in order to get the value of the actual b_loadid column using the table wf_step_instance where you can see the loadid value as per the tasks (strt, user task, router, submit and end) of the workflow, and the value of the last step of the task like 'End' task column 'curr_dataset_loadid' +1 will be the value of b_loadid, so it seems to be complex to implement but possible.
Unfortunately, it's not possible right now to retrieve the comments of the workflow user tasks using the REST API, but we have already an enhancement request for this feature MDM-15491, In the Data-driven workflows, you can access the comments from the tables- wf_step_instance and wf_workflow_instance but not in the REST API response-
Thank you
W
Wijden DAHMEN
said
6 months ago
Hello Subham,
How can I link the start_comment column to my gd_table, please?
Thank you,
S
Subham Dixit
said
6 months ago
Answer
Hello Wijden,
It seems to be possible, where you need to create a function/procedure and call it in the stepper, for that you need a specific attribute which will store the value of comment.
Also you need to join couple of tables to to be able to populate the data-
1. DL_BATCH ( To get the B_LOADID and B_BATCHID values)
2. WF_WORKFLOW_INSTANCE ( To be able to retrieve the Start_comment of the workflow with the help of initial_dataset_loadid )
3. WF_STEP_INSTANCE ( To be able to calculate the value of loadid from curr_dataset_loadid according to your number of workflow steps )
4.SA_table (to be able to insert the value of comments in the related attribute which will be populated to the GD table automatically)
You need to try the above idea, I haven't tried it but seems to be possible, also you need to calculate the number of steps in your workflow in order to get the value of the actual b_loadid column using the table wf_step_instance where you can see the loadid value as per the tasks (strt, user task, router, submit and end) of the workflow, and the value of the last step of the task like 'End' task column 'curr_dataset_loadid' +1 will be the value of b_loadid, so it seems to be complex to implement but possible.
Wijden DAHMEN
Hello ,
I am launching a workflow via an API and I need to retrieve the comment from the workflow related to the data that has been validated or rejected at this level.
This workflow consists of a single step.
I am trying to retrieve this comment based on the golden ID, batch ID, or load ID. Is there a way to link the workflows to the golden ID, batch ID, or load ID of the data processed in the workflow?
I have tried using the columns gd_snapshot_dataset_load_id, prev_dataset_load_id, or curr_dataset_load_id that exist in the wf_workflow_instance table, but I have not been able to find these load IDs in the GD table.
Thank you,
Hello Wijden,
It seems to be possible, where you need to create a function/procedure and call it in the stepper, for that you need a specific attribute which will store the value of comment.
Also you need to join couple of tables to to be able to populate the data-
1. DL_BATCH ( To get the B_LOADID and B_BATCHID values)
2. WF_WORKFLOW_INSTANCE ( To be able to retrieve the Start_comment of the workflow with the help of initial_dataset_loadid )
3. WF_STEP_INSTANCE ( To be able to calculate the value of loadid from curr_dataset_loadid according to your number of workflow steps )
4.SA_table (to be able to insert the value of comments in the related attribute which will be populated to the GD table automatically)
You need to try the above idea, I haven't tried it but seems to be possible, also you need to calculate the number of steps in your workflow in order to get the value of the actual b_loadid column using the table wf_step_instance where you can see the loadid value as per the tasks (strt, user task, router, submit and end) of the workflow, and the value of the last step of the task like 'End' task column 'curr_dataset_loadid' +1 will be the value of b_loadid, so it seems to be complex to implement but possible.
Thanks and have a nice day.
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstSubham Dixit
Hello Wijden,
Unfortunately, it's not possible right now to retrieve the comments of the workflow user tasks using the REST API, but we have already an enhancement request for this feature MDM-15491, In the Data-driven workflows, you can access the comments from the tables- wf_step_instance and wf_workflow_instance but not in the REST API response-
Thank you
Wijden DAHMEN
Hello Subham,
How can I link the start_comment column to my gd_table, please?
Thank you,
Subham Dixit
Hello Wijden,
It seems to be possible, where you need to create a function/procedure and call it in the stepper, for that you need a specific attribute which will store the value of comment.
Also you need to join couple of tables to to be able to populate the data-
1. DL_BATCH ( To get the B_LOADID and B_BATCHID values)
2. WF_WORKFLOW_INSTANCE ( To be able to retrieve the Start_comment of the workflow with the help of initial_dataset_loadid )
3. WF_STEP_INSTANCE ( To be able to calculate the value of loadid from curr_dataset_loadid according to your number of workflow steps )
4.SA_table (to be able to insert the value of comments in the related attribute which will be populated to the GD table automatically)
You need to try the above idea, I haven't tried it but seems to be possible, also you need to calculate the number of steps in your workflow in order to get the value of the actual b_loadid column using the table wf_step_instance where you can see the loadid value as per the tasks (strt, user task, router, submit and end) of the workflow, and the value of the last step of the task like 'End' task column 'curr_dataset_loadid' +1 will be the value of b_loadid, so it seems to be complex to implement but possible.
Thanks and have a nice day.
-
Can we reset Matches and run again on match rule change or add a new match rule?
-
"Unmerge" records
-
Turn off match rules to speed up an integration job
-
Can anyone tell me how to load a Fuzzy-Matched entity ... but skip the matching happening auto-magically?
-
Importing CSV in Fuzzy Matched Entity Does Not Trigger Consolidation
-
How can I trigger a "match on child records"?
-
How can I Configure Most Frequent Values in Survivorship Rules?
-
Deterministic or probabilistic matching
-
Machine Learning and AI for matching
-
Prevent loads from replacing values overridden by users
See all 45 topics