Find composite instances:
-
select ci.created_time, ci.source_name, ci.title, ci.conversation_id, ci.*
-
from dev_soainfra.composite_instance ci
-
where 1=1
-
and ci.state=17
-
and ci.source_name not in ('aiaerrortaskadministrationprocess_client_ep')
-
order by ci.created_time desc
ci.state = 17 Terminated
RJM Article Type
Quick Reference