Add additional lifecycle roles to the My Active Lifecycle Steps Tile

Hi ​@RobinB what would be the exact use case here? This tile already has the maximum number of columns, so you would have to hide some of the existing ones. If your team is familiar with the DB, they could subquery the additional role using something like this: 

(
    SELECT TOP 1 u.full_name
    FROM ip.workflow wf
    JOIN ip.wf_team wft ON wf.workflow_id = wft.workflow_id
    JOIN ip.ip_user u ON wft.user_name = u.user_name
    JOIN ip.structure s ON wf.planning_code = s.structure_code
    WHERE wft.lifecycle_role_code = 'xxxx'
      AND s.structure_code = main.assoc_planning_code
      AND wft.place = (
          SELECT MIN(wfti.place)
          FROM ip.wf_team wfti
          WHERE wfti.lifecycle_role_code = wft.lifecycle_role_code
            AND wfti.workflow_id = wft.workflow_id
      )
) AS xxxx

Note that this tile doesn’t work well with the additional subqueries in terms of the performance, so you may need to consider a different approach like this: 

-- ROLE 1

ISNULL((
    SELECT TOP 1 u.full_name
    FROM ip.wf_team t
    JOIN ip.workflow wf ON t.workflow_id = wf.workflow_id
    JOIN ip.ip_user u ON t.user_name = u.user_name
    WHERE wf.planning_code = main.assoc_planning_code
      AND t.lifecycle_role_code = 'xxxx'
    ORDER BY t.place ASC
), 'Unassigned') AS xxxx,

-- ROLE 2

ISNULL((
    SELECT TOP 1 u.full_name
    FROM ip.wf_team t
    JOIN ip.workflow wf ON t.workflow_id = wf.workflow_id
    JOIN ip.ip_user u ON t.user_name = u.user_name
    WHERE wf.planning_code = main.assoc_planning_code
      AND t.lifecycle_role_code = 'xxxx'
    ORDER BY t.place ASC
), 'Unassigned') AS xxxx
 

if you or your team are not familiar with the DB schema, it would be best to reach out to GRS and ask them to make the necessary updates.

Best, 
Michal