[RockWell FTPC]对象介绍_Filter

熏悟空的发果山

已于 2022-10-19 14:20:35 修改

阅读量323

点赞数 1

分类专栏： RockWell FTPC对象介绍文章标签： java

于 2022-10-19 14:06:08 首次发布

本文链接：https://blog.csdn.net/weixin_46214043/article/details/127406864

版权

RockWell FTPC对象介绍专栏收录该内容

5 篇文章 2 订阅

订阅专栏

ATRowFilter

import("com.datasweep.plantops.common.constants.filtering.IATRowFilterAttributes")
import("com.datasweep.plantops.common.constants.filtering.IFilterSortOrders")

//模板-AT表
filter = createATRowFilter("OM_ExceptionEntry")
filter.forColumnNameEqualTo("serial_number","YZL2224041500005")
filter.addOrderBy(IATRowFilterAttributes::CREATIONTIME, IFilterSortOrders::DESCENDING)
// vec = filter.exec()
vec = getFilteredATRows(filter,false)


//根据atr_key过滤
forATRowKeyEqualTo(long value)

//根据列值过滤
forColumnNameEqualTo(java.lang.String columnName, java.lang.Object value)
forColumnNameNotEqualTo(java.lang.String columnName, java.lang.Object value)
forColumnNameGreaterThan(java.lang.String columnName, java.lang.Object value)
forColumnNameLessThanOrEqualTo(java.lang.String columnName, java.lang.Object value)
forColumnNameStartingWith(java.lang.String columnName, java.lang.String value)
forColumnNameContaining(java.lang.String columnName, java.lang.String value)

//跟据创建时间过滤
forCreatedTimeLessThan(Time time)
forCreatedTimeGreaterThanOrEqualTo(Time time)

//按创建时间排序
filter.addOrderBy(IATRowFilterAttributes::CREATIONTIME, IFilterSortOrders::DESCENDING)

// in 查询字段在某个范围内
array = [1,2,6]
list =  class java.util.Arrays::asList(array)
filter.addSearchBy("state", IATRowFilterAttributes::ATCOLUMN, IFilterComparisonOperators::IN, list)

系统对象Filter

//过滤设备
filter = createEquipmentFilter()
filter.forNameContaining("QP")
vec = filter.exec()

//过滤产线
fltrArea = createAreaFilter()
fltrArea.forNameEqualWith("XXQP01")
fltrProductionLine = createProductionLineFilter()
fltrProductionLine.forParentAreasIn(fltrArea)
vec = fltrProductionLine.exec()