Queries showing different results

(0) Share

Report

Posted on by Community Member

4300.forum.PNG

I have created a 2 same queries using AOT and through x++ but I am getting different results for the queries

This is my X++ query

static void Check2(Args _args)
{
QueryRun queryRun;
CustInvoiceJour custInvoiceJour;

Query q;
QueryBuildDataSource qbd;
QueryBuildRange qbr;

q = new Query();
qbd = q.addDataSource(TableNum(CustInvoiceJour));
qbr = qbd.addRange(FieldNum(CustInvoiceJour, InvoiceAccount));
qbd.firstOnly(true);
qbr.value('100002');
info(q.toString());
queryRun = new QueryRun(q);
while (queryRun.next())
{
custInvoiceJour = queryRun.get(tableNum(CustInvoiceJour));
info(strFmt("%1",custInvoiceJour.InvoiceAmount));
}
pause;
}

This is my AOT query

static void check(Args _args)
{
QueryRun queryRun;

CustInvoiceJour custInvoiceJour;
;
Query query;
QueryBuildDataSource qbd;
query = new Query(queryStr(PreInvoiceAmount));
query.dataSourceTable(tableNum(custInvoiceJour))
.addRange(FieldNum(CustInvoiceJour,InvoiceAccount)).value('100002');
info(query.toString());
queryRun = new QueryRun(queryStr(PreInvoiceAmount));

while (queryRun.next())
{
custInvoiceJour = queryRun.get(tableNum(CustInvoiceJour));
info(strFmt("%1",custInvoiceJour.InvoiceAmount));
}
pause;
}

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report

Hi AX@beginner!

It's because of this string in check() job:

queryRun = new QueryRun(queryStr(PreInvoiceAmount));

It should be:

queryRun = new QueryRun(query);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Rustem

Thank you for the solution

Now

I have assign this query to a Infopart and I am adding the range for the query in the salestable form

but the value is coming without taking the range

I have written the below lines of code in SalesTable initmethod() but the query is executing without range

//preInvoiceAmount
query = new Query(queryStr(PreInvoiceAmount));
query.dataSourceTable(tableNum(custInvoiceJour))
.addRange(FieldNum(CustInvoiceJour,InvoiceAccount)).value('100002');
info(query.toString());
queryRun = new QueryRun(query);

I was suppose to get the below value after adding the range

I was

Can you please help me ?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

It's not possible to say without seeing all your code, but it seems that the query that you create in "initmethod" (do you mean "init" method?) has nothing to do with the query of the infopart. Basically you are creating a new query but how would the infopart know that you want it to use it?

You have to find where the infopart query is initialized and write your code there so that you add your range to the actual infopart query.

So you should not create a new query, instead add your range to the existing query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is the infopart i created and I had assign the query with my query

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Yes but you are not assigning your range to the query object that the infopart is using.

You are creating a new query object in your code (based on the same AOT query) and adding your range to it. But your info part is not using that query object. At least it looks like that based on the incomplete code that you are sharing.

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

Hi!

Sales order has already information which you try to add about lastInvoiceAmount. It's CustStatisticsRecentActivity form part

But if you want to add your own form part with related information, take a look at CustStatisticsRecentActivity form part and try to do the same thing.

Was this reply helpful? Yes No