Announcements
155
Hi every one I am new to AX. I am doing some Research and development on change tracking .
In the above link I am not understanding what is written in custom query for change tracking. I would be very great full if some one explains me in a step by step procedure of what they have done.
I am very confused with the highlighted statements.
Hi Neetha,
There are three ways to enable change tracking (that is, those you find in the screenshot),.
Enable primary table, it only changes the entity by updating the primary table.
You need to choose the right one for your needs.
how to enable change tracking on Table not part of the entity. Data Management - > Data Entities - > (Filter Select Your Entities) - > Change Tracking - > Enable Primary table. Is this the correct path?
Hi Neetha,
First, the requirement is to enable change tracking on the table, not part of the entity. A join query table is needed to populate the values in the entity.
The part you point out is custom query change tracking, which means changing data in a custom table will change the data in the entity accordingly.
The meaning of the code is to create a query and return the query object based on the relationship between the entity's root table and the custom table.
Share
Report
All responses (
Answers (
Query q;
q = new Query();
QueryBuildDataSource qbd = q.addDataSource(tablename2id('ATable'));
qbd = qbd.addDataSource(tablename2id('BTable'));
qbd.relations(false);
qbd.addLink(fieldName2Id(tableName2Id('ATable'),'C'),fieldName2Id(tableName2Id('BTable'),'C'));
return q;
You can go to Data Management - > Data Entities - > (Filter Select Your Entities) - > Change Tracking - > Enable Custom Query
First part says you have to enable change tracking on the tables that you are using in query and second part is to join your entity with root data source of the query,you must have created for change tracking.
Following options from entity page on data management workaspcae enables change tracking for all entity datasources.
Enable entire entity – It will enable tracking for all Writable Datasource used in the entities.
Second part is very clear about join . Hope this helps . If not please mention what you are not getting.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
284,436
Super User
#2
Martin Dráb
225,206
Super User
#3
nmaenpaa
101,146