Since an update to version 5.2.2.0
There is a problem with the relationship-base permissions. Whenever I use any of them the list view does not load, just gives "Error in SQL Query ListView=18338"
Following error code shows up in de system logs;
Error in SQL Query ListView=18338
SELECT COUNT(*) FROM (SELECT A.OBJ_ID FROM RB_OBJ_DATA A LEFT OUTER JOIN RB_RELATIONSHIP Q ON Q.OBJ1_ID=A.OBJ_ID WHERE A.OBJ_DEF_ID=17441 AND (( A.CREATED_BY=36015 ) OR (Q.OBJ2_ID=36015 AND Q.RELATIONSHIP_ID=17954 AND )) )
The last bit seems the problem there is nothing following the last AND.
Anything I can do, besides making views circumventing this issue?
5.2.3.0 was released for this very issue. Check here www.progress.com/.../release-5.2.3-private-cloud
The issue occurs when non-admin users visit views that have relationship based permissions. Please upgrade to 5.2.3 to resolve the issue.