Query: ibm_is_security_group_outbound_rules

select
  concat(
    text(r -> 'remote' ->> 'cidr_block'),
    (r -> 'remote' ->> 'id'),
    (r -> 'remote' ->> 'address')
  ) as "Source",
  r ->> 'id' as "Security Group Rule ID",
  case
    when r ->> 'protocol' = 'all' then 'All Traffic'
    else r ->> 'protocol'
  end as "Protocol",
  case
    when r ->> 'port_min' is null
    and r ->> 'port_max' is null then null
    when r ->> 'port_min' is not null
    and r ->> 'port_max' is not null
    and (r ->> 'port_min') = (r ->> 'port_max') then (r ->> 'port_min') :: text
    else concat((r ->> 'port_min'), '-', (r ->> 'port_max'))
  end as "Ports"
from
  ibm_is_security_group,
  jsonb_array_elements(rules) as r
where
  crn = $1
  and r ->> 'direction' = 'outbound';