4
It seems like in the SQL issued by the system, the extension table is missing query hint such as WITH(READUNCOMMITTED). These query hints are vital for better performance, especially to avoid blocking and deadlocks. The captured SQL command is attached to this request.
Also while referring the extension table add 'AS' key word for consistence with the rest of the code.
The expected SQL command should be something like

SELECT TOP (@0)
List of fields from both base and extension tables ,.....
FROM "Cronusgb".dbo."CRONUS UK Ltd_$Sales Line$437dbf0e-84ff-417a-965d-ed2bb9650972" AS "Sales Line" WITH(READUNCOMMITTED)
JOIN "Cronusgb".dbo."CRONUS UK Ltd_$Sales Line$ef933c61-34d2-4d4e-ada4-6fdf714541ab" AS "Sales Line_e1" WITH(READUNCOMMITTED)
ON("Sales Line"."Document Type" = "Sales Line_e1"."Document Type") AND ("Sales Line"."Document No_" = "Sales Line_e1"."Document No_") AND ("Sales Line"."Line No_" = "Sales Line_e1"."Line No_")
Category: Development
STATUS DETAILS
Completed
Ideas Administrator

Thank you for your feedback. We released this feature as part of the functionality in 2019 release wave 2. It was also backported to 2019 release wave 1

 

Sincerely, 

Kennie Nybo Pontoppidan

PM, Microsoft 


Comments

R

Dear Kennie,

Thanks for addressing this in the next release. I also raised something similar on See https://experience.dynamics.com/ideas/idea/?ideaid=b2e02d9d-3e31-ea11-8454-0003ff689747. Can you please address it at the same time. I believe it has the same effect (ie incorrectly linking to the base table).

Category: Development

R

Thank you for your valuable feedback.

We have decided to deliver this idea and make it available with Business Central 2020 release wave 1. It will also be back-ported to versions 14 (2019 release wave 1) and 15 (2019 release wave 1) and included in the next Cumulative Updates for those.

Your help was greatly appreciated,

Kennie Nybo Pontoppidan
PM, Microsoft 

Category: Development