HR Index EMPSET3 Report Issue

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
mark.cook
Veteran Member
Posts: 444
Veteran Member

    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: 3353
      That issue sounds familiar.
      Thanks for using the LawsonGuru.com forums!
      John