Help needed with where clause - retrieve data for logged in user

[Kateryna Grynko]

Hi Louis,

You cannot return one field. Instead, you can remove the fields you don't need from the response.

[Louis Adekoya]

Thanks Katya.

[Louis Adekoya]

Hi Maryna/Katya,

When I try Maryna's query above in Test, with a specific user id, it works great. However when I try to make the user id dynamic by using a local variable in the where clause (as javascript) it doesn't. Here is what I have:

' return {"group": {"$inQuery": {"active": true}}, "member": {"$inQuery": {"_id": "'+value+'"}}}';

I am concerned that the last bit "'+value+'" may be wrong. Is the syntax wrong? When I try to debug I just get incorrect query.

[Louis Adekoya]

Please ignore my question above - I spotted my error.