Page Comparison

select key, Responsible_QA from (select key, with custom_fields as (
  select 
  	key, 
  	jsonb_array_elements(custom_fields) ->> 'name' AS test_name,
    jsonb_array_elements(custom_fields) ->> 'value' AS Responsible_QAvalue
  from Ticket
) AS testtable
select key, value from custom_fields
where test_name = 'Responsible QA'