[Koha] Bulk items modification

[muiru james]

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