SOA 12c: Finding flow and instances names and titles

To identify via SQL the latest flow and instance titles, run the following query:

SELECT f.flow_id
      ,f.title
      ,c.composite_id
      ,c.title
FROM   sca_flow_instance         f
      ,sca_flow_to_cpst          c
WHERE  c.flow_id                 = f.flow_id
ORDER BY
       f.flow_id      DESC
      ,c.composite_id DESC

Also including the composite type:

SELECT f.flow_id
      ,f.title
      ,r.composite
      ,c.composite_id
      ,c.title
FROM   sca_flow_instance         f
      ,sca_flow_to_cpst          c
      ,sca_entity                r
WHERE  c.flow_id                 = f.flow_id
  AND  c.composite_sca_entity_id = r.id
ORDER BY
       f.flow_id      DESC
       c.composite_id DESC

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s