Hi
i want to create a liste of changed / new obj in AX2012 per date. In AX 3.0 i did this via "develoment Environment" -> "Tools" ->""developement Tools" -> "application obj" and there filtered by date
any hint how to do this in AX 2012 (Kind of Version tracking..)
Thanks
Pirmin
*This post is locked for comments
Hi
well when using the sql script above i get too many changed obj for the time .. and most of them are at same date/hour with maybe some mins of difference..
Why do you think so?
If ModifiedDateTime was the time of the last compilation, compiling the whole AOT would update ModifiedDateTime on all elements, wouldn't it? It doesn't seem to be the case in my system.
Regarding CIL, AX determines the last CIL generation date from SysXppAssembly table.
thanks
i did a lil sql statment
**
select distinct name, createddatetime, createdby, modifieddatetime, modifiedby from ModelElementData , ModelElement
where -
ModelElementData.parenthandle=ModelElement.elementhandle
and year (modifieddatetime)= 2014 and month( modifieddatetime) > 4
***
can it be tht the modifieddate is also the last compile/cil date?
In AX, it's under AOT > System Documentation > Tables. Technically it's a view to the model store database.
By the way I made a little mistake - you want SysModelElementData table, not SysModelElement.
Hi
srry ..w as out of office .. where is the table sysmodeleement stored?
Pirmin
The best kind of version tracking is a real version tracking. :-) And it's the only safe way, because it's independent on AX instances.
Nevertheless SysModelElement.CreatedDataTime and ModifiedDataTime may be sufficient for your purposes.
#1
André Arnaud de Cal...
294,141
Super User 2025 Season 1
#2
Martin Dráb
232,881
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
