Share
ReportHere is an example code of how to join InventTable with their Attribute Tables,
InventTable inventTable;
EcoResProduct ecoResProduct;
EcoResValue ecoResValue;
EcoResAttributeValue ecoResAttributeValue;
EcoResAttribute ecoResAttribute;
EcoResInstanceValue ecoResInstanceValue;
EcoResAttributeType ecoResAttributeType;
EcoResProductInstanceValue ecoResProductInstanceValue;
int i = 0;
;
while select ecoResAttributeValue
join ecoResAttribute
where ecoResAttributeValue.Attribute == ecoResAttribute.RecId
join ecoResAttributeType
where ecoResAttribute.AttributeType == ecoResAttributeType.RecId
join ecoResInstanceValue
where ecoResAttributeValue.InstanceValue == ecoResInstanceValue.RecId
join ecoResValue
where ecoResAttributevalue.Value == ecoResValue.RecId
join ecoResProductInstanceValue
where ecoResInstanceValue.RecId == ecoResProductInstanceValue.RecId
join ecoResProduct
where ecoResProduct.RecId == ecoResProductInstanceValue.Product
join inventTable
where inventTable.Product == ecoResProduct.RecId
{
info(strFmt("%1 %2",ecoresproduct.DisplayProductNumber,ecoResAttribute.Name));
}
*This post is locked for comments
All responses (
306,118
