This post is about finding instances using wildcard search by querying SOAINFRA schema.
Edited on 6th Feb: Wild Card search in EM on instance title works in 11g and 12c . Tested with 18.104.22.168.8 and 12.2.1.
Specific composite instance can be located in EM using composite instance’s title and composite sensor’s value. Please refer Locate Instances using title and sensors in EM post for more information.
It is also possible to query SOAINFRA schema tables to get specific composite instance. One big advantage with back end querying is , wildcards can be used in the query.
In 12c, “Title” values set using “setFlowInstanceTitle” is stored in “sca_flow_instance” table.
Connect to backend Database. Please refer Create Connection to JavaDB post, for connecting and querying in JavaDB.
Executing select * from sca_flow_instance where title like ‘or%7’ will display instance id of all composites whose title match the wildcard criteria ‘or%7’