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

**URL:** <https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611>\
**Category:** Developer Forum\
**Created:** [April 29, 2013, 11:40am UTC](https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611 "2013-04-29T11:40:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![srikanthvuthu](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@srikanthvuthu](https://www.dynamicsuser.net/u/srikanthvuthu)\
**Post date:** [April 29, 2013, 11:40am UTC](https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611/1 "2013-04-29T11:40:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [April 29, 2013, 1:09pm UTC](https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611/2 "2013-04-29T13:09:26Z")

</div>

> [@](#):
>
> another field utr number, but it is not intalizing in the controller class , called via prepromtmodify contract

Can you explain this?

---

<div class="post-metadata">

**Author:** ![srikanthvuthu](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@srikanthvuthu](https://www.dynamicsuser.net/u/srikanthvuthu)\
**Post date:** [April 29, 2013, 3:46pm UTC](https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611/3 "2013-04-29T15:46:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [April 29, 2013, 4:07pm UTC](https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611/4 "2013-04-29T16:07:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![srikanthvuthu](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@srikanthvuthu](https://www.dynamicsuser.net/u/srikanthvuthu)\
**Post date:** [April 29, 2013, 7:00pm UTC](https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611/5 "2013-04-29T19:00:49Z")

</div>

hi kranthi,

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

thanks,

srikanth.

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [April 30, 2013, 2:06pm UTC](https://www.dynamicsuser.net/t/aot-query-range-field-in-not-intalizing-in-ax-2012/45611/6 "2013-04-30T14:06:17Z")

</div>

Use SysQuery::findOrCreateRange