Prev
Next
Forums Integration / Customization IPA/ProcessFlow

query node related table query not working

 5 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Goober
Basic Member
Posts: 17
Basic Member
1/14/2010 8:11 PM

    I'm trying to run a query against Lawson tables using EMPLOYEE(DBHREMP)  with related table TA-MASTER (DBLPTEM) to pull all terminated employees with outstanding time off hours.  I'm Using EMPSET3 (COMPANY,EMPLOYEE STATUS) as a front end filter which works fine. But when I try to use the selection criteria to include available hours <> 0 the process times out.  If I run it on the server , no results are returned.

    The code:

    PROD=LAWAPP9&FILE=EMPLOYEE&INDEX=EMPSET3&KEY=88=VT;IT&FIELD=COMPANY;EMPLOYEE;EMP-STATUS;TA-MASTER.ACCR-HRS-BAL;TA-MASTER.AVAIL-HRS-BAL&SELECT=TA-MASTER.AVAIL-HRS-BAL%21%3D0&OUT=CSV&DELIM=~

     

     

     

    John Henley
    Posts: 3353
    1/14/2010 9:53 PM
      Do you have more than one TA plan, and if so, have you tried filtering on PLAN-NAME as well?
      Thanks for using the LawsonGuru.com forums!
      John
      Gary Davies
      Veteran Member
      Posts: 248
      Veteran Member
      1/14/2010 11:23 PM
        The AVAIL-HRS-BAL field is derived from the relationship between EMTAMASTR table amd the TAEEMASTER table so you probably won't be able to use it in the selection criteria. You will have to get all the recs, add them up for each employee that is terminated the branch based on if the value is 0 or not.
        John Henley
        Posts: 3353
        1/14/2010 11:53 PM
          You could also try using EMTAMASTR (if using TA) or TAEEMASTER (if using LP) as the base table and relating to EMPLOYEE. =
          Thanks for using the LawsonGuru.com forums!
          John
          Shane Jones
          Veteran Member
          Posts: 460
          Veteran Member
          1/17/2010 4:48 PM

            Process Flow has issues occasionally with including the RELATED table in the Select.   It is strange because sometimes it is a little inconsistent.   Sometimes just fliping the main and related tables fixes it but usually I find that I have to create a query within a query to get the information I need.

            Good luck.

            Shane Jones
            Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
            Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
            ** Teach others to fish...
            Goober
            Basic Member
            Posts: 17
            Basic Member
            1/26/2010 9:34 PM
              Thanks guys for your input.

              The query now works. I removed and rebuilt the same process and ting! It works.

              BTW I am using LP.

              Gota love Java sometimes..