PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/09/2018 10:34 AM by  Randall
Employee Audit Information via Landmark Transaction Node
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Randall
Private
Private
Veteran Member
(103 points)
Veteran Member
Posts:43


Send Message:

--
04/06/2018 1:11 PM

    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

    David Williams
    Private
    Private
    Veteran Member
    (3061 points)
    Veteran Member
    Posts:1031


    Send Message:

    --
    04/07/2018 11:42 AM
    The GenericInterface - EmployeeExport is the best table to track your changes and I believe the records are stored long term. You should
    use the API calls to get the data instead of LandmarkTransactions - they are must faster.
    David Williams
    Randall
    Private
    Private
    Veteran Member
    (103 points)
    Veteran Member
    Posts:43


    Send Message:

    --
    04/09/2018 10:34 AM

    Thanks David, much appreciated.

    You are not authorized to post a reply.