Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

How to show only specific values in ENUM field?

Posted on by

Hi all,

Through EDS, I am able to restrict a user from seeing for instance all vendors of vendor group X an Y, but he will be able to see the vendors belonging to group IC. I have manged to do this via a query (middle picture) with datasource "VendGroup" and range "VendGroup" with value IC (right picture). I have then coupled this query to a policy (left picture) with two constrained tables. When I couple this to a user, the user only sees vendors in the VendTable and PurchTable which belong to VendorGroup IC.

When i do exactly the same thing but only on a ENUM field, the values are not filtered, I find this very strange... I read this is because ENUM is not table based.

Can I filter/restrict ENUM values per user without code adjustments, so only via duties, privileges, queries and policies etc? Do you have any suggestions?

Best regards,

Luuk Schulte

Categories:
  • Luuk Schulte Profile Picture
    Luuk Schulte on at
    RE: How to show only specific values in ENUM field?

    *Bump*

  • Luuk Schulte Profile Picture
    Luuk Schulte on at
    RE: How to show only specific values in ENUM field?

    Hi,

    Thank you for your answer.

    I have tried using the label like this:

    I have also tried using the index nr. and the Name but somehow, it does not work.

    Regard,

    Luuk

  • Bilal Issa Profile Picture
    Bilal Issa 4,370 on at
    RE: How to show only specific values in ENUM field?

    Hi ,

    on the range value you need to put the label of the enum element not the name.

    Regards,

    Bilal

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,768 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,985 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans