Forum Discussion

100Rub's avatar
100Rub
New Contributor III
1 year 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 second drop-down list of the combo box. Likewise, there is a third combo box for the current workflow year and time. What can be the Dashboard Data Set for this?

Thanks 

2 Replies

  • WernerN's avatar
    WernerN
    Contributor II
    8 months ago

    I would like the same function.  I need to select a cube root workflow profile in a source application so that i can, in a subsequent selection, select a workflow under that cube root.  
    Cant believe there is not an API call for that similar to when we go to workflows and select a cube root profile at the top.

    Is the only option an adapter over WorkflowProfileHierarchy table WHERE ProfileType = 1

  • WernerN's avatar
    WernerN
    Contributor II
    8 months 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