Forum Discussion

100Rub's avatar
100Rub
New Contributor III
6 months ago

Dependent Parameters on Cube Root Workflow Profile selection

Hi Folks, I need to retrieve all cube root workflow profiles in the first parameter. Upon selecting a particular cube root workflow profile, all its related workflow profiles should appear in the se...
Dashboards
WernerN's avatar
WernerN
Contributor II
25 days ago

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
WHERE HierarchyLevel = 1 AND ProfileType = 0