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))
This topic has been locked.
1 reply Latest Post - 2013-02-14T19:40:10Z by SystemAdmin
Pinned topic Max18.104.22.168 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 PostsACCEPTED ANSWER
Re: Max22.214.171.124 Need to restrict access to Labor in the Actual tab of WOTRACK2013-02-14T19:40:10Z in response to npyeThis might work:
:LABORID IN (SELECT PERSONGROUPTEAM.RESPPARTY
WHERE PERSONGROUPTEAM.PERSONGROUP IN (SELECT PERSONGROUPTEAM.PERSONGROUP
WHERE PERSONGROUPTEAM.RESPPARTY = &USERID&))