Unable to filter front end dropdown values based on user's location

Hi,

Are you working with a WebDesigner component?

Hi Hanno Bunjes ,

No, not with a component.

Using Web Designer -> CCC_Employee_Edit (module) -> VI_Employee_MasterData_LocalityAttributes -> Building(Single property) -> Multiple Values (Permitted Values)

Thanks,

The "permitted values" each have a condition that you can use to disable the options that you don't want to show for a user.

Hi Hanno Bunjes ,

I also have the exact same query.

For the "Permitted value", there are 3 attributes:

-Identifier

-Where Clause

-Display

I tried using the where Clause but none of them are seems working

1) For permanently making the value disable or to hide it :

whereClause False

whereClause 1=0

2) For hiding the value for a specific user, not working

Exists(
"Person",
SqlAnd(
SqlCompareUid("UID_Person", GetUser()),
Format("UID_Person in (select piae.UID_Person from personinaerole piae join AERole ae on ae.UID_AERole = piae.uid_AERole where ae.FullPath in (
'Identity Management\Employees\Administrators\Department XXX'))")
)
)

Could you please check and suggest how to hide value from a particular logged in user