Query Count and Random Result

Question

So this is a two part question. I have a table of say 1000 documents. One element of each document is "visited". Ultimately, what I want to do is pull down 1 random record where visited = false. My oriignal approach was to count how many records have visited == false. However, the findAllCount does not have a query option. Then I would do a random from 0..

 

PS. Trying to avoid using Query Find with paging to get the document count. I dont want it to return 1000's of records just to get a count.

Answer 1

Hi,

As of now, you can only find count of all documents. Let me check with the team for the same, I will get back to you as soon as possible.

Thanks.