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

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans