Uploaded image for project: 'Reporting Module'
  1. Reporting Module
  2. REPORT-417

Coded numeric cohort generates wrong data

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: TBD
    • Resolution: Fixed
    • Affects Version/s: Reporting 0.7.2
    • Fix Version/s: Reporting 0.7.2
    • Component/s: Cohort Definitions
    • Labels:
      None
    • Complexity:
      Undetermined

      Description

      The reporting coded numeric cohort produces incorrect (maybe?) values. Mysql results are different from the reporting results.

      The image shows the setup of the cohort, which produces only 6 patients.

      This produces 265 patients:

      select p.patient_id, o.value_numeric, o.obs_datetime
        from patient p, obs o
       where p.patient_id = o.person_id
         and o.concept_id = 5497
         and o.value_numeric < 350
         and o.voided = 0
         and p.voided = 0;
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              Assignee:
              mseaton Mike Seaton
              Reporter:
              ball Ellen Ball
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h