| Summary: | Use Link Shortcuts when creating reports | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Joy Nelson <1joynelson> |
| Component: | Reports | Assignee: | Bugs List <koha-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
| Severity: | enhancement | ||
| Priority: | P5 - low | CC: | barton, josef.moravec, magnus, nick |
| 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: | |||
More possible links from wiki: https://wiki.koha-community.org/wiki/Permalinks |
The syntax to create links in SQL reports is cumbersome. The below link, as example, often gets typos and then fails to work when run. CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?' , 'biblionumber=' , biblionumber , '\">' , biblionumber , '</a>'), AS 'biblionumber', Koha needs a way to allow the user to enter a 'shorthand' or alias in the sql query that is then replaced by the URL. For example: SELECT biblionumber|link_detail from biblio would resolve to SELECT CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?' , 'biblionumber=' , biblionumber , '\">' , biblionumber , '</a>'), AS 'biblionumber' from biblio List of current links documented on the wiki that could use aliases: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Links