Dimension attribute value selected in query prompt

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?

  • 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)
  • In reply to Kranthi:

    Abhinay
    I run the custageingreport query, add a filter for "dimension.department"

    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

     

Related
Recommended