How to use lessThanOrEqualTo in Business Logic? : Kinvey Customer Support Portal

T

Tayger

started a topic 26 days ago

Hello

I'm running against a wall using lessThanOrEqualTo in Business Logic. I came up to the point that it probably won't work that way (as it does in Javascript API):

var checkDate = 201907241500

logger.info("step 1");

modules.collectionAccess.collection('products').lessThanOrEqualTo(('release.unlockdate', checkDate), function (err, docs) {
   if (err) {
     logger.error('Query failed: '+ err);
  } else {
    logger.info ('durch');
  }
});

It outputs "step 1" and no further error message.

This f.e. works fine but this is only an equal operation:

var checkDate = 201907241500;
modules.collectionAccess.collection('products').find({"release.unlockdate": checkDate}, function (err, publish) {
logger.info(JSON.stringify(publish));
});

I'm looking for the query function that allows me to search for records with a value equal or less than a given value. Is that possible?

The samples you provided in the documentation are all simple. I couldn't find examples with advanced query logic.

Regards

Best Answer

P

Pranav J said 26 days ago

Hello Tayger,

Please check the following code snippet which shows how to use "Less Than or Equal to" operator:

function onRequest(request, response, modules) {
  var logger = modules.logger;
  
  modules.collectionAccess.collection('Book').find({"startDate": {"$lte": "2018-11-02T11:29:44.211Z"}}, function (err, docs) {
  if (err) {
    logger.error('Query failed: '+ err);
  } else {
    logger.info('Found records are ' + JSON.stringify(docs));
    logger.info('Number of records is ' + docs.length);
    response.body = docs;
    response.complete(200);
  }
});
  
}

Thanks,

Pranav

Kinvey

P

Pranav J

said 26 days ago

Answer