Nested data access loop found in method

(0) Share

Report

Posted on by CU21091228-0

230

Hi Team,

I have created one custom View ABC_CustPackingSlipTrans.

If i use ABC_CustPackingSlipTrans with while select, getting below BP Warning.

Nested data access loop found in method in D365FO.

Please let me know how to solve this.

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 236,879 Most Valuable Professional on at

Like (0)

Report

Nested data access loop found in method in D365FO

You have two options: either you somehow resolve the nested looks, such as by using joins. Or you decide that you must use your current design and you'll suppress the warning.

If you you don't know whether your code can be changed and you want ask us for help, not that you'll need to show, or at least describe, your current code.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

Nested data access loop found in method

Hi,

Refer to this documentation for list of BP warnings and how to fix them.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-tools/customization-analysis-report

Also please show us the code you have written so we can give better suggestions.

Thanks,

Girish S.

Was this reply helpful? Yes No
CU21091228-0 230 on at

Like (0)

Report

Nested data access loop found in method

Below code i am using.

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

Like (0)

Report

Nested data access loop found in method

Instead of running a while-select loop for every SalesTable record returned by the query, you could create a single query returning all the data at once.

But I wonder why you need the outer loop at all. I see that you filter the inner query by deliveryDate date too, so I assume this is covered. Are you saying that your CustPackingSlipTransView returns also records with OrderAccount values that aren't the ID of related sales orders? Or why do you need to fetch the list of customers before querying custPackingSlipTransView?

Was this reply helpful? Yes No