update fields in nested documents using SQL syntax

[sanjeevbaral]

Hi When I tried to update a field in the outermost document, the following SQL worked for me.

UPDATE patients SET nameFirst = UPPER(nameFirst) where $.Tumors[*].grade ALL = '1'

However, when I tried to update a field in nested documents this is not working. What is the correct syntax?

UPDATE patients SET Tumors[*].grade = 'x' where $.Tumors[*].grade ALL = '1'

sanjeevbaral commented 4 years ago

If this is not possible through the UPDATE statement, I could first find documents to update, then update tumors associated with each patient document with C# code. I would have loved to have SQL like syntax, however, because I wanted power users to be able to write SQL like syntax themselves to update data.

• © Githubissues.
• Githubissues is a development platform for aggregating issues.

[sanjeevbaral]

If this is not possible through the UPDATE statement, I could first find documents to update, then update tumors associated with each patient document with C# code. I would have loved to have SQL like syntax, however, because I wanted power users to be able to write SQL like syntax themselves to update data.