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 <rogan.hamby@gmail.com> 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 <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
-- Joelle Hannert Library Technical Services Coordinator Northwestern Michigan College (231) 995-1684 Work days: M, W, Th, F