Dustin Surwill (dsurwill@shield-legal.com)
2025-08-28 16:13:37
lead_history_status.csv
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-28 16:17:02

select leadid, date, fromstatus, tostatus, case_type.name as case_type, firstname, lastname from lead_history_status left join lead on lead_history_status.leadid = lead.id left join case_type on lead.casetypeid = case_type.id left join public.contact c on c.id = lead.contactid where fromstatus='Signed e-Sign - Billable Declined by Firm' and date>='2025-05-01' and tostatus!='Signed e-Sign - Billable Declined by Firm'

Result_10.csv