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 <[email protected]> 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 <[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 >> > -- 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
