I am trying to fix a BAQ that pulls records from the Ice.ChgLog table so that we can audit our supplier/customer changes. For some reason, there are no records newer than 7/7/2017, and I have confirmed that supplier and customer records have been changed many times since. The two tables it is looking at are Vendor and Customer. I did not create this BAQ, is there a possibility that it is linked to a data directive that may have been removed?
A data directive is what writes to the change log. Did you look through your data directives to see if they are enabled?
I did, I don’t see any data directives for the Customer or Vendor table.
Looks like they must have gotten deleted. Did anything happen on 7/7/2017 at your company?
If you run the query without the criteria is there anything else showing up in the change logs newer that 7/7/17? It might be easier just to write a new BAQ and just look at the table on it’s own.
No data directive, no change log… that’s how they get created. The base software is delivered with no change logs enabled. Sounds like maybe you used to have some, but somebody deleted them?
That was it…I made a new data directive and new records are showing up. Thanks everybody!
