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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 69
Veteran Member
8/4/2015 6:01 PM
Just saw how old this thread was... nevermind.