Uploaded image for project: 'OpenMRS - ADX -  DHIS Report Module'
  1. OpenMRS - ADX - DHIS Report Module
  2. DRM-9

startOfPeriod and endOfPeriod not there exception should be handled properly

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Should
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Complexity:
      Low

      Description

      To reproduce the exception:

      1.Install the module, upload the basic report template available at the github repo- https://github.com/hispindia/dhisreport
      2. Go to the reports link and click on the report name to edit the sql and replace it with :
      select count(distinct p.person_id)
      from person p
      inner join obs o on o.person_id = p.person_id
      where p.voided = 0 and o.voided = 0
      and o.concept_id = 1425
      and o.value_numeric = 4
      3. Now try to Post/Preview the report from the reports link and give any simple inputs as shown in the image and try preview.
      4. This results in an exception as shown below in the images attached as well.

      Instead of this unhandled exception, the user should be redirected to the post/preview page with a message mentioning the sql query does not contain startOfPeriod and/or endOfPeriod

        Gliffy Diagrams

          Attachments

            Attachments-Category-Modification

              Activity

                People

                • Assignee:
                  choxmi Choxmi Sathsara
                  Reporter:
                  maurya Sri Maurya Kummamuru
                  Watchers:
                  Choxmi Sathsara, Daniel Kayiwa, Hillary Bagiire, Jai Tatia, Sri Maurya Kummamuru, Yu Ting Wu
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated: