https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22535 Bug ID: 22535 Summary: Use Link Shortcuts when creating reports Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: joy@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org Target Milestone: --- 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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.