Employees authorized to add and edit employees global config parameter

Hello Experts,


I have attempted to customize a global config parameter in Web Designer for 'Employees authorized to add and edit employees', by default it is an empty string and I have set it to a simple query:

"uid_person in (select UID_Person
                from person
                where Lower(CustomProperty09) = 'staff' Or Lower(CustomProperty09) = 'faculty')"

based on my requirement where any employee in the organization should be able to request to create an account through Web Portal.

However, my custom query doesn't seem to have any effect, even if I just limit it to one specific person and limit it by PersonnelNumber. It seems to have some kind of hard coded behavior to where as long as logged in person is either a manager or department manager they can add user accounts.

My question is has anyone figured out a way to change it, do I need to modify something else in conjunction with a query I am already modifying. I am just confused what is the purpose of this config parameter if it is truly a hard coded behavior in Web Designer?

Thanks,

Sergei Shvets

Parents
  • I have tried changing my query to 1=1 just to eliminate any sql mistakes, I haven't added anyone to that application role, I will try adding an account manually just to see if that will resolve the issue, but users that are managers or department managers don't have that role either and they are able to add and edit employees. Also, to note, there is no issue with editing users, if I assign an account to an employee they are able to edit it with no issue and button to 'Add Employees' becomes active in Web Portal. The problem is users that are not managers need to be able to add contractor accounts and no matter what I do to the query button to 'Add Employees' stays inactive until a user becomes a manager.


    Thanks,

    Sergei Shvets

Reply
  • I have tried changing my query to 1=1 just to eliminate any sql mistakes, I haven't added anyone to that application role, I will try adding an account manually just to see if that will resolve the issue, but users that are managers or department managers don't have that role either and they are able to add and edit employees. Also, to note, there is no issue with editing users, if I assign an account to an employee they are able to edit it with no issue and button to 'Add Employees' becomes active in Web Portal. The problem is users that are not managers need to be able to add contractor accounts and no matter what I do to the query button to 'Add Employees' stays inactive until a user becomes a manager.


    Thanks,

    Sergei Shvets

Children
No Data