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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha