All Position in a Process Level

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
upasana
Basic Member Send Private Message
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 Send Private Message
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