Database View
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2025 09:04 AM
what is the best script to join SC)Task and wf_activity in a Database view
- Labels:
-
Service Desk
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2025 09:39 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2025 10:10 AM
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