Dimension attribute value selected in query prompt

Finance and Operations/AX Developer Forum
1

Hi all,

I run the custageingreport query, add a filter for “dimension.department” then I am trying to access value selected in a query’s prompt (eg. CustAgeingReport query). I have written the following code but it is returning as null/ empty.

    Query q = new Query(queryStr(CustAgingReport));
    QueryRun qRun;
    container conQr;
    ;
    qRun = new QueryRun(q);
    qRun.prompt();
    conQr = SysQuery::
                getDimensionAttributeValueFromQueryRun(
                    qRun,
                    q.dataSourceTable(tableNum(CustTable)).name(),
                    'DefaultDimension',
                    DimensionComponent::DimensionAttribute,
                    'Channel');

What am I doing wrong here?

2

Have you re-named the department to channel?
Are there any records in custTable with selected dimension values? I think deep inside that method it looks for that.
Try debugging into that method (getDimensionAttributeValueFromQueryRun)

3

Hi Kranthi,

Thank you for your reply, it was my bad. It was not department but channel.

Anyway, I got the answer for having it not working. Anyone who is looking for an answer can refer: Dimension attribute value selected in query prompt