https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26693 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |In Discussion --- Comment #9 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Ok, I implemented this all: - Syspref - Checkboxes per item, set by default using the syspref - Tweaked finishreceive.pl so it reads the checkboxes and updates dateaccessioned when required. Coool. BUT disabling the date didn't work. So I tried without any patches: MariaDB [koha_kohadev]> SELECT items.itemnumber, dateaccessioned FROM items WHERE itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN (SELECT ordernumber FROM aqorders WHERE basketno=1)); +------------+-----------------+ | itemnumber | dateaccessioned | +------------+-----------------+ | 973 | 2021-02-11 | | 974 | 2021-02-11 | +------------+-----------------+ 2 rows in set (0.00 sec) MariaDB [koha_kohadev]> UPDATE items SET dateaccessioned='2021-02-09' WHERE itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN (SELECT ordernumber FROM aqorders WHERE basketno=1)); Query OK, 10 rows affected (0.01 sec) Rows matched: 10 Changed: 10 Warnings: 0 MariaDB [koha_kohadev]> SELECT items.itemnumber, dateaccessioned FROM items WHERE itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN (SELECT ordernumber FROM aqorders WHERE basketno=1)); +------------+-----------------+ | itemnumber | dateaccessioned | +------------+-----------------+ | 973 | 2021-02-09 | | 974 | 2021-02-09 | +------------+-----------------+ 2 rows in set (0.00 sec) MariaDB [koha_kohadev]> SELECT items.itemnumber, dateaccessioned FROM items WHERE itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN (SELECT ordernumber FROM aqorders WHERE basketno=1)); +------------+-----------------+ | itemnumber | dateaccessioned | +------------+-----------------+ | 973 | 2021-02-11 | | 974 | 2021-02-11 | +------------+-----------------+ 2 rows in set (0.00 sec) BUMMER. So the actual behavior is that dateaccessioned gets updated regardless. I will upload my patches here anyway, just in case this behavior I found is incorrect and gets fixed on another bug report, and then we come back to this! -- You are receiving this mail because: You are watching all bug changes.