Database View

[John H1]

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

[Brad Bowman]

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]

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