M
matman
Guest
Hello, I'm using the formula field in a view to select only a group of realtors in my system. Realtors are coupled to groups, and users that can log in are coupled to these groups. I want realtors to be only visible to users that are in the group that is assigned to this realtor. To do this I'm using this code in the formula: R115171597 IN ( SELECT id, name FROM $GROUP WHERE R2354869 = {!#CURR_USER.id} ) This however gives me an error when open this view: Error: Error in SQL Query ListView=108173991 SELECT COUNT(A.OBJ_ID) FROM RB_OBJ_DATA A WHERE A.OBJ_DEF_ID=108173935 AND (A.INTG9 IN ( SELECT A.OBJ_ID, A.OBJ_NAME FROM $GROUP WHERE R2354869 = 108173687 ) ) Table 'rb_cust4.$group' doesn't exist What am I doing wrong? Thanks in advance
Continue reading...
Continue reading...