I need to restrict what is displayed when a user is in WOTRACK, Actual, Labor and clicks Select Labor. I want to restrict based on the current user &USERID& being in a common persongroup persongroupteam with the Labor that is to be displayed. I keep getting errors.
I am not good at SQL.
Here is my lastest attempt.
LABORID not in ((:&PERSONID& in PERSONGROUPTEAM.RESPPARTYGROUP) AND ( LABOR.PERSONID in PERSONGROUPTEAM.RESPPARTYGROUP))
Pinned topic Max184.108.40.206 Need to restrict access to Labor in the Actual tab of WOTRACK
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-14T19:40:10Z at 2013-02-14T19:40:10Z by SystemAdmin
SystemAdmin 110000D4XK5842 Posts
Re: Max220.127.116.11 Need to restrict access to Labor in the Actual tab of WOTRACK2013-02-14T19:40:10ZThis is the accepted answer. This is the accepted answer.This might work:
:LABORID IN (SELECT PERSONGROUPTEAM.RESPPARTY
WHERE PERSONGROUPTEAM.PERSONGROUP IN (SELECT PERSONGROUPTEAM.PERSONGROUP
WHERE PERSONGROUPTEAM.RESPPARTY = &USERID&))