[Koha-bugs] [Bug 20704] New: Add borrower attribute types as run time parameters in reports
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu May 3 16:12:06 CEST 2018
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 at lists.koha-community.org
Reporter: barton at bywatersolutions.com
QA Contact: testopia at 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.
More information about the Koha-bugs
mailing list