qds.fn_getAttributeTolerances

Description

Returns tolerance limits for a given attribute, resolving by priority.

Syntax

qds.fn_getAttributeTolerances(@attributeId, @assetId, @itemId, @itemClassId, @itemSetId)

Parameters:

@attributeId (int): Attribute Id

@assetId (int): Asset Id

@itemId (int): Item Id

@itemClassId (int): Item class Id

@itemSetId (int): Item set Id

Returns:
Returns a table. Columns include tolerance bands like UEL, LEL, USL, LSL, UCL, LCL, and target.

Code Example

-- Get attribute tolerance limits by resolving precedence rules
SELECT *
FROM qds.fn_getAttributeTolerances(101, 2076, 305, NULL, NULL);