(http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_guided_reports)
Guided reports are great. However, they are fully hardcoded SQL atm. There's no possibilities to have parameters that are fixed at run time. That would be usefull, for example, when you want to build a report that runs between a date range, or on a given branch or itemtype. for example, a tool to let a given branch see what they added in the catalogue could be : SELECT biblio,author FROM biblio LEFT JOIN items USING(biblionumber) WHERE items.homebranch=XXX This RFC suggest to add some improvements to be able to specify XXX at runtime. - A simple solution could be to have a specific syntax to say "enter value here". For example : ??? - A better sotution could be to have the syntax + a label to display to the patron. For example : ???Enter branch code??? that would display "Enter branch code : _______" in the <form> - The best solution would be to have a list where applicable (branch, itemtype...). The 2 first are easy to code, the 3rd could be tricky. but undoubtfully usefull ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
