QueryBuildRange

“交” 条件查询

 

不同字段

 精确

queryExpression = '(InventTable.ItemName == "座") && (InventTable.ItemGroupID == "10")';
qbds.addRange(fieldnum(InventTable, ItemId)).value(queryExpression);

 

 模糊

queryExpression = '(InventTable.ItemGroupID == "10")';
qbds.addRange(fieldnum(InventTable, ItemId)).value(queryExpression);
qbds.addRange(fieldnum(InventTable, ItemName)).value("*座*");

 

相同字段

qbds.addRange(fieldnum(InventTable, ItemName)).value("c*001");

 

ItemId like 'c*'   and itemid like '*001'

 

“并”条件查询

不同字段

精确

    queryExpression = '(InventTable.ItemGroupID == "20") ||(ItemName == "座")';
    qbds.addRange(fieldnum(InventTable, ItemId)).value(queryExpression);

模糊

    可能没有直接的办法实现

 

相同字段

精确

    queryExpression = '20,10';
    qbds.addRange(fieldnum(InventTable, ItemGroupId)).value(queryExpression);

模糊

    queryExpression = '*座,00*';
    qbds.addRange(fieldnum(InventTable, ItemId)).value(queryExpression);