Resource Query Node

 7 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
TBonney
Veteran Member Send Private Message
Posts: 281
Veteran Member
Please Help!

Is anyone able to advise me on how I can use a Process Flow (Integrator) Resource node to identify the Company assigned on a users _COMPANY service as defined on their user profile within Security Adminstrator (LSF9)?

We have a subsidiary company whose employees had access to our Lawson system, but the subsidiary was sold so I need to deletee their profiles/access. I thought the easiest way to get rid of their profiles would be to identify them using a Resource Query in Process Flow and then use the loadusers utility with the -u switch.

However, being a process flow newbie, I have not been able to configure the Resource Query to properly identify the userids from this particular company number in my query.

Can anyone help me to identify the proper syntax I should be using in building my resopurce query in order to select employees by that company number in the _EMPLOYEE Service Identity?

Thanks in advance for any guidance you can provide!
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
In your ResourceQuery select People and enter the Product Line and then click Get Attributes.
Select the values you want to capture, like ID. Click Next
Select the Agents tab and the Agent productline_COMPANY
Select the Expression COMPANY and enter your company value
Click the Add Expression button
Click Next
Click Test your Query and if successful, click Finish
David Williams
TBonney
Veteran Member Send Private Message
Posts: 281
Veteran Member
Thank you for your response David.

I have tried this...However, when I select the Agents tab, the only 'Agent' listed is that of the poduct line the product line and the only 'Fields' listed are DOMAIN_USER, PASSWORD, SID and UID.

Any idea why I wouldn't see productline_COMPANY as one of the agent fields to choose from? Thank you!
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
Can you log into Lawson Security Administration and check what values are available on your user records?
David Williams
TBonney
Veteran Member Send Private Message
Posts: 281
Veteran Member
david, please disregard my last post. I was using an obsolete, test product line. Now that I have the correct test product line identified, I do get 'productline_EMPLOYEE' as one of the agents and I am therefore able to select the COMPANY field = #### to get the expected records.

Thank you kindly for your assistance!!!
TBonney
Veteran Member Send Private Message
Posts: 281
Veteran Member
I hope this thread is still active...I have another issue with my resource Query that I am hoping someone can help me with.

I have built a simple flow, which just performs a resource Query (by company number and the presence of a particular role) and generates a file and emails it as an attachment. However, it times out on me when attempting to run it through Designer. I found a KB article on Lawson's site, but it is in regards to a system Admin node, which I am not using. It references that Designer has a built in 30 second timeout and recommends running the flow from the server.

I tried this, but still through Designer and it still times out. How can I run the flow outside of designer? It's a simple flow, built for use by the security admins in IT, intended to only ever be run from within Designer. (I've never built a trigger before.)

Any ideas? Thanks!!
ShawnV
Advanced Member Send Private Message
Posts: 37
Advanced Member
I believe that if you are running version 9 of process flow, from designer you have the option to 'run on server'. Even though your Designer will time out, the actual flow will still continue to run behind the scenes on the Lawson server box. The only drawback is that you don't know when it is actually completed unless you look at the workunit in bpm/menu.do.

Unfortunately I don't know of a way to extend the designer timeout option.
Shawn
Deleted User
New Member Send Private Message
Posts: 0
New Member
Even if you run on the server it could stilk timeout depending on how many records you have to spin thru, my experience is anything over 3000 causes issues when you include service agents in the criteria. Adding and additional criteria can help