Hello @vsr1 / Guys
I have 1000+ existing documents in bucket A. I need to update tenantId and clientId for all the existing documents where these two fields are missing.
We need to update for only documents where these 2 fields are MISSING.
I have bucket B with the following data
We need to get data from bucket B and then update bucket A documents.
This below query is only for tenantId and I am not checking missing condition.
SET a.tenantId = FIRST v.tenantId
FOR v IN (
WHERE META().id=“tenant:scom”) END
WHERE a.type=“pagedef” RETURNING *
What would be the best/correct way to do these changes?