Employee Definition - Filter Users by Role

melike_ciloglu
Tera Contributor

Hello,

I want my employee definition to be based on a role. But when I create the filter as in the screenshot, filter does not take effect, instead employee profiles for all users in the sys_user table is created.

 

Screenshot 2024-01-08 at 11.02.18.png

 

I assumed that was due to the lack of index on the Roles column of the sys_user table. So I tried to set up an index for the mentioned column. But i received the following error:

ALTER TABLE `tmp_s1874890249r`ADD INDEX (`roles`) /* dev222866002, gs:glide.scheduler.worker.6, tx:566695669323311050da7fbcebba10ce */ Syntax Error or Access Rule Violation detected by database ((conn=104605) Key column 'roles' doesn't exist in table)

 

Is there a workaround for this? How can I create employee definition dependant on the role?

 

Thank you in advance!

1 REPLY 1

OCT
Tera Contributor

Hi,

 

I had this exact issue, and realised there was an update available for the Employee Profile plugin on my instance (and subsequently some other Employee Centre plugins which it updated too). Updating the plugins solved the issue for me.

 

Kind regards,

 

OT