Data Base Log Setup in AX 2012


SysDataBaseLog sysDataBaseLog;
utcDateTime CurrentDate;
container tableRecord;
container recordInstance;
str selectedField;
str fieldName;
str fieldValue;
int idx;
int tableID;
str  databaseLogSourceCompany;

CurrentDate=DateTimeUtil::newDateTime(today(),str2time(“00:00:00”));
tableID = tableName2id(‘Student’);

while SELECT sysDataBaseLog
          WHERE sysDataBaseLog.table ==  tableID
&& sysDataBaseLog.createdDateTime > CurrentDate
        && sysDataBaseLog.LogType == DatabaseLogType::Insert

{
selectedField = “RollNumber”;
fieldName=””;
fieldValue = “”;
tableRecord = (sysDataBaseLog.Data);

for( idx = 1; idx <= conLen(tableRecord); idx++)
{
recordInstance =  conpeek(tableRecord, idx);
fieldName = conpeek(recordInstance, 1);

if(strLwr( fieldName ) == selectedField)
{
fieldValue +=” ” + conpeek(recordInstance, 2) + ” , “;
break;
}
}
}

Comments

Popular Posts