DPL extract single value and compare

[almog50]

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.

[Emm4nuel · Accepted solution]

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 ']'"""