Created by, creationdate , changedby and changedtime property doesn't get updated.

(0) Share

Report

Posted on by rabud

whenever we create or modify objects in AX AOT table /classes/ Menu /Menu item , the Properties - created by, creationdate, changed by and changedtime doesn't get updated.

Any setup or configuration is missing, we don't have the TFS setup to check on when the objects are modified other than comparing the code within the layers. if in case the code is modified within the same layer in the class without any comments in place , finding difficult in tracing the changes on who modified and when it was last modified as the properties doesn't get updated, any way to trace this.

Thanks in Advance.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Vilmos Kintera 46,149 on at

Like
a
(1)

Report
Copy link

Link copied!
I can see changes in SQL Server in the _model database perfectly fine, check there:

USE [MicrosoftDynamicsAX_model]; GO SELECT TOP 100 Name, ElementType, ModelElementData.ElementHandle, LayerId, ModelId, MODIFIEDBY, MODIFIEDDATETIME FROM [dbo].[ModelElementData] LEFT OUTER JOIN [dbo].[ModelElement] ON ModelElementData.ElementHandle = ModelElement.ElementHandle order by MODIFIEDDATETIME desc

No changes are required, whenever you modify and save the AOT, the kernel should automatically do the timestamping. If it does not happen, maybe either your kernel, or the SQL stored procedures on your AX databases are broken.

It is better to implement TFS though to track your changes for your environments, especially for Production.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,932 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you tell us why you decide not using any kind of version control system? It's extremely inconvenient and risky, so I'm trying to understand what reasons people have to do that.

You complain about difficulty of tracing what changes were done, when, by whom and why, so why don't you use the system designed for exactly this purpose? And you'll have the completely history, not just information about the last change, and you'll never lose any code.

Was this reply helpful? Yes No
rabud 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Vilmos for the response,

i have a new menuitem in CUS layer , and when i open the properties from AOT , i see the createdby,date,changed are blank. i cannot figure out who created or when was the change made. so in this case the kernel or SQL stored procedure on AX Databases are broken ?

Was this reply helpful? Yes No
rabud 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi martin,

the AX was implemented by some consulting and was not implemented, not when the system went for Auditing , there were all these questions as date was not registered. i do accept with you and we are in a plan to setup the version control system.

was trying to check why the date was not registered for some objects and for some why its not getting updated when we make changes, any way to figure this out within AX or from the database queries.

Thanks,

Was this reply helpful? Yes No