Re: [OPEN-ILS-GENERAL] Reports including in-house use

[Mike Rylander]

I do what I can. :)

Regards,

Mike Rylander

--   Sent from my phone, please pardon my thumbs.
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com
On May 18, 2016 7:04 PM, "Jane Sandberg"  wrote:

> Mike Rylander, you are a gentleman and a scholar.  That was the trick!
> Thanks!
>
> On Wed, May 18, 2016 at 11:10 AM, Mike Rylander 
> wrote:
> > Jane,
> >
> > You should be able to enable nullability, start with the In-house Use
> > source, and select a "parent nullable" (right join) link to items.
> > Does that work for you?
> >
> > Regards,
> >
> > --
> > Mike Rylander
> >  | President
> >  | Equinox Software, Inc. / Open Your Library
> >  | phone:  1-877-OPEN-ILS (673-6457)
> >  | email:  mi...@esilibrary.com
> >  | web:  http://www.esilibrary.com
> >
> >
> > On Wed, May 18, 2016 at 12:31 PM, Jane Sandberg 
> wrote:
> >> Hi colleagues,
> >>
> >> I am trying to create a report in the reporter that lists all items
> >> and how many in-house uses they have.
> >>
> >> * I can use In-house Use as my initial source, but then I don't get
> >> any items with 0 in-house uses.
> >> * I can use Item as my initial source, but it doesn't seem to be
> >> linked to the In-house use table for reporter purposes.
> >>
> >> I was thinking of filing a launchpad bug that a link to in-house use
> >> is missing from the item source.  However, I want to make sure that I
> >> am not missing something!
> >>
> >> Thanks!
> >>
> >>   -Jane
> >>
> >> --
> >> Jane Sandberg
> >> Electronic Resources Librarian
> >> Linn-Benton Community College
> >> sand...@linnbenton.edu / 541-917-4655
>
>
>
> --
> Jane Sandberg
> Electronic Resources Librarian
> Linn-Benton Community College
> sand...@linnbenton.edu / 541-917-4655
>

Re: [OPEN-ILS-GENERAL] Reports including in-house use

[Jane Sandberg]

Mike Rylander, you are a gentleman and a scholar.  That was the trick!  Thanks!

On Wed, May 18, 2016 at 11:10 AM, Mike Rylander  wrote:
> Jane,
>
> You should be able to enable nullability, start with the In-house Use
> source, and select a "parent nullable" (right join) link to items.
> Does that work for you?
>
> Regards,
>
> --
> Mike Rylander
>  | President
>  | Equinox Software, Inc. / Open Your Library
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  mi...@esilibrary.com
>  | web:  http://www.esilibrary.com
>
>
> On Wed, May 18, 2016 at 12:31 PM, Jane Sandberg  
> wrote:
>> Hi colleagues,
>>
>> I am trying to create a report in the reporter that lists all items
>> and how many in-house uses they have.
>>
>> * I can use In-house Use as my initial source, but then I don't get
>> any items with 0 in-house uses.
>> * I can use Item as my initial source, but it doesn't seem to be
>> linked to the In-house use table for reporter purposes.
>>
>> I was thinking of filing a launchpad bug that a link to in-house use
>> is missing from the item source.  However, I want to make sure that I
>> am not missing something!
>>
>> Thanks!
>>
>>   -Jane
>>
>> --
>> Jane Sandberg
>> Electronic Resources Librarian
>> Linn-Benton Community College
>> sand...@linnbenton.edu / 541-917-4655



-- 
Jane Sandberg
Electronic Resources Librarian
Linn-Benton Community College
sand...@linnbenton.edu / 541-917-4655

Re: [OPEN-ILS-GENERAL] Reports including in-house use

[Mike Rylander]

Jane,

You should be able to enable nullability, start with the In-house Use
source, and select a "parent nullable" (right join) link to items.
Does that work for you?

Regards,

--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, May 18, 2016 at 12:31 PM, Jane Sandberg  wrote:
> Hi colleagues,
>
> I am trying to create a report in the reporter that lists all items
> and how many in-house uses they have.
>
> * I can use In-house Use as my initial source, but then I don't get
> any items with 0 in-house uses.
> * I can use Item as my initial source, but it doesn't seem to be
> linked to the In-house use table for reporter purposes.
>
> I was thinking of filing a launchpad bug that a link to in-house use
> is missing from the item source.  However, I want to make sure that I
> am not missing something!
>
> Thanks!
>
>   -Jane
>
> --
> Jane Sandberg
> Electronic Resources Librarian
> Linn-Benton Community College
> sand...@linnbenton.edu / 541-917-4655