Cindy,
You may also want to try changing
> WHERE items.ccode = 'BK%'
...to...
WHERE items.ccode LIKE 'BK%'
...if you're trying to match on any ccode starting with "BK"
Also, I'm not sure if your ILS has this or not, but in Koha 3.2 and above
there is a neat feature in Reports called Runtime
On 29 June 2011 10:24, Cindy Weber wrote:
> I'm trying to write a report that will list items with the number of
> holds/items over a certain number and then list the number of holds
> placed per library. Since the holds to items ratio is different
> depending on the format of the item (book, DVD
I'm trying to write a report that will list items with the number of
holds/items over a certain number and then list the number of holds
placed per library. Since the holds to items ratio is different
depending on the format of the item (book, DVD, CD, etc.) I'm thinking
I've got to have one r
3 matches
Mail list logo