Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Process Flow Looping

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Chad Dirst
Advanced Member
Posts: 42
Advanced Member
4/10/2013 1:45 AM
    I have a process flow that reads all GLNAMES records.

    For each GLNAMES record it determines if an Attribute is associated with it from the AUMXVALUE file.  The attribute contains an RM ID.  Once I have the RM ID the flow performs an RM query to obtain the employee number.  I then utilize the employee number to query the EMPLOYEE file.  All of this works fine except when an RM ID does not have an employee number defined in the LAWSON_EMPLOYEE service. 

    When an RM ID does not find an employee number it loops through ALL of the EMPLOYEE records where COMPANY=X and EMPLOYEE=.  This dramatically slows down the query and is causing issues.  I tried putting in a branch node to check the record count (xxxxx_RECORD_COUNT!=0), however, this was not successful. 

    Any ideas?
    Thanks in advance. 
    Chad
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    4/10/2013 10:55 AM
      Just to make sure, are you verifying that your Attribute returns a value before you run the ResourceQuery?
      David Williams
      JudeBac
      Veteran Member
      Posts: 129
      Veteran Member
      4/10/2013 12:39 PM
        Have you considered using the SQL Query instead?
        Chad Dirst
        Advanced Member
        Posts: 42
        Advanced Member
        4/10/2013 11:56 PM
          Thanks for your reply David.

          I changed my check to be xxxxx_EMPLOYEE != "" and that resolved my issue.