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

Announcements

No record found.

News and Announcements icon
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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 577 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 309

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans