Joelle - something like: select * from borrower_attributes where code = ' BANNERHOLD '
? Does that identify the records you are interested in? or is the bannerhold value the attribute? If so, then: select * from borrower_attributes where attribute = ' BANNERHOLD ' ? Stephen -----Original Message----- From: Koha <[email protected]> On Behalf Of Joelle Hannert Sent: 06 March 2020 15:11 To: Koha <[email protected]> Subject: [Koha] How to add authorized value to a report output 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
