One of the advantages of our bridges is that the use of the ASI iMIS Business Objects, iBOS. This means we do not have to make direct SQL calls to record and pull data from the iMIS database.
For the iBOs we are using in the Real Magnet bridge, the iBO, not the bridge, creates these changelog entries. While not convenient, there isn’t a way around that while still using the iBOs themselves. This will create a log for each of your iMIS records like:
Set up a SQL Job with the SQL query. Below are two examples:
- Delete from Name_Log where LOG_TEXT like ‘RealMagnet%’ and DATE_TIME < DATEADD(d,-1,getdate())
- This deletes every Real Magnet log entry that is older than one day. To change number of days just make -1 in DATEADD to how many days.
- Delete from Name_Log where LOG_TEXT like ‘RealMagnet%’
- This deletes all Real Magnet log entries.