Having trouble figuring out how to bridge the disconnect between my dialog and a user defined query in X++

(0) Share

Report

Posted on by Brandt Fundak

2,007

I hope someone can offer some guidance to a Dynamics noob.

I have created a class that extends RunBaseBatch and have overridden the showQueryValues method so users can enter a query against the CustTrans.TransDate field, as the QueryRun of this class has the CustTrans as its data source and the TransDate field as its range. I have also overridden the dialog method as well, as I needed to add a field where a user could specify a file path (this particular code exports data for use with a non AX system.) When the dialog appears, it shows the filepath field as well as the transdate field with the Select button. However, if a user creates a query range using the select button, it does not populate the TransDate field in the dialog form. We are attempting to set the value of the query to the SysQueryRangeUtil::dayRange method and if I specify the range value in my X++ code like so:

queryBuildRange.value(SysQueryRangeUtil::dayRange(-60,0)

it will resolve the values of those dates in the field TransDate field in the dialog.

Obviously, I am missing something here. How do I pass the user defined query back to the dialog so that it will be used by my QueryRun? I have only been doing AX development for about 6 months, so I am sorry if this is a stupid question.

Hopefully I have described the problem correctly. Thanks for any guidance you can give me.

Brandt

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

Have you overridden the queryRun() method of your class to return your queryRun object? That might be the disconnect. Also, are you calling super() in your overridden dialog method? There might be something in the super call that makes sure that your queryRun and the one displayed on the dialog are the same object.

Hopefully it's one of these two, but if it's not let me know and we can try and work it out further.

-Justin

Was this reply helpful? Yes No
Verified answer

Brandt Fundak 2,007 on at

Like (0)

Report

Justin,

The problem was with the QueryRun and it was only dumb luck that I found out what the problem was.

My original code was this:

Query                      query;

QueryRun                   queryRun;

QueryBuildDataSource       qbd;

QueryBuildRange            qbr;

;

query = new Query();

qbd = query.addDataSource(tablenum(CustTrans));

qbr = qbd.addRange(fieldnum(CustTrans,TransDate));

queryRun = new QueryRun(query);

What I didn't realize at the time is that if I assign the range to a variable, that X++ is going to expect me to provide the value. If I don't set it, the user defined query works as expected. It's quite the idiosyncracy, and one I won't forget.

Thanks for your help.

Brandt

Was this reply helpful? Yes No

Community site session details

Having trouble figuring out how to bridge the disconnect between my dialog and a user defined query in X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Having trouble figuring out how to bridge the disconnect between my dialog and a user defined query in X++

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates