Redirect Notice

As of April 12th, you must go to Progress SupportLink to create new support cases or to access existing cases. Please, bookmark the SupportLink URL and use the new portal to contact the support team.

You will be automatically redirected to SupportLink in 10 seconds.

How can we help you today?

Start a new topic
Discussions Kinvey Forums Business Logic
Answered

How to use lessThanOrEqualTo in Business Logic?

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

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

3 CommentsSorted by Oldest First
Answer

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

Wow, this is it, thank you Pranav! It works like a charm! Next time I will consider the MongoDB documentation that exactly reflects that.


Regards

Tay

Agreed..It works too good...Thank you so much for the solution 

Login or Signup to post a comment
More topics in Business Logic
See all 342 topics