d365technext: Item Attribute

[Blog bot]

Источник: http://d365technext.blogspot.com/201...attribute.html
==============

Item Attribute
Query relation to get Item attributes.

InventTable objinventTable;
EcoResProduct objecoResProduct;
EcoResValue objecoResValue;
EcoResAttributeValue objecoResAttributeValue;
EcoResAttribute objecoResAttribute;
EcoResInstanceValue objecoResInstanceValue;
EcoResAttributeType objecoResAttributeType;
EcoResProductInstanceValue objecoResProductInstanceValue;
int i = 0;
;
while select objecoResAttributeValue
join objecoResAttribute
where objecoResAttributeValue.Attribute == objecoResAttribute.RecId
join objecoResAttributeType
where objecoResAttribute.AttributeType == objecoResAttributeType.RecId
join objecoResInstanceValue
where objecoResAttributeValue.InstanceValue == objecoResInstanceValue.RecId
join objecoResValue
where ecoResAttributevalue.Value == objecoResValue.RecId
join objecoResProductInstanceValue
where objecoResInstanceValue.RecId == objecoResProductInstanceValue.RecId
join objecoResProduct
where objecoResProduct.RecId == objecoResProductInstanceValue.Product
join objinventTable
where objinventTable.Product == objecoResProduct.RecId
&& objinventTable.itemid='D0001'
{
info(strFmt("%1 %2",objecoResProduct.DisplayProductNumber,objecoResAttribute.Name));
}

Источник: http://d365technext.blogspot.com/201...attribute.html