Attribute Examples
Copy
Where Attribute Suppression Example
For each Where Attribute that needs to be suppressed, you must add a <whereAttribute> node.
The following is an example of a <whereAttribute> node in the ItemAnalysis.Suppressions file:
<whereAttribute>
<template><![CDATA[[Part].id IN (SELECT id FROM [PART] WHERE cost = @Parameter)]]></template>
</whereAttribute> With this node, the following AML sent from a client will successfully pass the validation:
<AML>
<Item action="get" type="Part" where="[Part].id IN (SELECT id FROM [PART] WHERE cost = 5)"/>
</AML> Condition In Attribute Suppression Example
For each Condition In Attribute that needs to be suppressed, you must add a <conditionInProperty> node.
The following is an example of a <conditionInProperty> node in the ItemAnalysis.Suppressions file:
<conditionInProperty>
<template><![CDATA[(SELECT cost FROM [innovator].[PART] WHERE [item_number] IN (@ParametersList))]]></template>
</conditionInProperty> With this node, the following AML sent from a client will successfully pass the validation:
<Item action="get" type="Part">
<cost condition="in">(SELECT cost FROM [innovator].[PART] WHERE [item_number] IN ('A', 'C', 'D'))</cost>
</Item>
Condition Between Attribute Suppression
For each Condition Between Attribute that needs to be suppressed, you must add a <conditionBetweenProperty> node.
The following is an example of a <conditionBetweenProperty> node in the ItemAnalysis.Suppressions file:
<conditionBetweenProperty>
<template><![CDATA[(SELECT cost FROM [innovator].[PART] WHERE [item_number] = @Parameter) and (SELECT cost FROM [innovator].[PART] WHERE [item_number] = @Parameter)]]></template>
</conditionBetweenProperty> With this node, the following AML sent from a client will successfully pass the validation:
<Item action="get" type="Part">
<cost condition="between">(SELECT cost FROM [innovator].[PART] WHERE [item_number] = 'B') and (SELECT cost FROM [innovator].[PART] WHERE [item_number] = 'D')</cost>
</Item>