[Koha-bugs] [Bug 32413] New: JSON reports shows inaccurate results with repeated parameters

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32413

            Bug ID: 32413
           Summary: JSON reports shows inaccurate results with repeated
                    parameters
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: cbrannon at cdalibrary.org
        QA Contact: testopia at bugs.koha-community.org

If I create a report that uses a repeating parameter, for example <<library>>,
more than once in a report, and then run a JSON call on that report, I get
inaccurate results (Like every other result).

Currently, the only workaround is to make each parameter unique, and then
repeat the parameter over as many times as it is needed in the report.  For
example,

https://mydomain.com/cgi-bin/koha/svc/report?id=938&sql_params=blah would only
return half the results if the report because I use the same parameters 7 times
int he sql.  However, if I rename each parameter something different, like
<<library1>>, <<library2>>,etc, and call
https://mydomain.com/cgi-bin/koha/svc/report?id=938&sql_params=blah&sql_params=blah&sql_params=blah&sql_params=blah&sql_params=blah&sql_params=blah&sql_params=blah,
it works.

The JSON call needs to be updated to accept repeated parameters.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.