Collections: Staging Analysis

Description: This helps find the different stages of a smart statement being generated. From executing sequence steps, to sending the smart statement, this query is meant to show you the steps based on searching for a client.

select c.name, ad.display_name, adi.*
from action_def_group_instance_client adgic
         inner join action_def_instance adi on adi.action_def_group_instance_id = adgic.action_def_group_instance_id
         inner join action_def ad on ad.id = adi.action_def_id
         inner join client c on c.id = adgic.client_id
where adi.action_def_id in (40, 41, 42, 43, 44) and c.name like '%SN Intermediate%'