From bugzilla-daemon@bugs.koha-community.org Mon Mar 18 22:24:03 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 22535] New: Use Link Shortcuts when creating reports Date: Mon, 18 Mar 2019 21:24:00 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2452788214719093912==" --===============2452788214719093912== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit 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('' , biblionumber , ''), 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('' , biblionumber , ''), 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. --===============2452788214719093912==-- From bugzilla-daemon@bugs.koha-community.org Wed Mar 20 12:26:21 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 22535] Use Link Shortcuts when creating reports Date: Wed, 20 Mar 2019 11:25:52 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6694701844761999918==" --===============6694701844761999918== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22535 Josef Moravec changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |josef.moravec@gmail.com -- You are receiving this mail because: You are watching all bug changes. --===============6694701844761999918==-- From bugzilla-daemon@bugs.koha-community.org Tue Mar 26 22:12:10 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 22535] Use Link Shortcuts when creating reports Date: Tue, 26 Mar 2019 21:12:07 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3777308482738615208==" --===============3777308482738615208== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22535 Barton Chittenden changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |barton@bywatersolutions.com --- Comment #1 from Barton Chittenden --- More possible links from wiki: https://wiki.koha-community.org/wiki/Permalinks -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============3777308482738615208==-- From bugzilla-daemon@bugs.koha-community.org Fri Jul 26 07:59:41 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 22535] Use Link Shortcuts when creating reports Date: Fri, 26 Jul 2019 05:59:11 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1394791553126782846==" --===============1394791553126782846== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22535 Magnus Enger changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |magnus@libriotech.no -- You are receiving this mail because: You are watching all bug changes. --===============1394791553126782846==-- From bugzilla-daemon@bugs.koha-community.org Fri Jan 14 17:21:33 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 22535] Use Link Shortcuts when creating reports Date: Fri, 14 Jan 2022 16:21:32 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1790387549069881428==" --===============1790387549069881428== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22535 Nick Clemens changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE CC| |nick@bywatersolutions.com Status|NEW |RESOLVED --- Comment #2 from Nick Clemens --- *** This bug has been marked as a duplicate of bug 5697 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============1790387549069881428==--