Assigned to field validation based on role
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-14-2024 11:30 AM - edited 09-14-2024 11:33 AM
Hello guys,
I have a requirement when a CIM task type is survey feedback and assigned to a any resolver group, then only users in that resolver group with the Survey Feedback role(resolver_group_manager) should show in assigned to field not all the users in that group should popup.
To Achieve this requirement I have created one script Include and used it in reference qualifier to filter the assigned to users based on the role but it is not working.
Script Include -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2024 10:35 AM
Made all the required changes in the script and reference qualifier still it's not working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2024 10:50 AM - edited 09-15-2024 10:57 AM
Did u put logs?? Can you share screenshot of it
Also check in user roles table how many records available with required role and what is the count from logs also ?
Please check encodedQuery() in script include it should be "user.active=true^role.name=fmg_resolver_group_manager"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2024 11:11 AM
Hi @Mani A , The script is working fine when I run it in background script but when I used it in reference qualifier its not working maybe it is due to the application scope my current table is sn_cim_task so I created script include for the same table amd also added dictionary override reference qualifier for the same table but still its not working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2024 11:18 AM - edited 09-15-2024 11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2024 09:32 PM - edited 09-15-2024 09:49 PM
If assigned to user having survey feedback role then that script should work..
Now you are again changing requirement that if assignment group changes user will also change.
I also provided changing of assignment group logic then based on assigned to users will be prefilled if they having survey feedback role. But you said later only requirement was only assigned to user with one role
Please accept my solution and helpful if it works for initial requirement. Then we can work on Second use case