Editable Queries

LabKey Support Forum
Editable Queries marcia hon  2019-01-03 09:18
Status: Closed
 

Hello,

Is it possible to create queries whose values are editable?

Thanks,
Marcia

 
 
Jon (LabKey DevOps) responded:  2019-01-17 16:54
Hi Marcia,

I'm not sure I'm understanding your question.

SQL Queries created in the Schema Browser are only editable by those with Administrator access for that particular container the query resides.

If you are speaking about trying to create a query that is based on a table or a few different tables via a JOIN or UNION and having those results be editable, that isn't possible in LabKey since there is no way to identify where specific data is originating from and the data itself can be manipulated from within the query.

Regards,

Jon