[Koha] Has anyone written a report for analyzing age of collection?

Chris Cormack chris at bigballofwax.co.nz
Thu Jun 17 08:43:16 NZST 2010


On 17 June 2010 07:33, Susan O'Neal <soneal at mtpl.org> wrote:
> Hi Chris- nice to hear from you and so quickly!  See the attached Excel
> spreadsheet for how I would like to organize, and, if possible, retrieve
> the information.  I do not wish to know the specific titles or call
> numbers at this point just the total numbers.  The I'll compute the
> average age of the collection.   I've been frustrated in Koha report by
> not being able to figure out how to collect 3 units of data in the same
> report. Does that make sense?  My SQL ability is pretty limited to cut
> and paste ............
>
> Branch
> Collection
> Date [range]
>
Ok, would itemtype work instead of collection (one less table to join)
and do you use item level itemtypes?

And can you check your koha2marc mappings and see what field (if any)
260c is linked to?

Chris


More information about the Koha mailing list