Database query filter

This forum contains topics that were moved from Get Satisfaction
Mark7294305
Posts: 0
Joined: Fri Dec 26, 2014 2:10 am

Database query filter

Post by 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
Posts: 147
Joined: Tue Aug 27, 2013 1:47 pm

Database query filter

Post by 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

Post Reply