Database query filter

[Mark7294305]

Hello Support
I have created a database where user can add items. I want to create a query where only user that have created more than 50 items will be displayed in the results. So for example if John has created 56 items, Paul has created 66 items and Brian has created 34 items, I only want John and Paul to appear in the query results.

How can I do this?

[Serhii Kulibaba]

Hello Mark,

Please count database rows amout before each query service: https://docs.appery.io/reference#data...
if it is more than 50 - do a query.

Another case is: write an amount of items into the collection "Users" after each call of create/delete service and check that value before run query service