How to differentiate same data source in Query

(0) Share

Report

Posted on by Edselv Evert

435

Hi All,

I have created query like below screen shot.

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.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Hi,

Please use the following code i.e use getNo() instead of get() on queryRun.

ds1 = qr.getNo(2); // Represents DimensionAttributeValueCombination_1 in your query ds2 = qr.getNo(3); // Represents DimensionAttributeValueCombination in your query

Instead of

ds1 = qr.get(tablenum(DimensionAttributeValueCombination)); ds2 = qr.get(tablenum(DimensionAttributeValueCombination));

Refer link:

(QueryRun.getNo Method [AX 2012])
msdn.microsoft.com/.../queryrun.getno.aspx

Was this reply helpful? Yes No