projection not working if _id field is excluded
Hi Support team,
I am trying to use proj={"field":1,"_id":0} in my Collection.query() call in server code. But it throws error:
----------------------Error code SCSE014: Script execution failed. Details have been added to Trace tab.
Script sendRequest: Error ( @ 37 : 18 ) - throw e;
However , if I remove "id":0, the query works fine.
Aparently, it doesn't allow specifying "id":0 in projection. This is different from how MongoDB works. Is this a bug or there is specific reason appery wants it to work this way?
Thanks & Regards
Dongzhi