Collection Query

[sagar....@flowian.com]

Hello Team,

In Freemarker-
I am using aggregation to fetch result from the collection. But since the result size is more than 1000 records my query will be able to fetch only 1000 records.
Is there any option to get all the data like in list objects function we can specify the first and the size of the set.

I have also tried using the list_object() function. But the problem with list object is that it fetches the whole document which will cause the object oversized. Can we apply project in the list_object(). If yes then how..?

Please could you help me in this.

Thanks

Regards,
Sagar

[Murali]

Hi Sagar,

Please describe more on your requirement.

-Type of data/document/object stored
-Approx size of the object
-Code tried,Error occurred for the object oversize when you tested locally.

Also clarify about "Can we apply project in the list_object()" to suggest further on it.

Regards,
Murali
Fujitsu RunMyProcess Support

[Richard Manga]

Hi Sagar.
you have $skip and $limit commands that allow you to do it.
Skip command is the starting index. Limit is the last index.
Regards,
Richard

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/1de9d8b1-ebaa-417b-b185-b7988a1dca04%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[sagar....@flowian.com]

Hey Thank you Richard.

Regards,
Sagar