Microsoft Dynamics AX (Archived)

merge two queries in X++

(0) Share

Report

Posted on by Community Member

Hello.

I have two queries, that I need to merge them together in that way:

Query1 has several datasources.

I want to replace datasource no 5 (i.e) with a specific query (with all of the attribute, like range, link, etc.)

Can I do it in a simple way?

Thanks :)

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Iulian Cordobin 8,201 on at

Like (0)

Report

Where you want this done? AOT or code?

Was this reply helpful? Yes No
Pradeep Itnal 3,248 on at

Like (0)

Report

To me its not very clear, how complicated are your joins:

Option1: However you can use Temporary table and push the data into it and then use it in joins.

Option2: you can check if there are any views already existing in AOT, which you can reuse.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In code.

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

Hi Eitan,

Can you please tell us the requirement which you are tying to achieve? May be there is a much simpler way to achieve it.

Thanks,

Baber.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

the functions sysQuery::mergeRanges and/or sysQuery::mergeFilters might help you ....

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

I didn't see that sysQuery::mergeRanges merge two queries (none of the examples work).

Seems there is no simple solution.

I will manage somehow.

Thanks, anyway :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

it doesn't, it only merges ranges/filters, but it might help you in writing some clever piece of code that results in the merge of two queries .... the sysQueryBuild* classes will surely help you

Was this reply helpful? Yes No
santoshkmrsingh 25 on at

Like (0)

Report

Hi Eitan were you able to make this work ? mind sharing some insights i have a similar requirement.

Was this reply helpful? Yes No
Suggested answer

santoshkmrsingh 25 on at

Like (0)

Report

solved the problem for anyone looking at a solution please refer the below link

santoshkmrsingh.blogspot.com/.../merge-queries.html

Was this reply helpful? Yes No