From bugzilla-daemon@bugs.koha-community.org Mon Aug 15 15:52:16 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] New: Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Mon, 15 Aug 2022 13:52:15 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0961909326875182491==" --===============0961909326875182491== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3D31361 Bug ID: 31361 Summary: Button batch operations disappears when alias is used for itemnumber of biblionumber Change sponsored?: --- Product: Koha Version: 21.11 Hardware: All OS: Windows Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: j.m.koopmans@saxion.nl QA Contact: testopia@bugs.koha-community.org Created attachment 139128 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3D139128&action= =3Dedit screenshot report result with batch modification button When running a SQL-report and using an alias for itemnumber or biblionumber in SELECT, the button for 'Batch operations with 20 visible records' disappears. Using an alias for other columns is no problem. Example SQL with button: SELECT items.itemnumber,items.barcode,items.notforloan as Status,biblio.title,items.ccode as Itemtype FROM items=20 LEFT JOIN biblioitems on (items.biblioitemnumber=3Dbiblioitems.biblioitemnumb= er)=20 LEFT JOIN biblio on (biblioitems.biblionumber=3Dbiblio.biblionumber) =20 WHERE items.homebranch=3D<> AND items.itype=3D<> AND items.notforloan=3D<> ORDER BY items.itemnumber asc Changing it to 'SELECT items.itemnumber as Itemnr, etc.' removes the button a= nd the ability for batch processing. The same thing occurs when using an alias for biblionumber in a report. Example SQL with button: SELECT CONCAT ('',biblio.title,' ') as Titel, items.biblionumber,biblio.datecreated as Datum FROM items=20 LEFT JOIN biblioitems on (items.biblioitemnumber=3Dbiblioitems.biblioitemnumb= er)=20 LEFT JOIN biblio on (biblioitems.biblionumber=3Dbiblio.biblionumber)=20 where date (datecreated) BETWEEN <> AND <> ORDER BY biblio.datecreated desc Changing 'items.biblionumber to items.biblionumber as Biblionr' removes the button. Also tested it in version 20.11 with the same results. --=20 You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============0961909326875182491==-- From bugzilla-daemon@bugs.koha-community.org Mon Aug 15 19:13:00 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Mon, 15 Aug 2022 17:12:59 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6028295894135105193==" --===============6028295894135105193== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3D31361 Katrin Fischer changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff --- Comment #1 from Katrin Fischer --- You need to use a special syntax if you want to rename the column while keepi= ng the batch functionality.=20 This will work: [[items.biblionumber|Titelsatznummer]] --=20 You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. --===============6028295894135105193==-- From bugzilla-daemon@bugs.koha-community.org Mon Aug 15 19:13:22 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Mon, 15 Aug 2022 17:13:09 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============8864901186208261765==" --===============8864901186208261765== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Katrin Fischer changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============8864901186208261765==-- From bugzilla-daemon@bugs.koha-community.org Mon Aug 15 19:13:32 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Mon, 15 Aug 2022 17:13:20 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2728723180347699214==" --===============2728723180347699214== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Katrin Fischer changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============2728723180347699214==-- From bugzilla-daemon@bugs.koha-community.org Mon Aug 15 19:13:42 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Mon, 15 Aug 2022 17:13:36 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4861113708140840290==" --===============4861113708140840290== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Katrin Fischer changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to oldoldstable -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============4861113708140840290==-- From bugzilla-daemon@bugs.koha-community.org Mon Aug 15 19:13:52 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Mon, 15 Aug 2022 17:13:43 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5887030911251144010==" --===============5887030911251144010== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Katrin Fischer changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to oldoldstable |Needs documenting -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============5887030911251144010==-- From bugzilla-daemon@bugs.koha-community.org Mon Aug 15 19:14:23 2022 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Mon, 15 Aug 2022 17:14:22 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3221855536989342273==" --===============3221855536989342273== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Katrin Fischer changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |enhancement -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============3221855536989342273==-- From bugzilla-daemon@bugs.koha-community.org Fri May 12 17:03:31 2023 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Fri, 12 May 2023 15:03:15 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5053625493951605653==" --===============5053625493951605653== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Aude Charillon changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |aude.charillon@ptfs-europe. | |com Documentation| |Aude Charillon contact| | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. --===============5053625493951605653==-- From bugzilla-daemon@bugs.koha-community.org Thu Dec 7 00:01:10 2023 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Wed, 06 Dec 2023 23:01:09 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1876215207761028451==" --===============1876215207761028451== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Benjamin Daeuber changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bdaeuber@cityoffargo.com --- Comment #2 from Benjamin Daeuber --- I've created a merge request to add this to the manual here: https://gitlab.com/koha-community/koha-manual/-/merge_requests/767 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============1876215207761028451==-- From bugzilla-daemon@bugs.koha-community.org Thu Dec 7 14:56:43 2023 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Thu, 07 Dec 2023 13:56:42 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6574043862045271313==" --===============6574043862045271313== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Aude Charillon changed: What |Removed |Added ---------------------------------------------------------------------------- Documentation| |https://gitlab.com/koha-com submission| |munity/koha-manual/-/merge_ | |requests/767 Documentation|Aude Charillon |Benjamin Daeuber contact| | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============6574043862045271313==-- From bugzilla-daemon@bugs.koha-community.org Thu Dec 7 17:38:53 2023 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 31361] Button batch operations disappears when alias is used for itemnumber of biblionumber Date: Thu, 07 Dec 2023 16:38:52 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1678239497435474064==" --===============1678239497435474064== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31361 Benjamin Daeuber changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|Needs documenting |RESOLVED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. --===============1678239497435474064==--