[Koha] How to add authorized value to a report output

[Joelle Hannert]

Sorry, I should have been more clear. I'm not trying to select on the
BANNERHOLD status (YES/NO/blank), I just want the contents of that field to
be included in the report output for each patron reported.

On Fri, Mar 6, 2020 at 10:29 AM <rogan.hamby at gmail.com> wrote:

> Hi Joelle,
>
> For the linking between borrower and borrower attributes you want to say
> which borrower attribute you want via the code and you may want to specify
> the value like this:
>
>  select b.cardnumber from borrowers b join borrower_attributes ba on
> ba.borrowernumber = b.borrowernumber where ba.code = 'BANNERHOLD' and
> ba.attribute = 'YES';
>
>
>
> On Fri, Mar 6, 2020 at 10:12 AM Joelle Hannert <jhannert at nmc.edu> wrote:
>
>> I'm trying to get a report to include an output of a custom borrower
>> attribute, but having trouble coming up with the correct way to ask for
>> this in the SQL code. I feel like the answer is somewhere on this schema
>> page:
>> http://schema.koha-community.org/18_11/tables/borrower_attributes.html
>> but
>> nothing I'm trying is working. The authorized value for our local
>> attribute
>> is "BANNERHOLD."
>> I tried the following:
>>
>>    - borrower_attributes.bannerhold
>>    - borrower_attribute_types.bannerhold
>>    - code.bannerhold
>>
>> I don't really understand how the relationships work, so it's just trial
>> and error for me. Any advice would be much appreciated!
>>
>> Joelle
>>
>> --
>> Joelle Hannert
>> Library Technical Services Coordinator
>> Northwestern Michigan College
>> (231) 995-1684
>> Work days: M, W, Th, F
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>

-- 
Joelle Hannert
Library Technical Services Coordinator
Northwestern Michigan College
(231) 995-1684
Work days: M, W, Th, F