Tables - Change Values for Multiple Rows

LabKey Support Forum
Tables - Change Values for Multiple Rows marcia hon  2018-08-15 08:31
Status: Closed
 

Hello,

I have a dataset/assay/list table.

There are multiple rows.

I would like to change the value for one of the columns for all of the rows.

I know that I can do this on a row-by-row basis using "edit".

However, is it possible to do this at the same time for multiple rows?

Thanks,
Marcia

 
 
Anthony Corbett responded:  2018-08-21 06:51

I don't believe there is support for this in Labkey's native UI. But you can use their API clients to bulk update rows. This post may help: https://www.labkey.org/9e077eeb-b2ab-1029-961c-79704b7a2169/announcements-thread.view?entityId=44844567-b6ca-1032-80ef-e5ac46246e24&_docid=thread%3A44844567-b6ca-1032-80ef-e5ac46246e24

 
Jon (LabKey DevOps) responded:  2018-09-04 20:59
Hi Marcia,

Anthony is correct. Other than using the API, there is nothing else in LabKey that can support a multiple row edit.

Regards,

Jon
 
Jon (LabKey DevOps) responded:  2018-09-05 09:56
Update: I forgot about one possible thing. There is a bulk edit UI option, but it isn't something that can be easily accessed.

This is tied to a query-updateQueryRows.view page to which you could wire up a button in your grid view via XML Metadata to do a bulk selection.

This isn't all that different than the API update, but does require some more experience with using the LABKEY.ActionURL.buildURL function:

https://www.labkey.org/Documentation/wiki-page.view?name=url

 Also, the UI itself will look a little unusual since it will show what appears to be empty fields if information is different between various rows.

Regards,

Jon