是否可以更改此查询以添加 OR?

Question

我不确定如何在谷歌应用制作工具语言中更改此查询

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

所以现在它相当于

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

但是我想知道是否有办法将其更改为等效的

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

也许通过使用query.where？

Answer 1

您可以尝试向查询添加另一个过滤器：

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();