[Koha] Bulk items modification

[Katrin Fischer]

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 <katrin.fischer.83 at web.de
> <mailto:katrin.fischer.83 at web.de>> 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
>     > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>     _______________________________________________
>
>     Koha mailing list http://koha-community.org
>     Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>