[Koha] How to add authorized value to a report output

[Stephen Graham]

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 <koha-bounces at lists.katipo.co.nz> On Behalf Of Joelle Hannert
Sent: 06 March 2020 15:11
To: Koha <koha at lists.katipo.co.nz>
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 Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha