• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 95 subscribers
  • Views 124 views
  • Users 0 members are here
Options
Related

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

pavithra
7 days ago

Hello,

v9.1

I have created a front end employee onboarding form using CCC_Employee_Edit module.
A dropdown is created using column(Person table -> CustomProperty10) which has some defined list of values.

Building1
Building2
Building3
Building4
Building5

Scenario:
1) When requester from location: Europe logs in, the dropdown should have only two values Building1 and Building2.
2) When requester from location: India logs in, the dropdown should have only two values Building3 and Building4.

I have tried using the where of 'Permitted value' for the particular value but it doesn't work. Could someone look into this and help me solve this problem ?

Thank you in Advance

Pavithra

Parents Reply
  • 0 1 day ago in reply to Hanno Bunjes

    Hi  ,

    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

Children
No Data