QueryBuildRange的各种条件的总结

关注

原创最新推荐文章于 2026-07-21 21:47:24 发布 1.4k 阅读 AI 写同款· GEO 优化 ›

[ElasticSearch系列六] 使用QueryBuilders、NativeSearchQuery实现es数据库对列表的各种操作{多条件,分页,排序,高亮显示(附高亮工具类)等} ElasticsearchTemplate封装ES客户端的一些原生api模板，方便实现一些查询,QueryBuilders是ES中的查询条件构造器,NativeSearchQuery 原生的查询条件类，用来和ES的一些原生查询方法进行搭配，实现一些比较复杂的查询,最终进行构建.build可作为ElasticsearchTemplate. queryForPage的参数使用阅读详情

query = new Query();
qbds = query.addDataSource(tableNum(InventTable));
qbr = qbds.addRange(fieldNum(InventTable, DataAreaId));

1. 等于

qbr.value("Item1")

qbr.value(strFmt('(ItemId == "%1")', queryValue("Item1")));

2.or

qbr.value(strFmt('((ItemType == %1) || (ItemId == "%2"))', any2int(ItemType::Service), queryValue("Item1")));

3. 各种比较

qbr.value(strFmt('(ModifiedDate > %1)', "2015/01/10"));

4.各种组合

qbr.value(strFmt('((%1 == %2) || ((%1 == %3) && (%4 == "%5")))',fieldStr(InventTable, ItemType),any2int(ItemType::Service),any2int(ItemType::Item),fieldStr(InventTable, ProjCategoryId),queryValue("Spares")));

5.Multiple Enum values

qbr.value(strfmt("%1,%2", enum2str(InventTransType::TransferOrderReceive), enum2str(InventTransType::purch))));

qbr.value(enum2str(InventTransType::TransferOrderReceive), enum2str(InventTransType::purch));

6.IN

QueryBuildDataSource qbds = q.dataSourceTable(BOMTable);
QueryBuildRange qbr;
while (...)
{
    qbr = qbds.addRange(fieldNum(BOMTable, BOMId));
    qbr.value(queryValue(BOMVersion.BOMId));
}

QueryBuildRange qbr = q.dataSourceTable(BOMTable).addRange(fieldNum(BOMTable, BOMId));
container c;
while (...)
{
    c+= queryValue(BOMVersion.BOMId);
}
qbr.value(con2str(c));

7. Like

SysQuery::findOrCreateRange(ProjTable_ds.query().dataSourceTable(tableNum(projTable)),fieldNum(projTable, projId)).value(queryValue(SysQuery::ValueLikeAfter(ProjTable.parentId)));

ValueLike ＝　*AA* ValueLikeAfter = A*

8. Not Like　

qbr.value(strFmt("%1,%2",strFmt('!%1*','1'),strFmt('!%1*','2')));

== where (!(CustGroup.CustGroup like '1*') && !(CustGroup.CustGroup like '2*'))

9. 终极方案

http://nathalie.gimenez.free.fr/DynamicsAX/DynamicsProg_queryrange.html#String

收录于