BAQ for Specific Change Log Types

[grant-rb (Grant R)]

Has anyone created a BAQ that pulls only change log details showing customer ID changes? Any guidance would be greatly appreciated.

[dcamlin (David Camlin)]

I haven’t… but that’s a good idea.

A BAQ against ChgLog… set the table criteria:
“Identifier” = “Customer”… you’ll get all logged changes against that table.
“LogText” LIKE ‘%CustID%’ constant

I used “TerritoryID” in my test because we don’t change CustIDs… but it appears to work.

The LogText contains carriage returns, so you have to hover your cursor over them and you can see the full text (in the BAQ designer).