HR Index EMPSET3 Report Issue

 1 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
mark.cook
Veteran Member
Posts: 444
Veteran Member
New Poster
New Poster
Congrats on posting!

I am using the following query in OLEDB to pull data for a report of HR demographic data. I have information in a user field (user field #98), when I attach the index EMPSET3 it is pulling data from another user field. Without the index the report is pulling the proper data, just running a little longer than I would like. Has anyone seen this issue before?


dmeROD=PROD&FILE=EMPLOYEE&FIELD=EMP-STATUS;EMPLOYEE;FULL-NAME;FTE-TOTAL;STAND-HOURS;EXEMPT-EMP;SHIFT;SUPERVISOR;SUPERVISOR-IND;COMPANY;DEPARTMENT;USER-FIELDS.A-FIELD;USER-FIELDS.FIELD-KEY;POSITION.DESCRIPTION;EMP-STATUS.DESCRIPTION;SUPERVISOR.FULL-NAME;SUPERVISOR.LABEL-NAME-1;SUPERVISOR.EMPLOYEE;SUPERVISOR.COMPANY;SUPERVISOR.DESCRIPTION;DEPARTMENT.NAME&SELECT=EMP-STATUS%3C%3D96%26USER-FIELDS.FIELD-KEY=98&INDEX=EMPSET3&KEY=1000;6000

John Henley
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
That issue sounds familiar.
Thanks for using the LawsonGuru.com forums!
John