Show attribute value in grid

Hii ​@bihalivan15,

If you're working with an attribute value stored through a selector/multi-selector and want the grid to behave the same way as the Attributes tab, you'll need to retrieve both the ValueID and the corresponding Description from CSAttributeDetail.

The standard approach is:

• Join CSAnswers to CSAttributeDetail using AttributeID and ValueID.
• Display CSAttributeDetail.Description when it contains a value.
• Fall back to CSAttributeDetail.ValueID when the description is null or empty.

Conceptually, the logic is:

string displayValue =
    string.IsNullOrEmpty(attributeDetail?.Description)
        ? attributeDetail?.ValueID
        : attributeDetail.Description;

This mirrors the behavior of the Attributes tab in Acumatica:

• Description exists → show Description
• Description is blank → show ValueID

For a grid column, the cleanest implementation is usually to expose an unbound DAC field and populate it in a FieldSelecting event (or a projection/query field), so users see the friendly text while the underlying attribute value remains unchanged.