Query failed with error csfle \"analyze_query\" failed: Access to variable ROOT disallowed [Error 2, code 31127]

[Kushagra_Kesav]

Hi @Mehran_Ishanian2,

Welcome to the MongoDB Community

@Mehran_Ishanian2

Note: punches collection is NOT encrypted nor has any encrypted CSLFE,
I have another collection with CSLFE Query encryption fields

Could you please double-check that you are running this query on the encrypted collection? Because looking at the error it seems you are running on the encrypted field.

@Mehran_Ishanian2

at processTicksAndRejections (node:internal/process/task_queues:95:5) {stack: 'MongoCryptError: csfle "analyze_query" failed…ions (node:internal/process/task_queues:95:5)', message: 'csfle "analyze_query" failed: Access to variable ROOT disallowed [Error 2, code 31127]', Symbol(errorLabels): Set(0)}

While executing the above aggregation query {'$group': { _id: '$deviceCode', latestDocument: { '$first': '$$ROOT' } } }, you are receiving the error because the $$ROOT and $$CURENT are both currently unavailable when using field-level encryption. This is because the encrypted field mappings would have the effect of projecting encrypted values into new field paths that are inconsistent with the existing key mappings, due to which you will not be able to decrypt the field in the new document shape.

I hope it helps. Please let us know if you have any additional questions or concerns regarding the above details.

Best regards,
Kushagra