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 <[email protected]> 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 > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
