Page Comparison

select 'pipeline_stage_step' objectType, pipeline_stage_step_id id, data from fd.pipeline_stage_step pss
join fd.pipeline_stage ps
on ps.pipeline_stage_id = pss.pipeline_stage_id
join fd.pipeline_version pv
on ps.pipeline_version_id = pv.pipeline_version_id
join fd.pipeline_definition p
on pv.pipeline_definition_id = p.pipeline_definition_id
and p.active_pipeline_version_id = pv.pipeline_version_id
where active_copy = 'Y'
and data like '%import flexagon.fd.model.appmodules%'
union
select 'pipeline_stage_gate', pipeline_stage_gate_id, data from fd.pipeline_stage_gate psg
join fd.pipeline_stage ps
on ps.pipeline_stage_id = psg.pipeline_stage_id
join fd.pipeline_version pv
on ps.pipeline_version_id = pv.pipeline_version_id
join fd.pipeline_definition p
on pv.pipeline_definition_id = p.pipeline_definition_id
and p.active_pipeline_version_id = pv.pipeline_version_id
where active_copy = 'Y'
and data like '%import flexagon.fd.model.appmodules%'
union
select 'webhook', function_data_id, script_text
from fd.webhook_provider_function_data
where script_text like '%import flexagon.fd.model.appmodules%'
order by objecttype, id;