BAQ - Object reference error

Is there a way to find out when a BAQ was last modified or updated? We are getting an “object reference not set to an instance of an object” every time we open the BAQ and then it errors if we ‘quit’ or ‘continue’ on the next error message.

image

I’m not sure if my solution will catch the last updated date, but I have a data directive set on the “Exports” table (holds data on E9 queries) that has an action of setting the Exports.Date01 field to the current date when a new record is created to track query creation date. You could try having a condition of setting off the action every time an Exports record is updated instead to see if that works for you.

As a workaround, we copied the BAQ and it worked fine. Not sure what happened to the original BAQ if a missing parameter or table caused the object reference error.