Lost approvers when going to 9.0

 7 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
elizb
New Member Send Private Message
Posts: 0
New Member
We just went live on LSF 9.  Using PF Pro.  In 8.0 we had multiple logins and logged in to PF using employee#.  In 9.0 (single sign on) we use username to login.  Have 1 flow, job requisitions.  After going live we realized the approvers were not being recorded in PAJOBREQ because the approvers field is a number and we are now sending a string.  Don't want to change field type and in fact want to record employee#, not username.  WFMetrics is recording username.  Thought I would query WFMetrics for username and convert it to employee# and write it to PAJOBR either at the end of the flow or after each approval.  But no, I have to have the WorkUnit to query WFMetrics.  Anyone have an idea how I can get the employee # recorded? 
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
You have to use the ResourceQuery to get the Employee number from the userid.
David Williams
elizb
New Member Send Private Message
Posts: 0
New Member
The resource query has an ID field that contains the username.  I don't find a field that contains the employee number.  My admin guy says their is a field but it is in a different section and the field is not an option to me in the resource query.

I have a script that given the username, it will give me the employee#.  I can call this script with a webRun

The problem is I don't have the username.  The approvers log in with their username.  They go to their inbasket and perform the "work".  The userNode takes care of all the bookeeping.  But as I stated, it won't fill the username in the PAJOBREQ table because the approver fields are of type number.  Does the userNode create a variable that I could access that contains the username?

I need the username of the approver who logs in and does the "work" for a given userNode or I need the flow to know its own workUnit# so I can query the WFMetrics table.  Are either of these available in a flow?
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
If you are using the Employee # within Lawson Security (for ESS or MSS) then you can get to this "Agent" via the ResourceQuery.  I've attached some screen shots to show you how.

Attachments
David Williams
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
There is a system variable called oWorkUnit available within your flow which is the WorkUnit number currently associated to your flow.
David Williams
elizb
New Member Send Private Message
Posts: 0
New Member
Thank you for both your answers. Either will solve my problem. What is an agent?
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
An agent is Lawson's term for the additional identity information you can add to a user, like Requester ID (for RSS), Employee Number (for ESS & MSS), etc. By the way, these additional "agents" must be added for all application product lines (data areas). So for Test and Dev you have to add both Test_Employee and Dev_Employee.
David Williams
John Henley
Send Private Message
Posts: 3351
Re: Lost approvers when going to 9.0 (576c15e1-ad11-463a-b80e-459392f2563f) <!-- Converted from text/plain format -->

An agent is used to retrieve security identities associated with a resource.  In this case it would retrieve the employee number of the approver based on their login when the make the approval.

What David is recommending with the ResourceQuery node is the best approach for you.   You would need to update your approval flow to include the ResourceQuery node.

Thanks for using the LawsonGuru.com forums!
John