Dynamics Community Forum Thread Details

Using Product Attribute Value in SysLookupMultiSelectGrid

Hi. I'm building a Multi-select lookup filtering for a SSRS Report. The report needs filtering by Product Type values, where "Product Type" is an item Attibute. So I need to fill the multi-select lookup with Product Type Attribute Values.

The thing is, I only need the Product Type values to fill in the lookup list.

I understand from here is the best way to get attribute values. Method below is my approach to fill the multi-select lookup:

private void itemProductTypeLookup(FormStringControl _control)
{
AttributeValueText attributeValueText;
EcoResProductAttributeValue ecoResProductAttributeValue;
InventTable inventTable;
EcoResAttribute ecoResAttribute;
EcoResValue ecoResValue;
Query query;
container conItemProductType;

while select ecoResProductAttributeValue
where ecoResProductAttributeValue.Product == inventTable.Product
join Name from ecoResAttribute
where ecoResAttribute.Name == "Product Type" && ecoResAttribute.RecId == ecoResProductAttributeValue.Attribute
join ecoResValue
where ecoResValue.RecId == ecoResProductAttributeValue.Value
{
attributeValueText = ecoResValue.value();
}

msCtrlProductType = SysLookupMultiSelectGrid::construct(_control, _control);

msCtrlProductType.run();
}

How can I insert the attributeValueText values into the lookup grid? The normal approach would be using msCtrlProductType.parmQuery() method but EcoResProductAttributeValue is invisible in AOT and cannot be used in a regular query.

Thank You.

Quick Links