Forum Discussion
WernerN
8 hours agoContributor II
Wrote to fast. ProfileType = 1 is wrong. should have been HierarchyLevel. See below.
So here is the SQL i am using to get a list of Cube Root Workflow Profiles:
SELECT ProfileName Name, ProfileKey Value
FROM WorkflowProfileHierarchy
FROM WorkflowProfileHierarchy
WHERE HierarchyLevel = 1 AND ProfileType = 0
Related Content
- 11 months ago
- 2 years ago
- 2 years ago
- 4 years ago
- 3 years ago