| Summary: | Add borrower attribute types as run time parameters in reports | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Barton Chittenden <barton> |
| Component: | Reports | Assignee: | Bugs List <koha-bugs> |
| Status: | NEW --- | QA Contact: | Testopia <testopia> |
| Severity: | enhancement | ||
| Priority: | P5 - low | ||
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
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 | +--------------------+