system.mes.spc.controllimit.getLimitInfoByFilter(filter)

Sepasoft MES Module Suite

system.mes.spc.getLimitInfoByFilter(filter)

Queries the database for information about limits for a single location.

getLimitInfoByFilter(filter) → Dataset

Syntax

system.mes.spc.getLimitInfoByFilter(filter)

  • Parameters

ControlLimitFilter filter - A ControlLimitFilter object created from system.mes.spc.controllimit.createFilter that is used to define what should be returned.

  • Returns

 A dataset that has information about the limit, including the value and which definition, attribute, limit, product code and time stamp it is associated with.

  • Scopte

All

Code Example

Copy Code
Python
path = 'Enterprise\El Dorado Hills\Packaging Area\Packaging Line 1\Inspection Station 1'
clFilter = system.quality.spc.controllimit.createFilter(path)
 
#Optional filter items
# Get limits after
clFilter.setAfter(system.date.addDays(system.date.now(), -3))

# Get limits before
clFilter.setBefore(system.date.now())

# Get limits for a specific definition by name
clFilter.setDefinitionName('Single Attribute')

# Get limits for a specific attribute by name
clFilter.setAttributeName('Diameter')

# Get limits for a specific limit by name
clFilter.setLimitName('Individual UCL')

# Get limits for a specific product code
clFilter.setProductCode(None)

data = system.mes.spc.controllimit.getLimitInfoByFilter(clFilter)

print data.getColumnNames()
for row in range(data.getRowCount()):
	for col in range(data.getColumnCount()):
		print data.getColumnName(col)
		print data.getValueAt(row,col)
LimitValue
2.3
DefinitionName
Single Attribute
DefinitionUUID
ccb71ac5-511f-4800-a34b-896514b82f52
AttributeName
Diameter
AttributeUUID
b20a8abb-30a9-4298-bd57-da13218c69a7
LimitName
Individual UCL
LimitUUID
93e81c8c-0c07-424c-b909-100bb8690d3c
ProductCode
None
TimeStamp
Mon Mar 13 03:58:46 PDT 2023
LimitValue
2.1
DefinitionName
Single Attribute
DefinitionUUID
ccb71ac5-511f-4800-a34b-896514b82f52
AttributeName
Diameter
AttributeUUID
b20a8abb-30a9-4298-bd57-da13218c69a7
LimitName
Individual UCL
LimitUUID
93e81c8c-0c07-424c-b909-100bb8690d3c
ProductCode
None
TimeStamp
Sun Mar 12 16:58:46 PDT 2023
LimitValue
2.1
DefinitionName
Single Attribute
DefinitionUUID
ccb71ac5-511f-4800-a34b-896514b82f52
AttributeName
Diameter
AttributeUUID
b20a8abb-30a9-4298-bd57-da13218c69a7
LimitName
Individual UCL
LimitUUID
93e81c8c-0c07-424c-b909-100bb8690d3c
ProductCode
None
TimeStamp
Fri Mar 10 16:58:46 PST 2023
>>>

Sepasoft MES Module Suite