Query Not Working properly please help

(0) Share

Report

Posted on by Sachin Mittal

i have made this query and add default dimension range to bankvaccounttable but in dialog form even i dont select any business unit , it showing data only in bank account if business unit is added

query buildQuery()
    {
       
        QueryBuildDataSource	qbdsBankAccountTable, qbdsBankAccountTrans,qbdsDefaultDimensionView;//qbdsDimensionAttributeValueSet,qbdsDimensionAttributeValueSetItem,qbdsDimensionAttributeValue,qbdsDimensionAttribute;
        Query query				= new Query(queryStr(OABCashBook));
        qbdsBankAccountTable    = query.dataSourceTable(tableNum(BankAccountTable));
        qbdsBankAccountTrans	= query.dataSourceTable(tableNum(BankAccountTrans));
        qbdsDefaultDimensionView = query.dataSourceTable(tableNum(DefaultDimensionView));
        
        
        qbdsBankaccountTrans.addRange(fieldNum(BankAccountTrans, TransDate)).value(queryRange(fromDate, toDate));
    qbdsDefaultDimensionView.addRange(fieldNum(DefaultDimensionView, Name)).value('BusinessUnit');

All responses (1)

Answers (0)

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Sachin, That would be because you have added range on Business Unit. Please move business unit range in a if condition. If there is value in business unit from dialog then only range should apply.