[Koha-bugs] [Bug 7335] New: Allow custom parameters for sorting in sql reports

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7335

             Bug #: 7335
           Summary: Allow custom parameters for sorting in sql reports
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: rel_3_4
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: katrin.fischer at bsz-bw.de
         QAContact: ian.walls at bywatersolutions.com


I was trying to find a solution to make it possible to select how a report is
sorted before running it.

Perhaps we could have a table sorter on tables generated by reports? 

I tried using the placeholders to provide a pull down with search options, but
this didn't work. The replaced text is always in quotes, so the generated sql
will not work:

select concat(surname, ", ", firstname) as Name, cardnumber from borrowers
order by 'cardnumber desc'

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.