Can this query be changed to add an or?

Question

I'm not sure how to change this query in google app maker language

 var query = app.models.folders.newQuery();
  query.filters.requestId._equals = request;
  query.filters.filecount._equals = null;
  var total = 0;
  var recx = query.run(); 

So right now it is the equivalent of

select * from folders 
where requestID = request
and filecount = null

But I would like to know if there is a way to change it to the equivalent of

select * from folders 
where requestID = request
and (filecount = null or filecount < 0)

Maybe by using query.where?

Answer 1

You could try by just adding another filter to your query:

var query = app.models.folders.newQuery();
query.filters.requestId._equals = request;
query.filters.filecount._equals = null;
query.filters.filecount._lessThan = 0;
var total = 0;
var recx = query.run();