Hi James, please use with care!
UPDATE items SET withdrawn_on = "2020-01-01 12:00:00" WHERE withdrawn > 0; This will update all items with a withdrawn status > 0 (1, and other if you have defined more) to the date specified. If you don't want to update all withdrawn items, you need to change the WHERE part to something that selects the right items for you. Hope this helps, Katrin On 28.11.20 17:56, muiru james wrote:
Hi Katrin I'd like to try it. Is it by updating the items table- n itemlost_on field? You said earlier the datatype is date time. If you can or anyone else, kindly give me a query that would set the date to a date like 1st May 2020. I have access to the terminal. Thanks in advance. James On Sat, Nov 28, 2020, 12:34 Katrin Fischer <[email protected] <mailto:[email protected]>> wrote: Hi James, currently it's not possible to change the date from within Koha. It's automatically set to the date the status was changed to withdrawn. I think it can only be changed with SQL and database access. Katrin On 27.11.20 08:07, muiru james wrote: > Hi, > > I marked some items as withdrawn and need to bulk edit to change the date > of withdrawal to an earlier date so that my report can give me accurate > data. > > How can I change/modify the items.withdrawn_on date with a calendar pop > up/date picker? > > Kindly help > > Warm Regards > James > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] <mailto:[email protected]> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] <mailto:[email protected]> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
