Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table deployed_workflows  (id integer, json_workflow  jsonb);

CREATE TABLE


insert into deployed_workflows
values 
(1,
'{"class": "Workflow",
  "outboundWorkflows": [{"class": "OutboundWorkflow",
                         "outboundConnector": {"name": "Push HTTP Single Person"},
                         "name": "Push HTTP Single PersonWF"},
                        {"class": "OutboundWorkflow",
                         "outboundConnector": {"name": "Push HTTP Single Person1"},
                         "name": "Push HTTP Single Person1WF"}],
  "threadcount": 1,
  "inboundConnector": {"name": "Pull JSON Persons"},
  "name": "Http Pull And Push"}
'),
(2,
'{"class": "Workflow",
  "outboundWorkflows": [{"class": "OutboundWorkflow",
                         "outboundConnector": {"name": "Push HTTP Double Person"},
                         "name": "Push HTTP Double PersonWF"},
                        {"class": "OutboundWorkflow",
                         "outboundConnector": {"name": "Push HTTP Double Person1"},
                         "name": "Push HTTP Double Person1WF"}],
  "threadcount": 1,
  "inboundConnector": {"name": "Pull JSON Persons"},
  "name": "Http Pull And Push"}
');

INSERT 0 2


select id
from deployed_workflows 
where json_workflow @@ '$.outboundWorkflows[*].outboundConnector.name like_regex "Push HTTP Single Person"';


id


1



SELECT 1