Insight IQL Syntax Help to obtain Object History Data

[Crystal Rouse]

 Hello,

I am trying to create an IQL syntax to use in filters and reports showing when an Insight Objects data has changed.  Other than using the API, I can't find information on using IQL to reference the Objects Activity History Data.

For example, I need to create a report for when a field/attribute changes using IQL.

[David Sumlin]

Only other thing I can think of is to use SQL against the database directly. It's not completely straight forward, but it's possible.

[Crystal Rouse]

Thanks for the reply but unfortunately I do not have direct access to the database.

[Marina Veselić]

It would be a cool functionality to have an IQL option to determine which objects are subjected to automation BEFORE the event and an IQL to determine if the rule should apply AFTER the event. :D

[Alan Bruce]

Hello Crystal,

Were you able to get this to work? I have the exact same need.