Prev
Next
Forums Infor / Lawson Platforms Lawson Landmark

Get Employee attached to Actor using Landmark Pflow Designer (LPD)

 3 Replies
 0 Subscribed to this topic
 32 Subscribed to this forum
Sort:
Author
Messages
Woozy
Veteran Member
Posts: 709
Veteran Member
7/22/2010 3:29 PM
    I am trying to find a way to identify the LTM employee number that is associated with an LTM actor using Landmark ProcessFlow Designer (LPD).

    I have the actor id (not the guid), but I can't figure out how to use a Landmark Transaction node to enter the Actor and return the HROrg and Employee from the Agent business class.

    I've also tried a relationship query from Actor without success.

    I've been able to get the ParentAgent GUID, but I can't seem to pass it into an AGENT query - I get an "Agent Does Not Exist" error.

    Anybody have ideas on this? Thanks.
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Angela
    Basic Member
    Posts: 5
    Basic Member
    6/16/2011 5:21 PM

      I am not sure if there is another easier way, but you can do a LM query , module = person and object ID = actor. You can get the actor's email address and from a RM query you get the employee number.
      Peter O
      Veteran Member
      Posts: 69
      Veteran Member
      8/4/2015 6:01 PM

        Hey Woozy,

         

        This works for me: 

        select emp.EMPLOYEE
from LMHCM.hcm.EMPLOYEE emp
inner join LMHCM.hcm.AGENT agent on (emp.UNIQUEID = agent.BORBUSINESSOBJECTKEY)
inner join LMHCM.hcm.PARENTAGENT pagent on (agent.PARENTAGENT = pagent.PARENTAGENT)
where pagent.ACTOR = 'ACTOR_ID'

         Your mileage may vary, but works 100% on our build.

        Also assumes your employee is completely set up - Actor, Agent, and agent attached to it's proper actor agent. if actor is not attached yet, this won't work.

        -Peter

         

        Peter O
        Veteran Member
        Posts: 69
        Veteran Member
        8/4/2015 6:01 PM
          Just saw how old this thread was... nevermind.