DPL extract single value and compare

almog50 — Mon, 21 Jul 2025 13:04:43 GMT

Hi,

I have the following content:

2025-07-20T06:00:38.027Z INFO 1 --- [db-monitor] [ main] c.d.i.d.util.DbMonitorCommandLineRunner : Outbox monitor results for destination sql - SELECT COUNT(DISTINCT product_id) FROM landing.pension_operations_events_streams WHERE TO_TIMESTAMP(headers_timestamp, 'DY MON DD HH24:MI:SS TZD YYYY')::date = CURRENT_DATE GROUP BY ALL : [{COUNT(DISTINCT PRODUCT_ID)=0}]

and

2025-07-20T06:00:38.025Z INFO 1 --- [db-monitor] [ main] c.d.i.d.util.DbMonitorCommandLineRunner : Outbox monitor results for source sql - SELECT COUNT(*) FROM product p WHERE p.updated_at::date = CURRENT_DATE : [{count=0}]

I want to be able to comapre [{COUNT(DISTINCT PRODUCT_ID)=0}] and [{count=0}]
and if those values are not equal, show a red icon in a dashboard or something like that.

Re: DPL extract single value and compare

Emm4nuel — Mon, 21 Jul 2025 16:17:36 GMT

I'm not sure what is the context where you want to apply this, but at least I'll provide you the parse sentence to extraxt the value you want to compare:

data record(content = "2025-07-20T06:00:38.027Z INFO 1 --- [db-monitor] [ main] c.d.i.d.util.DbMonitorCommandLineRunner : Outbox monitor results for destination sql - SELECT COUNT(DISTINCT product_id) FROM landing.pension_operations_events_streams WHERE TO_TIMESTAMP(headers_timestamp, 'DY MON DD HH24:MI:SS TZD YYYY')::date = CURRENT_DATE GROUP BY ALL : [{COUNT(DISTINCT PRODUCT_ID)=0}]"), record(content = "This is a string with UUID: --2025-07-20T06:00:38.025Z INFO 1 --- [db-monitor] [ main] c.d.i.d.util.DbMonitorCommandLineRunner : Outbox monitor results for source sql - SELECT COUNT(*) FROM product p WHERE p.updated_at::date = CURRENT_DATE : [{count=0}]") | parse content, """LD '::date' LD ':' ld '[' LD:data ']'"""

PARSE: | parse content, """LD '::date' LD ':' ld '[' LD:data ']'"""

topic DPL extract single value and compare in DQL

DPL extract single value and compare

Re: DPL extract single value and compare