Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
Hi, appery support team!
Is it possible to use $size (Array Aggregation Operator) in order to count and return the total number of items in an array in database? If not, is there any way to accomplish it?
I referenced to the following site.
https://docs.mongodb.org/master/refer...
Hello Makoto,
Sure, it is possiple to use $size:
https://devcenter.appery.io/documenta...
Hello Sergiy,
thank you very much for your help. But, I know $size makes it possible to retrieve elements in an array.
My question is how to use $size in order to “count and return the total number of items in an array in database”.
Thank you.
Hello Makoto,
$size - standard MongoDB operator, it selects documents if the array field is a specified size.
Please find more here http://docs.mongodb.org/manual/refere...
To count total number of records you should you custom code.
This should be useful https://getsatisfaction.com/apperyio/...
Hi Alena,
thank you for your reply. And, I could understand that it is not suitable to use $size operator for counting and returning the total number of items in an array in database when using Appery. I’ll try the method that you explained above. Thanks!