how to monitor changes on tables automatically

[S.Kuskov]

Then it is easier create batch job witch makes check in / out the objects to VCS

[Alex_KD]

Цитата:

My next Idea was to get the information out of table UtilIdElements but this Table is not in the SQL Database so i can't set a trigger to it to monitor changes.

Try to stick with this one.
You should be able to get all AOT elements that were modified.

Please find the sample xpp code, which returns all elements that were modified in the last 5 minute (300 second), below:

 UtilIdElements          utilIdElements;
         utcdatetime        datetime;
         date   modifyDate;
         ;
      
          begin = WinApi::getTickCount();
          modifyDate = systemdateget();

          datetime = DateTimeUtil::newDateTime(modifyDate,  ((timenow() - 300) > 0)?(timenow() - 300):(0));
    
          while select name, id, recordType from utilIdElements
          where  (utilIdElements.createdDateTime > datetime) ||
               (utilIdElements.modifiedDateTime > datetime)
           {
                switch(utilIdElements.recordType)
                 {
                       ......
                 }
           }

[Logger]

Цитата:

Сообщение от Alex_KD

Try to stick with this one.
You should be able to get all AOT elements that were modified.

Please find the sample xpp code, which returns all elements that were modified in the last 5 minute (300 second), below:

 UtilIdElements          utilIdElements;
         utcdatetime        datetime;
         date   modifyDate;
         ;
      
          begin = WinApi::getTickCount();
          modifyDate = systemdateget();

          datetime = DateTimeUtil::newDateTime(modifyDate,  ((timenow() - 300) > 0)?(timenow() - 300):(0));
    
          while select name, id, recordType from utilIdElements
          where  (utilIdElements.createdDateTime > datetime) ||
               (utilIdElements.modifiedDateTime > datetime)
           {
                switch(utilIdElements.recordType)
                 {
                       ......
                 }
           }

It's correct only for build 1500.4570
see
kb2472202 The ChangedDate field and the ChangedTime field on a class are not updated when you change the class in Microsoft Dynamics AX 2009 SP1

[Alex_KD]

Цитата:

Сообщение от Logger

It's correct only for build 1500.4570
see
kb2472202 The ChangedDate field and the ChangedTime field on a class are not updated when you change the class in Microsoft Dynamics AX 2009 SP1

Thanks for pointing this out.
I think this piece of code is enough to get idea....well it might require some amendments as I just copied it from the old xpo.

[Dark Smile]

Thanks for this code, i will try to stick with this and will give feedback

[Dark Smile]

Hey guys, thanks for the quick help to all.

My solution is a Class, that is called in SysDictField every time a change occures and reads the Data out of table UtilIdElements such as in the hint of Alex_KD.