Effective date change during User Action

Hi Jessica M. You have to pull it from the Action Request business class using the ActionRequest as the key.

Good Luck!
Kelly

This is my landmark query node. I changed the effective date from 12/23/16 to 12/26/16 during the HRAdmin approve action. In the example below, I just queried all two of the action requests that are currently in our test system after a recent data refresh. It returns null for the effective date. I've browsed through the tables via SQL mgmt studio and I do not see where the 12/26/16 date was stored either.

============================================
Started locally: Dec 22, 2016 9:55:58 AM EST

Process started: Untitled Process 1 (Run id = 4) - 12/22/2016 09:56:00

Activity started: Start (Run Id: 4)
Executing Start Activity...
Variables in Process:

Activity completed: Start

Activity started: LMTxn6530 (Run Id: 4)
Landmark:LMTxn6530 Executing transaction_dataArea="ltm" & _module="la" & _objectName="ActionRequest" & _actionName="Find" & _actionType="MultipleRecordQuery" & _runAsUser="" & _pageSize=30 & ActionRequest & EffectiveDate
Landmark:LMTxn6530 Executing transaction_dataArea="ltm" & _module="la" & _objectName="ActionRequest" & _actionName="Find" & _actionType="MultipleRecordQuery" & _runAsUser="" & _pageSize=30 & ActionRequest & EffectiveDate
Landmark:LMTxn6530 transaction complete:true,
response message:null,
record count:2,
results header string: ActionRequest,EffectiveDate,
results string:0158df04-4ad8-0000-0009-d84d4d6da115,null
015920f5-aed9-0000-0000-789a4d6da115,null,
has next:false,
has prev:false
LMTxn6530_complete = true
LMTxn6530_recordCount = 2
LMTxn6530_hasNext = false
LMTxn6530_hasPrevious = false
LMTxn6530_resultsHeader = ActionRequest,EffectiveDate
LMTxn6530_currentPage = 1
Landmark:LMTxn6530 Page 1 retrieved
LMTxn6530_recordCount = 2
LMTxn6530_currentPage = 1
Activity completed: LMTxn6530
LMTxn6530_errorCode = 0
LMTxn6530_informationCode = 0
LMTxn6530_returnMessage =
LMTxn6530_outputData = 0158df04-4ad8-0000-0009-d84d4d6da115,null
015920f5-aed9-0000-0000-789a4d6da115,null
LandmarkLMTxn6530: Executing loop 1 of 2 (Page 1)

Activity started: LMTxn6530 (Run Id: 4)
LMTxn6530_EffectiveDate = null
LMTxn6530_ActionRequest = 0158df04-4ad8-0000-0009-d84d4d6da115

Activity started: End-LMTxn6530 (Run Id: 0)
LandmarkLMTxn6530: Executing loop 2 of 2 (Page 1)

Activity started: LMTxn6530 (Run Id: 4)
LMTxn6530_EffectiveDate = null
LMTxn6530_ActionRequest = 015920f5-aed9-0000-0000-789a4d6da115

Activity started: End-LMTxn6530 (Run Id: 0)

Activity started: End (Run Id: 4)
Activity End: Executing End activity
End_errorCode = 0
End_informationCode = 0
End_returnMessage =
End_outputData =
Activity completed: End
Process completed - 12/22/2016 09:56:00

Process ran successfully
Information code: 0
Return message:
Output data: (null)

Finished: Dec 22, 2016 9:56:00 AM EST

Hi Jessica M,

I apologize - I pointed you in the wrong direction. I don't know what I was thinking... I also was out for a couple of weeks so I didn't see your message until now.

Rather than querying the ActionRequest business class, you need to query the target business class for the action using action "Find{actionname}. For example, if the action is Employee.HireResource then you would need to query the Employee business class using the "FindHireResource" action where ActionRequest = {ActionRequest} and you would need to include "Employee_effective_date" to get the action effective date. You can use this to get all the parameter fields as well as Reasion Code (as Employee_reason_code) and Action Reason (as Employee_action_reason). If you were doing a transfer, you would want to return WorkAssignment_effective_date, etc.

What I generally do is query the ActionRequest business class first to get the BusinessClass and BusinessAction; then use those values to query the returned BusinessClass using the returned Business Action.

Extra hints
- the "Find{whatever} action will return ONLY THE MODIFIED VALUES from the business class, so if the field value didn't change (like on a rehire) it will be blank.
- You can use "FindMerged{whatever} to return ALL business class field values, with the modified fields overwritten and the unmodified fields included.
- The "Find{whatever} and FindMerged{whatever} will not be listed in the Landmark node Actions list - but they are always available.
- It is very difficult to get the above information with SQL. Much of it is stored in xml.
- Note that you must use the true ActionRequest name that was submitted - the one from the action request query - not the flow, service, or form name.

I hope this is helpful.
Kelly

Thank you so much for all your help Kelly. This worked perfectly.

I've had an incident open with Infor on how to do this. They can't seem to figure it out. :-(

I'm not sure what I would do without these forums. Again, I appreciate your help with this.

Hi Jessica,

I'm glad you got it figured out!  There is certainly a lot of "behind the scenes" information that really helps to keep this beast running.

 

Good Luck!

Kelly