From bugzilla-daemon@bugs.koha-community.org Fri Feb  2 17:24:06 2024
From: bugzilla-daemon@bugs.koha-community.org
To: koha-bugs@lists.koha-community.org
Subject: [Koha-bugs] [Bug 5920] Remove HTML from downloaded reports
Date: Fri, 02 Feb 2024 16:24:06 +0000
Message-ID: <bug-5920-70-1KXYpSSJot@https.bugs.koha-community.org/bugzilla3/>
In-Reply-To: <bug-5920-70@https.bugs.koha-community.org/bugzilla3/>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0847670332329960390=="

--===============0847670332329960390==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3D5920

--- Comment #17 from Andrew Fuerste-Henry <andrewfh@dubcolib.org> ---
Clearly I've doing this too early in the morning. I applied your patches to my
testing docker and then ran my reports on the wrong Koha.

When I follow my test plan correctly, this works!
However, for my test report:
SELECT
  biblionumber,=20
  CONCAT('<a
href=3D\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=3D',biblionumber,'\">=
',title,'</a>')
AS Title=20
  from biblio

When I download CSV or ODS formats, the second column contains just the title.
When I download TSV format, the second column contains just the biblionumber
(so the report is two columns of the same data).
It'd be best if all 3 options work the same way. But I'm happy to sign off on
this and pursue that consistency in a new bug if desired; this is absolutely
useful as-is.

--=20
You are receiving this mail because:
You are watching all bug changes.
You are the QA Contact for the bug.

--===============0847670332329960390==--