https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20704 Bug ID: 20704 Summary: Add borrower attribute types as run time parameters in reports Change sponsored?: --- Product: Koha Version: 17.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: barton@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org Feature request: add <<*|attribute_type>> as a run time parameter. This would list the values from borrower_attribute_types.description in a drop down, and choose the corresponding value of borrower_attribute_types.code. For example, let's say that we had the following values in borrower_attribute_types: +--------------------+----------+ | description | code | +--------------------+----------+ | Drivers License | DL | | Favourite Colour | FAVCOLOR | | PC Allowed | PC | | Previous system ID | PREVID | +--------------------+----------+ Then we could write queries like: SELECT firstname, surname, cardnumber, attribute FROM borrowers INNER JOIN borrower_attributes USING (borrowernumber) WHERE borrower_attributes.code = <<Borrower attribute type|attribute_type>> When run, the user would be prompted for 'Borrower attribute type', and would get a drop down containing +--------------------+ | Drivers License | | Favourite Colour | | PC Allowed | | Previous system ID | +--------------------+ -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.