Dynamics Community Forum Thread Details

How to find dimension query value in X++

Hi Team,

I am working in SSRS report.

Here in report dialog i have to add filter on Main account, to achieve this i have wrote the below code in controller class prePromptModifyContract().

protected void prePromptModifyContract()
{
 QueryBuildDataSource qbdGeneralJournalAccountEntry;
  Query                query;

   query = this.parmReportContract().parmQueryContracts().lookup(this.getFirstQueryContractKey());

 qbdGeneralJournalAccountEntry = SysQuery::findOrCreateDataSource(query, tableNum(GeneralJournalAccountEntry));
        
        SysQuery::addDimensionAttributeFilter(query,
                                                qbdGeneralJournalAccountEntry.name(),
                                                fieldStr(GeneralJournalAccountEntry, LedgerDimension),
                                                DimensionComponent::DimensionAttribute,
                                                SysQuery::valueEmptyString(),
                                                DimensionAttribute::getWellKnownDimensionAttributeName(DimensionAttributeType::MainAccount));
}

Now i have to get selected Main account value from dialog box in controller class validate method.

Below is the code.

protected boolean validate()
    {
        boolean        isValid = true;
        Query          query;
        QueryBuildRange                    queryBuildRange;
        QueryBuildDataSource               queryBuildDataSource;

        query    = this.getFirstQuery();

        queryBuildDataSource = query.dataSourceTable(tableNum(GeneralJournalAccountEntry));
        queryBuildRange      = queryBuildDataSource.findRange(fieldNum(GeneralJournalAccountEntry, LedgerDimension));
        
       return isValid;
}

In above code queryBuildRange i am not able to get main account value.

Please let me know how to achieve this.

Categories:

Microsoft Dynamics AX

Quick Links

Leaderboard