Database View

John H1
Tera Guru

what is the best script to join SC)Task and wf_activity in a Database view

2 REPLIES 2

Brad Bowman
Kilo Patron
Kilo Patron

Can you say some more about the columns you need from each? wf_activity only holds the definitions of activities as you would see it in the workflow editor, so there's not really a connection to actual Catalog Task records that are generated based on the definition.

Robert H
Mega Sage

Hello @John H1 ,

 

There is no way to join these tables, as they are not related, at least not directly. Could it be you mean Executing Activities [wf_executing] or Contexts [wf_context] instead?

 

But can you please take one step back and let us know what business requirement you are trying to solve?

 

Regards,

Robert