Skip to main content
1
100Rub
February 20, 2025

Dependent Parameters on Cube Root Workflow Profile selection

  • February 20, 2025
  • 2 replies
  • 0 views

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

    W
    WernerN
    July 6, 2025

    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

    W
    WernerN
    July 7, 2025

    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

     

    Terms & ConditionsAccessibility statement