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

[rogan.hamby at gmail.com]

You can just select the value then, take out the "and ba.attribute = 'YES'"
and add ba.attribute to your select statement.

On Fri, Mar 6, 2020 at 12:01 PM Joelle Hannert <jhannert at nmc.edu> wrote:

> 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
>