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)

Sort by

Martin Dráb 239,484 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Below code i am using.

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

Like (0)

Report
Copy link

Link copied!

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