• Sign In
×
The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!

Deleting and updating dataset data

Study Forum (Inactive)

View Message

view list print
Deleting and updating dataset data michael_stover  2010-12-09 05:40
Status: Closed
 
I am using labkey version 10.2.

One problem I am having is with deleting a row in a study dataset. Whenever I try, I get a NullPointerException:

java.lang.NullPointerException
       at org.labkey.study.controllers.StudyController$DeleteDatasetRowsAction.handlePost(StudyController.java:2393)
       at org.labkey.study.controllers.StudyController$DeleteDatasetRowsAction.handlePost(StudyController.java:2360)
       at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:91)
       at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:75)
       at org.labkey.api.action.BaseViewAction.handleRequestInternal(BaseViewAction.java:167)

The other problem is I don't see any way to update a particular record in a study dataset. If an entry is wrong or missing a value, how do I change it or add a value to a particular column? I suppose one could delete a row and then add it again (if deleting worked), but that is really ugly.

Any help is appreciated.
 
 
jeckels responded:  2010-12-09 09:44
I believe you're hitting a bug that was fixed in version 10.3, which is now available for download. In 10.2 you could get this error if you tried to delete a row, but the dataset wasn't configured to allow for edits through the user interface.

By default, datasets can be uploaded in bulk through a study import or by pasting in a TSV, but you can't edit, delete, or insert individual rows through the UI.

You can turn on editable datasets, which should let you both edit and delete rows:

https://www.labkey.org/wiki/home/Documentation/page.view?name=studySecurity

For starters, I'd recommend switching to use "Basic Security with Editable Datasets".

Thanks,
Josh
 
michael_stover responded:  2010-12-10 05:44
Thanks for the help, Josh! That's what I needed to know.