web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... change tracking based ...

Finance | Project Operations, Human Resources, ...

Unanswered

change tracking based on field change

(1) Share

Report

Report

Posted on by CU22120935-0

252

Hi,

I have table1 inner joined with table2. And table2 inner joined with another 3 tables.

I want to enable change tracking on table1 and table2 only. And Only if a certain field is changed on table2.

so this certain field gets incremented whenever an update happens on table1 or table2. So my change tracking should only work if this certain field in table2 changed. How can i do that? is it doable via custom default query? and if yes how?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Navneeth Nagrajan 2,635 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Change tracking modifications can be done through defaultCTQuery() method on a data entity. In this case, for change tracking to work you will need to define the change tracking on table2 and include the field based on which the query should run. Custom query should be the option to enable on the data entity at the application level and then any modifications done to the field mentioned should be picked up. Because table1 is your primary table here primary table shouldn't be the option that should be enabled, it should be custom query.

Also, in your data entity ensure that you add this line of code.
<dataentityname>.addChangeTrackingDataSourcesFor<tablenameBase>(<queryobject>,fieldnum(<datasourcename>,<fieldname>);

Sample:
InventProductDefaultOrderSettingsEntity::defaultCTQuery()

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

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

#2

#3

Martin Dráb 280 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans