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

[rogan.hamby at gmail.com]

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
>