You are viewing limited content. For full access, please sign in.

Question

Question

Know all the business processes and tasks that use a certain team

asked on April 26, 2023 Show version history

Hi.

I need to change some team members, and I know it will affect all business processes and tasks that will be assigned to it. Is there any way to check all business processes that will be affected if I change the team members of a team without checking business processes and tasks one by one? 

That is, I need to know all the business processes and tasks that use a certain team.

It can be SQL.

0 0

Answer

SELECTED ANSWER
replied on April 26, 2023

Here's a start...

Query to see the list of teams - use this to determine the id number of the team: 

SELECT *
FROM [LFForms].[dbo].[teams]

 

Once you know the team ID number, you can do a query like this to identify the User Tasks that reference that team ID number (in this example, I'm searching for ID # 12 - you can edit that on line 9): 

SELECT 
  bp.[name] AS process_name,
  step.[step_type],
  step.[name] AS step_name,
  [definition_json]
FROM [LFForms].[dbo].[cf_bp_steps] AS step
LEFT JOIN [LFForms].[dbo].[cf_bp_processes] AS bpp ON bpp.[process_id] = step.[process_id]
LEFT JOIN [LFForms].[dbo].[cf_business_processes] AS bp ON bp.[bp_id] = bpp.[bp_id]
WHERE [definition_json] LIKE '%"teamId":12%'
  AND step.[is_deleted] = 0
  AND bp.[is_deleted] = 0

 

This is tested on Forms Version 11.0.2212.30907 and SQL Server Management Studio versions 18.12.1

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.