0%
August 9, 2024

Json Query in PostgreSQL for domain_event_entry in Axon Framework

axon-framework

sql

select 
  sequence_number,
  type as aggregate,
  REPLACE(payload_type, 'com.machingclee.payment.command.CommandAndEvents$SubscriptionPlanOrder$', '') as event, 
  encode(payload, 'escape') as payload, 
  time_stamp,
  aggregate_identifier
from 
	domain_event_entry
where   
	encode(payload, 'escape')::jsonb->>'orderId' = '019136f9-794b-9a58-ba74-363facf9a814'
order by 
	time_stamp asc

Result: