Looks like Nora Blake beat us to that idea!<br><br>Nora - here's the statement for total collection size that Nichole wrote for us last year: If you don't care about the shelving location, you can delete "i.location" from the statement.<br>
<br>SELECT count(i.biblionumber) as added, i.itype, i.homebranch,<br>i.location from items i WHERE i.dateaccessioned < '2009-01-01' GROUP BY i.homebranch,i.itype,i.location ORDER BY i.homebranch,i.itype,i.location asc<br>
<br>Sharon<br><br><div class="gmail_quote">On Thu, Apr 30, 2009 at 10:12 AM, Lenora Oftedahl <span dir="ltr"><<a href="mailto:oftl@critfc.org" target="_blank">oftl@critfc.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
If you leave the SQL column blank and put in the notes that this is a wish for the future, I think that would work.<br>
<br>
>>> Sharon Moreland <<a href="mailto:smoreland@nekls.org" target="_blank">smoreland@nekls.org</a>> 04/30/09 8:15 AM >>><br>
<div>I was fuzzy on which 'module' the reports I added this morning belong to, so<br>
I sort of guessed that:<br>
<br>
"FROM items" had to do with the Catalog and<br>
"FROM borrowers" sometimes went to Circulation and other times just into<br>
Patrons<br>
<br>
On the NExpress<br>
</div>Reports<<a href="http://www.nexpresslibrary.org/training/reports-training/" target="_blank">http://www.nexpresslibrary.org/training/reports-training/</a>>page,<br>
<div><div></div><div>I have the statements grouped by use => Bibliographic/Catalog<br>
maintenance, statistical reports, and patron-related reports<br>
<br>
Also, can we include on that SQL library wiki page a 'wish list' of reports<br>
we'd like to have but don't? For example, I would love a SQL statement that<br>
recreates the Circulation Wizard report output, but that combines Issues and<br>
Renewals into one number. I really hate running that wizard twice for each<br>
of our 20+ libraries to get TRUE monthly circ stats.<br>
<br>
Sharon<br>
<br>
On Thu, Apr 30, 2009 at 7:04 AM, <<a href="mailto:rafael.antonio@sapo.pt" target="_blank">rafael.antonio@sapo.pt</a>> wrote:<br>
<br>
> Nicole,<br>
><br>
> We could begin adding SQL scripts but later try to organize them by<br>
> modules - catalog, loans, management..<br>
> If they grow in number this could be a better aproach.<br>
><br>
> Regards,<br>
><br>
> Rafael Antonio<br>
><br>
> Citando Nicole Engard <<a href="mailto:nicole.engard@liblime.com" target="_blank">nicole.engard@liblime.com</a>>:<br>
><br>
> > What do you mean? All you have to do is register for the wiki to add<br>
> > your own reports.<br>
> ><br>
> > PS. Remember to click REPLY TO ALL so that everyone gets your replies :)<br>
> ><br>
> > ---<br>
> ><br>
> > Nicole C. Engard<br>
> > Open Source Evangelist, LibLime<br>
> > (888) Koha ILS (564-2457) ext. 714<br>
> > <a href="mailto:nce@liblime.com" target="_blank">nce@liblime.com</a><br>
> > AIM/Y!/Skype: nengard<br>
> ><br>
> > <a href="http://liblime.com" target="_blank">http://liblime.com</a><br>
> > <a href="http://blogs.liblime.com/open-sesame/" target="_blank">http://blogs.liblime.com/open-sesame/</a><br>
> ><br>
> ><br>
> ><br>
> > On Thu, Apr 30, 2009 at 7:31 AM, <<a href="mailto:rafael.antonio@sapo.pt" target="_blank">rafael.antonio@sapo.pt</a>> wrote:<br>
> >> Nicole,<br>
> >><br>
> >> This is a very good help.<br>
> >> May be someone can create a general structure where people can add SQL<br>
> >> Regards,<br>
> >><br>
> >> Rafael<br>
> >><br>
> >> Citando Nicole Engard <<a href="mailto:nicole.engard@liblime.com" target="_blank">nicole.engard@liblime.com</a>>:<br>
> >><br>
> >>> You guys rock!!!<br>
> >>><br>
> >>> For those who don't know how to find it - here's the link:<br>
> >>> <a href="http://wiki.koha.org/doku.php?id=sql_library" target="_blank">http://wiki.koha.org/doku.php?id=sql_library</a><br>
> >>><br>
> >>> I will add this to the manual !!!!<br>
> >>><br>
> >>> ---<br>
> >>><br>
> >>> Nicole C. Engard<br>
> >>> Open Source Evangelist, LibLime<br>
> >>> (888) Koha ILS (564-2457) ext. 714<br>
> >>> <a href="mailto:nce@liblime.com" target="_blank">nce@liblime.com</a><br>
> >>> AIM/Y!/Skype: nengard<br>
> >>><br>
> >>> <a href="http://liblime.com" target="_blank">http://liblime.com</a><br>
> >>> <a href="http://blogs.liblime.com/open-sesame/" target="_blank">http://blogs.liblime.com/open-sesame/</a><br>
> >>><br>
> >>><br>
> >>><br>
> >>> 2009/4/29 Sharon Moreland <<a href="mailto:smoreland@nekls.org" target="_blank">smoreland@nekls.org</a>>:<br>
> >>>><br>
> >>>> Give me a few days, but I will get the NExpress SQL statements added<br>
> to<br>
> >>>> the<br>
> >>>> wiki. Good job Lenora!<br>
> >>>><br>
> >>>> Sharon<br>
> >>>><br>
> >>>> On Wed, Apr 29, 2009 at 10:55 AM, Lenora Oftedahl <<a href="mailto:OFTL@critfc.org" target="_blank">OFTL@critfc.org</a>><br>
> >>>> wrote:<br>
> >>>>><br>
> >>>>> OK. I put my money where my mouth is and created a SQL library page<br>
> in<br>
> >>>>> the<br>
> >>>>> Koha Wiki as challenged by MJ Ray. I've even got an example up for<br>
> >>>>> others<br>
> >>>>> to follow.<br>
> >>>>><br>
> >>>>> Lenora<br>
> >>>>> StreamNet Regional Librarian<br>
> >>>>> Columbia River Inter-Tribal Fish Commission<br>
> >>>>><br>
> >>>>> >>> MJ Ray <<a href="mailto:mjr@phonecoop.coop" target="_blank">mjr@phonecoop.coop</a>> 4/29/2009 1:00 AM >>><br>
> >>>>> "Lenora Oftedahl" <<a href="mailto:OFTL@critfc.org" target="_blank">OFTL@critfc.org</a>> wrote:<br>
> >>>>> > Hello all. I haven't seen an announcement, but there was talk at<br>
> the<br>
> >>>>> > Koha Conference that a SQL repository would be developed so we<br>
> could<br>
> >>>>> > post our most excellent SQL reports and wouldn't all have to write<br>
> the<br>
> >>>>> > same report request over and over.<br>
> >>>>><br>
> >>>>> Why not add them to <a href="http://wiki.koha.org" target="_blank">http://wiki.koha.org</a> or <a href="http://contribs.koha.org" target="_blank">http://contribs.koha.org</a><br>
> >>>>> depending on if they're simple SQL (wiki) or scripts too (contribs)?<br>
> >>>>><br>
> >>>>> Confused,<br>
> >>>>> --<br>
> >>>>> MJ Ray (slef). LMS developer and supporter for a small, friendly<br>
> >>>>> worker cooperative <a href="http://www.ttllp.co.uk/" target="_blank">http://www.ttllp.co.uk/</a> <a href="http://mjr.towers.org.uk/" target="_blank">http://mjr.towers.org.uk/</a><br>
> >>>>> (Notice <a href="http://mjr.towers.org.uk/email.html" target="_blank">http://mjr.towers.org.uk/email.html</a>) tel:+44-844-4437-237<br>
> >>>>> _______________________________________________<br>
> >>>>> Koha mailing list<br>
> >>>>> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>>>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>>>><br>
> >>>>> _______________________________________________<br>
> >>>>> Koha mailing list<br>
> >>>>> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>>>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>>><br>
> >>>><br>
> >>>><br>
> >>>> --<br>
> >>>> Sharon Moreland<br>
> >>>> Technology Consultant<br>
> >>>> Northeast Kansas Library System<br>
> >>>><br>
> >>>> _______________________________________________<br>
> >>>> Koha mailing list<br>
> >>>> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>>><br>
> >>>><br>
> >>> _______________________________________________<br>
> >>> Koha mailing list<br>
> >>> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> >>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> >>><br>
> >><br>
> >><br>
> ><br>
><br>
> _______________________________________________<br>
> Koha mailing list<br>
> <a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
><br>
<br>
<br>
<br>
--<br>
Sharon Moreland<br>
Technology Consultant<br>
Northeast Kansas Library System<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Sharon Moreland<br>Technology Consultant<br>Northeast Kansas Library System<br>