I was fuzzy on which 'module' the reports I added this morning belong to, so 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 Patrons<br>
<br>On the <a href="http://www.nexpresslibrary.org/training/reports-training/">NExpress Reports</a> page, I have the statements grouped by use => Bibliographic/Catalog maintenance, statistical reports, and patron-related reports<br>
<br>Also, can we include on that SQL library wiki page a 'wish list' of reports we'd like to have but don't? For example, I would love a SQL statement that recreates the Circulation Wizard report output, but that combines Issues and Renewals into one number. I really hate running that wizard twice for each of our 20+ libraries to get TRUE monthly circ stats.<br>
<br>Sharon<br><br><div class="gmail_quote">On Thu, Apr 30, 2009 at 7:04 AM, <span dir="ltr"><<a href="mailto:rafael.antonio@sapo.pt">rafael.antonio@sapo.pt</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;">
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>
<div><div></div><div class="h5"><br>
Citando Nicole Engard <<a href="mailto:nicole.engard@liblime.com">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">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">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">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">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">smoreland@nekls.org</a>>:<br>
>>>><br>
>>>> Give me a few days, but I will get the NExpress SQL statements added 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">OFTL@critfc.org</a>><br>
>>>> wrote:<br>
>>>>><br>
>>>>> OK. I put my money where my mouth is and created a SQL library page 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">mjr@phonecoop.coop</a>> 4/29/2009 1:00 AM >>><br>
>>>>> "Lenora Oftedahl" <<a href="mailto:OFTL@critfc.org">OFTL@critfc.org</a>> wrote:<br>
>>>>> > Hello all. I haven't seen an announcement, but there was talk at the<br>
>>>>> > Koha Conference that a SQL repository would be developed so we could<br>
>>>>> > post our most excellent SQL reports and wouldn't all have to write 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">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">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">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">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">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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Sharon Moreland<br>Technology Consultant<br>Northeast Kansas Library System<br>