News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to restrict the se...

Finance | Project Operations, Human Resources, ...

Suggested answer

How to restrict the select of fields that are not needed in SQL executed in x++

(0) Share

Report

Report

Posted on by Ko Yamazaki

28

SQL executed in x++ will select fields that are not needed.
Is there any way to limit this for better performance?

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 10,694 Super User 2024 Season 2 on at

Like (0)

Report
How to restrict the select of fields that are not needed in SQL executed in x++

Hi Ko Yamazaki,

I think you can create a best practice rule to to prevent the use of Query/Select statements without fields needed

e.g.

select * from SalesTable Where SalesId = ''

Doc : https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-tools/author-best-practice-rules

Best regards,

Mohamed Amine MAHMOUDI
Martin Dráb 230,466 Most Valuable Professional on at

Like (0)

Report

How to restrict the select of fields that are not needed in SQL executed in x++

I think I've already covered it in your previous thread, limited fields of data sources in form from query.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans