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 Send Private Message
Posts: 17
Basic Member

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
Send Private Message
Posts: 3351
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
Deleted User
New Member Send Private Message
Posts: 0
New Member
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
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 460
Veteran Member

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 Send Private Message
Posts: 17
Basic Member
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..