All Position in a Process Level

 1 Replies
 2 Subscribed to this topic
 78 Subscribed to this forum
Sort:
Author
Messages


upasana











Basic Member



Posts: 20




Basic Member



    Hello,

    Could anyone please help me in writing a query to provide positions with their respective Job Codes in a Process Level using Lawson AddIns. I need this information for various clients.

    Thanks in Advance
    Upasana Mehra


    Woozy











    Veteran Member



    Posts: 709




    Veteran Member



      Just for clarification, are you just wanting to get a list of the positions sorted by the paposition.process-level (i.e. default process-level for the position), or are you wanting a list of positions that are assigned to employees, sorted by employee.process-level (actual employee process-levels)?

      If the former, then this should get you close:

      http://server:port/servlet/Router/Data/Erp?KEYUSAGE=PARAM&MAX=600&OUT=CSV&NOHEADER=TRUE&DELIM=%09&INDEX=POSSET1&NEXT=TRUE&PROD=prodline&FIELD=POSITION%3BJOB-CODE%3BPROCESS-LEVEL&FILE=PAPOSITION&KEY=1

      If the latter, then I think you'd want to do something like this:

       

      http://server:port/servlet/Router/Data/Erp?PROD=prodline&FILE=EMPLOYEE&INDEX=EMPSET1&KEY=1&FIELD=POSITION;JOB%2DCODE;PROCESS%2DLEVEL&OUT=CSV&DELIM=%09&NOHEADER=TRUE&NEXT=TRUE&MAX=600

       

      If you are looking for the later, but with only unique positions within each process-level, then I don't think you can do this with add-ins, though it should be easy enough to filter within Excel.  Of course, there are other folks who might have suggestions about this.

      Kelly Meade
      J. R. Simplot Company
      Boise, ID