How to get comments by currentUser since yesterday

hi ,

I am trying to get comments by currentUser() since yesterday by this:

this gives me all the comments in the content not filtered by createdBy = currentUser() but shows comments created by other users as well.

also for start of day, having >startOfDay() does not show any results, while I created a comment for test purpose, having >**=**startOfDay() does show the new comment but along with all other comments before yesterday.

Can someone please help in rectifying the query.

thanks in advance,

Hello @AbhishekBiswas

The keyword used for joining clauses is AND not an ampersand (&).

Refer to the CQL documentation.

Thanks, that works. That was a stupid and rushed question from my side