We're updating the issue view to help you get more done. 

Patient Deceased Report - omits patients with no DOB

Description

The sql includes the statements:
left join entities loc on loc.entity_id = el.target_id
join entity_details d1 on d1.entity_id = p.entity_id and d1.name = "dateOfBirth"
join entity_details d2 on d2.entity_id = p.entity_id and d2.name = "deceasedDate"
join entity_details d3 on d3.entity_id = p.entity_id and d3.name = "deceased"

The second line above should be a left join rather than a join.

the attached jrxml is the A4 format one and included the fix in

Environment

None

Status

Assignee

Tim Anderson

Reporter

Tim Gething

Labels

None

Components

Fix versions

Affects versions

1.9
2.0

Priority

Trivial