intakedesk / PowerBI-General

Placeholder for issues migrated from Jira
1 stars 0 forks source link

Decline Reason SQL body not declining for Zantac (wrong Product ID), everywhere #587

Closed jesusitd closed 4 years ago

jesusitd commented 4 years ago
        WHEN '526f1203-9367-ec7e-73bd-594553339980' THEN CASE WHEN NULLIF(leads.blood_thinner_decline_reason, '') IS NOT NULL THEN leads.blood_thinner_decline_reason WHEN leads.status IN ('dnq', 'Spanish_Only', 'dnq_requalify', 'not_interested', 'No_Longer_Taking_No_Injury', 'already_has_attorney') OR leads_cstm.current_dialer_disposition_c = 'DNQ' THEN '(No Input)' ELSE NULL END -- Xarelto
        WHEN '526f1203-9367-ec7e-73bd-594553339980' THEN CASE WHEN NULLIF(leads.zantac_decline_reason, '') IS NOT NULL THEN leads.zantac_decline_reason WHEN leads.status IN ('dnq', 'Spanish_Only', 'dnq_requalify', 'not_interested', 'No_Longer_Taking_No_Injury', 'already_has_attorney') OR leads_cstm.current_dialer_disposition_c = 'DNQ' THEN '(No Input)' ELSE NULL END -- Zantac
        ELSE NULL
    END AS 'Decline
jesusitd commented 4 years ago

Correct Product ID = 'd5f9e798-4e41-9201-67c2-5e851ac694bb'

jesusitd commented 4 years ago

Done.