Resource Query Node

 7 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
TBonney
Veteran Member
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
    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
      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
        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
          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
            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
              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
                Gary Davies
                Veteran Member
                Posts: 248
                Veteran 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