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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
