One of the advantages of our bridges is the use of ASI iBOs. This means we do not have to make direct SQL calls to record and pull data from the iMIS database.
For the iBOs used 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.
If these entries are too cumbersome to manage, we recommend running scripts to remove them. To do so, 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.