Dustin Surwill (dsurwill@shield-legal.com)
2025-08-28 12:37:00
postgres_public_lead_note_4.csv
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-28 12:37:08

select ** from lead_note where leadid in ( select leadid from lead_history_status where (tostatus='Signed & DECLINED' OR tostatus='Signed & DECLINED ReTriggered') and date>=(NOW() - INTERVAL '2 WEEKS') ) -- and updatedate>=(NOW() - INTERVAL '1 MONTH') and leadid in (select id from lead where casetypeid in (select id from case_type where name ILIKE '%Paraquat%'))

:thank_you: Edward Weber