Hi all,
Hopefully this isn't a duplicate as I've been looking all over for an answer to this.
I've been working with a Multi-Tenant instance of LTM. If you're not aware, in this configuration, you're not able to use the SQL Query node to retrieve information from the database. This is posing a bit of a problem when attempting to get at the audit data behind the Employee record.
In short, I'm attempting to get when the Relationship Status and Work Type change on the Employee (Resource) record. I can right-click on the field and see the history. I can also use the drop-down in the upper right-hand side to view the full audit log. I've also tried creating a user field, but, to be honest, am not terribly well-versed in creating those. I've tried a few, but have been getting the effective date of when the Relationship Status or Work Type value was created, not when the Employee was put there.
I have found the data in the EmployeeExport business class under the "generic" module. However, I've been told by our functional folks that this business class holds temporary data and might not be reliable.
Has anyone run into this and have a solution? Again, I'm not able to query using SQL.
Thanks in advance!
Randall
Thanks David, much appreciated.