web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
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

I have the same question (0)

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 503 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 288 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans