How to show only specific values in ENUM field?

(0) Share

Report

Posted on by Luuk Schulte

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

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Bilal Issa 4,370 on at

Like (1)

Report
Copy link

Link copied!

Hi ,

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

Regards,

Bilal

Was this reply helpful? Yes No
Luuk Schulte 9 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Luuk Schulte 9 on at

Like (0)

Report
Copy link

Link copied!

*Bump*

Was this reply helpful? Yes No