Uploaded image for project: 'VPMS Web Application'
  1. OVPMS-1979

Patient Deceased Report - omits patients with no DOB

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Trivial
    • Resolution: Fixed
    • Affects versions: 1.9, 2.0
    • Fix versions: 2.0
    • Components: Reporting
    • Labels:
      None
    • Sprint:

      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 OVPMS-1952 Resolved

        Attachments

          Activity

            People

            • Assignee:
              Tim Anderson
              Reporter:
              Tim Gething (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Who's Looking?