Employee Definition - Filter Users by Role
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2024 02:14 AM
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.
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-30-2024 07:18 AM
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