COPY (SELECT
id,
created,
modified,
reference,
category_id,
you_id,
partner_id,
disputed_savings_id,
'[deleted]' AS your_problem_notes,
'[deleted]' AS notes,
state,
dependants_young,
dependants_old,
on_passported_benefits,
on_nass_benefits,
specific_benefits,
is_you_or_your_partner_over_60,
has_partner,
calculations
FROM legalaid_eligibilitycheck
WHERE (modified >= %(from_date)s::timestamp AND modified <= %(to_date)s::timestamp)
OR (created >= %(from_date)s::timestamp AND created <= %(to_date)s::timestamp))
TO STDOUT CSV HEADER;

COPY (SELECT
id,
created,
modified,
reference,
category_id,
you_id,
partner_id,
disputed_savings_id,
'[deleted]' AS your_problem_notes,
'[deleted]' AS notes,
state,
dependants_young,
dependants_old,
on_passported_benefits,
on_nass_benefits,
specific_benefits,
CASE WHEN lower(disregards::text) LIKE '%%:true%%' THEN 'Yes' ELSE 'No' end as "Disregarded Payment",
is_you_or_your_partner_over_60,
has_partner,
calculations
FROM legalaid_eligibilitycheck
WHERE (modified >= %(from_date)s::timestamp AND modified <= %(to_date)s::timestamp)
OR (created >= %(from_date)s::timestamp AND created <= %(to_date)s::timestamp))
TO STDOUT CSV HEADER;

Add disregards in the eligibility report
Add disregards in the eligibility report

If Yes is given as answer to any disregards then use a value of "Yes" or a value of "No" in the eligibility report
