Hi,
I'm trying to figure out how to perform a query on a database (Appery DB) that will simply return the number of records that would be returned.
I don't want to perform the query and get the data (as it could be large) as I'm only interested in the number that would be returned.
The mongoDB documentation says:
db.collection.count(query, options)
But I don't know how to convert that into the correct server code lines?
thanks.
Hello Andy,
You can use the following Database Collections API method:
query(dbId, collectionName[, params][, token])
["count":, ] - boolean - parameter indicating whether the number of selected objects should be included in response
Hello Andy,
try this one in SC,
code
var responseBody = {};
var requestParams = {};
var paramKeys = request.keys()
for (var key = 0; key < paramKeys.length; key++) {
requestParams[paramKeys[key]] = request.get(paramKeys[key]);
}
// Declare database ID and Master key
var dbId = "db_id"
var collection = requestParams['collection_name'];
var where = requestParams['where'];
try {
var XHRResponse = XHR.send("GET", "https://api.appery.io/rest/1/db/collections/" + "db_products", {
"headers": {
"X-Appery-Database-Id": dbId//,
//"X-Appery-Master-Key": masterKey
},
"parameters": {
"where": where,
"count": "1"
}
});
responseBody.count = XHRResponse.body[0].count;
response.success(responseBody, "application/json");
} catch (e) {
response.success("message: " + e.message + "\ncode: " + e.code);
}
/code
thanks for this great help!
This is all about speed, I want the query returning the count to be as fast as possible, hence not returning data.
Can you confirm the above does not return queried data, just the count?
yeah its return only count u can try it 
great, thanks for this - working a treat !