So I have the following code to determine my Section access for an Application, however it is not working as intended.
If I set the custom property to "ALL" in the QMC is is correctly recognized and changed to a *, however if ACCESS = USER it shows as "Access Denied" when they try to login,if the ACCESS = ADMIN it works as intended.
LIB CONNECT TO 'PostgreSQL_localhost';
[UserSecurity]:
LOAD Upper(Name) as ACCESS, Upper(UserDirectory & '\' & UserId) as USERID, If(Upper(Value)='ALL','*',Upper(Value)) as REDUCTION;
SQL Select "T"."Name", "U"."UserId", "U"."UserDirectory", "V"."Value"
From "public"."Users" "U"
inner join "public"."TagUsers" "TH" on "U"."ID" = "TH"."User_ID"
inner join "public"."Tags" "T" on "TH"."Tag_ID" = "T"."ID"
inner join "public"."CustomPropertyValues" "V" on "U"."ID" = "V"."User_ID" ;
Section Access;
Load
ACCESS,
USERID,
REDUCTION
Resident UserSecurity;
Section Application;