Modify range in AOT query

(0) Share

Report

Posted on by bankk

6,609

Hello and happy Friday.

I have an AOT query I'm calling from within X++ code. On the AOT query, one of the datasource I have a range defined for a specific created date values (I'm currently using greaterThanDate(-90) in the AOT query for testing). At runtime, is it possible to modify the created date range value, say to greaterThanDate(-1), from within X++ before executing the query itself? Hope that was somewhat clear.

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Brandt Fundak 2,007 on at

Like (0)

Report

I would take a look at the SysQueryRangeUtil class:

msdn.microsoft.com/.../sysqueryrangeutil.aspx

Specifically the dayRange method.

Hope that helps.

Brandt

Was this reply helpful? Yes No
bankk 6,609 on at

Like (0)

Report

Brandt, thanks for the reply but I'm not sure the question was answered. My dilemma is I have an AOT query, not one that I built in code. The AOT query contains a value in the range node which I would like to change at runtime.

Better yet, I could phrase the question a little differently. Is it possible to add a range to an AOT query called within X++ code? So this is all I have to access the AOT query from within X++...

Query q;

q = new Query(queryStr([AOT query name]));

Once I have "q", can I modify the query details?

Thanks!

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Not a problem. Find the range by QueryBuildDataSource.findRange() and change its value (QueryBuildRange.value()).

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Regarding the new question - yes, you can do whatever you want with such a query.

For example, find an existing data source (e.g. q.dataSource(tableNumTable(YourTable))), add a range (addRange(fieldNum(YourTable), YourField))) and so on. You'll find many examples both in AX and on internet.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

Along the lines of the same question, but totally different :-)
Can I modified a query who already joins 2 tables and add a 3rd datasource but as a union all?

Thanks.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Everything what you can do with the Query framework can be done even if you create the instance of your Query object from an AOT query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Well, I'm trying to incorporate the union part programmatically to a query in which I have 2 tables already joint.

but it doesn't seem to work. When I run SQL profiler the query doesnt take into consideration the union piece.

Do you have any examples for union with complex queries laying around somewhere?. :-)

Thanks.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

if your question isn't related to the topic of this thread ("Modify range in AOT query"), please create a new one.

Was this reply helpful? Yes No
Majid Hafeez 40 on at

Like (0)

Report

Try This IT works fine:

qbrDate = SysQuery::findOrCreateRange(query.datasourceTable(tableNum(WHSWorkTable)),fieldNum(WHSWorkTable,WorkClosedUTCDateTime));
qbrDate.value(SysQuery::range(fromDate, todate));

Was this reply helpful? Yes No