How to differentiate same data source in Query

Finance and Operations/AX Developer Forum
1

Hi All,

I have created query like below screen shot.

pastedimage1506604485524v1.jpeg

My main table have Debit account and Accrual account field which have relations with “DimensionAttributevalueCombination” table RecId. I will try to get the debit account recId and accrual account RecId from “DimensionAttributevalueCombination”.Please suggest how to get the individual “DimensionAttributevalueCombination” recId’s.

Please suggest.

Thanks.

2

The image is not clearly visible. Can you please attach another one?

From the title, you may have to use queryRun.getNo(), https://msdn.microsoft.com/en-us/library/queryrun.getno.aspx

3

comm1.JPG
comm1.JPG1271×417 77.4 KB

4

Use the occurrence parameter in the get method,
queryRun.get(tableNum(DimensionAttributevalueCombination, 1);
queryRun.get(tableNum(DimensionAttributevalueCombination, 2);;

(or)

you can also use queryRun.getNo();

5

Hi Kranthi,
Thanks for your reply…
Loop gets loaded baseed on data source added in query,How to restrict only once…

comm2.JPG

6

msdn.microsoft.com/…/queryrun.changed.aspx

Is this what you are looking for?