[Koha-devel] RFC 3.2 : guided reports improved

[Paul POULAIN]

(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