Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

(Stack trace: Field 'XXXXXXX' in table 'DirPerson' has not been explicitly selected

(0) ShareShare
ReportReport
Posted on by

I have a case on customer side when a fields is updated om worker form the following error appear (Stack trace: Field 'MaritalStatus' in table 'DirPerson' has not been explicitly selected)

I try to add all fields related to table DirPerson using personalization , the error disappear.

When I check the form I find that the property of data source DirPerson (OnlyFetchActive) is set to true and there are a list of selection fields are added . When I check the form query I find that a specific list of fields appear in select statement of DirPerson not select *


I try to change OnlyFetchActive to false using COC in init method of the data source before calling original init method and Also I try to reset selection fields using this.queryBuildDataSource().fields().clearFieldList();
But still certain fields are selected .


I need to know is the featrure OnlyFetchActive is the one leads to error (Stack trace: Field 'MaritalStatus' in table 'DirPerson' has not been explicitly selected) , If the form query is select * from DirPerson this will solve the error if yes how to enforce it on the form

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans