[Evergreen-reports] Circulation Report

Thu Jan 29 13:24:45 EST 2015

I think this needs to be placed in documentation somewhere. This is the best description I've heard for nullability in general.

You've made the world much clearer for me at least!  Thanks for that.

Thanks,
Geoff Sams
Library Manager
Roanoke Public Library

-----Original Message-----
From: Evergreen-reports [mailto:evergreen-reports-bounces at list.evergreen-ils.org] On Behalf Of Chris Sharp
Sent: Thursday, January 29, 2015 12:07 PM
To: Evergreen Community Reports Email List
Subject: Re: [Evergreen-reports] Circulation Report

Oh, sorry.

None = "do not allow nulls for this value either in the table I'm joining *from* or in the table I'm joining *to*" or "only bring back rows where both tables fully match" (which is the default JOIN when doing straight SQL).

----- Original Message -----
> From: "Chris Sharp" <csharp at georgialibraries.org>
> To: "Evergreen Community Reports Email List" 
> <evergreen-reports at list.evergreen-ils.org>
> Sent: Thursday, January 29, 2015 1:03:17 PM
> Subject: Re: [Evergreen-reports] Circulation Report
> 
> Jessica,
> 
> For Nullability Selection, here's the key:
> 
> The table you're joining *from* is always on the "left" and the table 
> you're joining *to* is always on the "right".
> 
> Child = "the table I'm joining *to* can have a null value in this field"
> (equivalent of a RIGHT JOIN)
> Parent = "the table I'm joining *from* can have a null value in this field"
> or "bring back rows even if this field is null on the 'left' table"
> (equivalent of a LEFT JOIN)
> Default = "do whichever join I would have done anyway" (which can 
> still be a LEFT or RIGHT JOIN)
> 
> So if you have a specific field that requires nullability selection, 
> you
> *probably* want Default when doing all of your other joins.  The way I 
> think of it, I'm manually forcing this one table to join the way I 
> want it to, but it's okay for all the other joins to work the way they normally do.
> 
> I hope that isn't too convoluted ;-).
> 
> Chris
> 
> ----- Original Message -----
> > From: "Jessica Venturo" <jventuro at biblio.org>
> > To: "Evergreen Community Reports Email List"
> > <evergreen-reports at list.evergreen-ils.org>
> > Sent: Thursday, January 29, 2015 12:15:24 PM
> > Subject: Re: [Evergreen-reports] Circulation Report
> > 
> > Hi Tina and Cristina,
> > 
> > Thanks for responding and sorry that it took me a little while to 
> > get back to you! I appreciate your help.
> > 
> > Tina - I have been starting from the Item source. I did try 
> > transforming the checkout date to year. I sent the report to the 
> > librarian for review, and he said it didn't help him because each 
> > item is listed muliple times for each year that it circed. This 
> > makes it difficult to compare data for all items.
> > I tried fiddling with Excel Pivot tables to get the display that he 
> > wanted (the years as columns), but I couldn't make it work. If 
> > anybody has ideas about how to manipulate the data in Excel, I would love that!
> > 
> > Cristina - I thought I would not need to use the nullabilty feature 
> > because a left outer join is already being done on circulation table 
> > from the Item source. However, I will admit that I am no expert in 
> > using the feature.
> > When
> > I check off "Enable nullability selection," I get the following 
> > options for the circulation table: None, Child, and Default. I would 
> > think selecting default would get me the desired results, but it 
> > doesn't seem to. Am I wrong on that?
> > 
> > Thanks again for your help!
> > Jessica
> > 
> > On Sat, Jan 24, 2015 at 9:52 PM, Cristina Hernandez Trotter < 
> > chtrotter at gmail.com > wrote:
> > 
> > 
> > 
> > Hi, Jessica,
> > 
> > Were you able to get the report yet? If not, I will be happy try my 
> > hand at it early next week. A couple of thoughts initially: 1) 
> > Nullability feature will probably have to be turned on to get the 
> > items with 0 circs in the past year (or previous year). 2) It should 
> > be easy to get the total circs and another circ count that is based 
> > on time frame, but I don't *think* getting the 3 circ numbers to 
> > appear all on one report will work in the reports module.
> > 
> > Cristina
> > 
> > On Fri, Jan 16, 2015 at 3:20 PM, Jessica Venturo < 
> > jventuro at biblio.org >
> > wrote:
> > 
> > 
> > 
> > Hi all,
> > 
> > I am working with a librarian who is trying to run a collection 
> > analysis for his library. He wanted to filter by Copy Location and 
> > Owning Library and include the following columns in his report: 
> > Author, Title, Pub Year, Call Number, Status,Owning Library, Copy 
> > Location, Total Circs, Total Circs current year, Total Circs 
> > previous year. I can handle the filters and most of the rest of it, 
> > but the last 3 columns have me stumped!
> > 
> > At first I thought I could use the pivot label column to display the 
> > circulation by year as columns in a report, but I quickly learned it 
> > was not meant to be used in this way. Next, I thought I could have 
> > him run three separate reports - one for that showed circ for the 
> > current year, one for the previous year, and one for total circs so 
> > that he could copy and paste columns into the same spreadsheet. 
> > However, I found that any items that had circulation outside of the 
> > entered date range did not show up in the report.
> > 
> > I'm curious - has anyone been able to provide something like this 
> > for their libraries? Any ideas would be greatly appreciated!
> > 
> > Thank you,
> > Jessica
> > 
> > --
> > Jessica Venturo
> > Applications Support Specialist
> > Bibliomation, Inc.
> > 24 Wooster Ave.
> > Waterbury, CT 06708
> > 203-577-4070 x105
> > 
> > _______________________________________________
> > Evergreen-reports mailing list
> > Evergreen-reports at list.evergreen-ils.org
> > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-rep
> > orts
> > 
> > 
> > 
> > _______________________________________________
> > Evergreen-reports mailing list
> > Evergreen-reports at list.evergreen-ils.org
> > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-rep
> > orts
> > 
> > 
> > 
> > 
> > --
> > Jessica Venturo
> > Applications Support Specialist
> > Bibliomation, Inc.
> > 24 Wooster Ave.
> > Waterbury, CT 06708
> > 203-577-4070 x105
> > 
> > _______________________________________________
> > Evergreen-reports mailing list
> > Evergreen-reports at list.evergreen-ils.org
> > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-rep
> > orts
> > 
> 
> --
> Chris Sharp
> PINES System Administrator
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, Georgia 30345
> (404) 235-7147
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/
> 

--
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/
_______________________________________________
Evergreen-reports mailing list
Evergreen-reports at list.evergreen-ils.org
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports