• State Suggested Answer
  • Locked Locked
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 5126 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Web Designer condition Org table

MAS77
over 7 years ago

Hi, I imported the list of functions (example director, webdesigner, engineer,webmaster ...) in the table Org in which i imported also roles (Administrator, helpdesk, CISO ...). So iIhave 2 OrgRoots : functions and roles.

I would like to add a display condition in the web designer : when a manager declares a new joiner and wants to specify the function (from Org table), only entries whose OrgRoots = functions must be displayed. So I Added in the condition field of the attribute UID_Org this : uid_org in (select uid_org from org o where o.uid_OrgRoot = '6fa34df5-a1a8-4a78-8817-f18192cf29a0') knowing that a1e29df0-8e81-4e80-b93f-fe9359dc3c10 is the Uid of the root functions :

 

 

but unfortunatelly it does not work and getthe error below : 

 

can you please confirm that this is the right approach ? 

Parents
  • 0 over 7 years ago

    Thank you very much ! I managed to compile the portal and it works. the only negative point is that "Roles IAM" still appear even though it's empty. would it be possible to remove it and keep only "Fonction " ? 

     

Reply
  • 0 over 7 years ago

    Thank you very much ! I managed to compile the portal and it works. the only negative point is that "Roles IAM" still appear even though it's empty. would it be possible to remove it and keep only "Fonction " ? 

     

Children
No Data