system.mes.spc.controllimit.getLimitInfo

system.mes.spc.controllimit.getLimitInfo(controlLimitFilter)

Query information about set control limit values with associated timestamp, limit, definition, and attribute.

Returns a dataset of limit values, dates, and information on the associated definition, attribute, and product code.

Commonly Used To:

• Select an attribute and product and show a history of when control limits changed.
• Return a dataset/list of all control limits with timestamps and not just a specific value.

Syntax

system.mes.spc.controllimit.getLimitInfo(controlLimitFilter)

• Parameters

controlLimitFilter: A ControlLimitFilter object created from system.quality.spc.controllimit.createFilter that is used to filter what is returned.

• Returns:
  • A dataset with the following columns:
    • LimitValue
    • DefinitionName
    • DefinitionUUID
    • AttributeName
    • AttributeUUID
    • LimitName
    • LimitUUID
    • ProductCode
    • TimeStamp

• Scope

All

Code Example

path = 'New Enterprise\New Site\New Area\New Line\New Location'
clFilter = system.mes.spc.controllimit.createFilter(path)
dataset = system.mes.spc.controllimit.getLimitInfo(clFilter)
sep = ",\t"
print sep.join(dataset.getColumnNames())
for row in range(dataset.getRowCount()):
	rowData = []
	for col in range(dataset.getColumnCount()):
		rowData.append(str(dataset.getValueAt(row, col)))
	print sep.join(rowData)

Output

LimitValue,	DefinitionName,	DefinitionUUID,	AttributeName,	AttributeUUID,	LimitName,	LimitUUID,	ProductCode,	TimeStamp
0.0,	New3,	e4f8f9bd-d415-4814-9f6a-facbc9f6b4fa,	Width,	bc129775-08d8-41f4-b873-c716d1f9bd80,	Individual LCL,	ddb8f56f-589f-4167-a62c-23793d8705ed,	None,	Fri May 28 10:40:59 PDT 2021 

system.mes.spc.getLimitInfo(locationPath, [definitionName], [attributeName], [limitName], [productCode], [after], [before])

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

Syntax

system.mes.spc.getLimitInfo(locationPath, [definitionName], [attributeName], [limitName], [productCode], [after], [before])

• Parameters

String locationPath - The path of the location that the limit values are being queried.

String definitionName - The definition name to get limits for. If it is not included limits for all definitions are returned.

String attributeName - Optional -= The attribute name to get limits for. If it is not included limits for all attributes are returned.

String productCode - Optional - The product code to get limits for. If it is not included limits for all product codes are returned.

Date after - Optional - Get limits that are in effect after this date.

Date before - Optional - Get limits that are in effect before this date.

• Returns

Dataset - Limit data matching input criteria

Getting Limit Info

Release Candidate: 3.81.4 RC6 and later. Stable Version: 3.81.5 and later.

Copy Code Python

path = 'New Enterprise\New Site\New Area\New Line\New Location' clFilter = system.mes.spc.controllimit.createFilter(path) dataset = system.mes.spc.controllimit.getLimitInfo(clFilter) sep = ",\t" print sep.join(dataset.getColumnNames()) for row in range(dataset.getRowCount()): rowData = [] for col in range(dataset.getColumnCount()): rowData.append(str(dataset.getValueAt(row, col))) print sep.join(rowData)

Output

Copy Code Python

LimitValue, DefinitionName, DefinitionUUID, AttributeName, AttributeUUID, LimitName, LimitUUID, ProductCode, TimeStamp 0.0, New3, e4f8f9bd-d415-4814-9f6a-facbc9f6b4fa, Width, bc129775-08d8-41f4-b873-c716d1f9bd80, Individual LCL, ddb8f56f-589f-4167-a62c-23793d8705ed, None, Fri May 28 10:40:59 PDT 2021

Code Snippet

Copy Code Python

defName = 'Single Attribute' definition = system.mes.spc.definition.getSampleDefinition(defName) locationPath = 'Enterprise\\El Dorado Hills\\Packaging Area\\Packaging Line 1\\Inspection Station 1' attributeName = 'Diameter' limitName = 'Individual UCL' ds = system.mes.spc.controllimit.getLimitInfo(locationPath, defName, attributeName, limitName) for row in range(ds.getRowCount()): for col in range(ds.getColumnCount()): print ds.getColumnName(col),':',ds.getValueAt(row,col)

>>> 
LimitValue : 7.51587757576
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 Jan 02 00:01:05 PST 2023
>>>