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

SqlDataSetDefinitions do not properly handle List parameters

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Must
    • Resolution: Fixed
    • Affects Version/s: Reporting 0.8.2
    • Fix Version/s: Reporting 0.9.3
    • Component/s: DataSet Definitions
    • Labels:
      None
    • Complexity:
      Low

      Description

      To reproduce:

      1. Create a new Sql Data Set Definition, and give it a List of Locations as a parameter. Name it "locations".

      2. For the SQL behind this DSD, set it to:

      select encounter_id, encounter_datetime, location_id
      from encounter
      where location_id in (:locations)
      

      3. Make sure you have at least 2 locations configured on the system.

      4. Preview the data set definition, choosing at least 2 locations for the "locations" parameter value

      This will result in the following error:

      java.lang.RuntimeException
      java.sql.SQLException: Operand should contain 1 column(s)
      

        Attachments

          Activity

            People

            • Assignee:
              mseaton Mike Seaton
              Reporter:
              mseaton Mike Seaton
            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: