AOT query range field in not intalizing in ax 2012 ??

Finance and Operations/AX Developer Forum
1

hi all,

i had added range in standarad aot query , it is having two ranges like bank account number , check number ,i had added

another field utr number, but it is not intalizing in the controller class , called via prepromtmodify contract ,

can any body tell wht is wrong here

thanks

srikath

2

Can you explain this?

3

hi kranthi,

i want to add a field in the payment advise report in cash and bank mangement module

in this a query is there BankPaymAdviceCheque (aot quey) and i adding the filed in the query called utr number i am running the report , controller is there BankPaymAdviceChequeController

QueryBuildDataSource qbds;

Query reportQuery;

QueryBuildRange bankAccountQueryRange;

QueryBuildRange chequeNumQueryRange;

//Query = BankPaymAdviceCheque

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

//User can pick specific bank account and cheque from dialog to create payment advice.

if (paymentIntegration == false)

{

qbds = query.dataSourceTable(tableNum(BankPaymAdviceChequeTmp));

bankAccountQueryRange = qbds.findRange(fieldNum(BankPaymAdviceChequeTmp, BankAccount));

chequeNumQueryRange = qbds.findRange(fieldNum(BankPaymAdviceChequeTmp, ChequeNum));

here i am adding my field to inatlize the friom the aot query

utrnumberrange = qbds.findRange(fieldNum(BankPaymAdviceChequeTmp, utrnumber));

but here it is not intalizationg it is givng the null value

utrnumberrange (null value) so that i am not able get the record and filter based on it .

}

//Query = BankCheque

this.parmReportContract().parmQueryContracts().insert(queryKeyStr,this.initQuery(vendOutPaymCheque, custOutPaymCheque));

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

//Apply user choices from BankPaymAdviceCheque query to BankCheque query

if (paymentIntegration == false)

{

if (bankAccountQueryRange && bankAccountQueryRange.value())

{

SrsReportHelper::addParameterValueRangeToQuery(

query,

tableNum(BankChequeTable),

fieldNum(BankChequeTable,AccountID),

bankAccountQueryRange.value());

}

if (chequeNumQueryRange && chequeNumQueryRange.value())

{

SrsReportHelper::addParameterValueRangeToQuery(

query,

tableNum(BankChequeTable),

fieldNum(BankChequeTable,ChequeNum),

chequeNumQueryRange.value());

}

}

this.processReport(query);

please help me

thanks

srikanth

4

Try by restarting the AOS (or) clear elements cache from Tools → Caches → Refresh Elements.

5

hi kranthi,

i did aos restart still i face the same problem , please help me out .

thanks,

srikanth.

6

Use SysQuery::findOrCreateRange