Requirement is to hide assignment groups from drop down if requestor is a member of the group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2024 01:49 AM
Requirement is to hide assignment groups from drop down if requestor is a member of the group in catalog item.
Example i have a ABC variable which is referenced to sys_user_group table and will have active groups in drop down.
I have a variable XYZ where we need to give user name who need access, so when person name is given on ABC drop down only group which he is not member should be visible.
ABC is a variable in multirow and XYZ is single row variable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2024 02:56 AM
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2024 08:41 PM
Hi @sravya03
Can you confirm that ABC is a Multiple Row Variable Set (MRVS)? and if so, please give some insight into why it was decided to be that type?
Cheers,
Tai Vu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2024 08:09 AM
yes, because that is the requirement from client.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2024 09:48 PM
Hi @sravya03
If there aren't any specific reasons for using MRVS, you might want to suggest to the client to consider the List Collector variable type instead. It's easier to build and maintain in the long run.
However, if they insist on using MRVS, things become a bit more complex. We'll need to use session data to store the selected Requestor and then retrieve it in the reference qualifier to build the query. Additionally, we'll need to follow the same steps again in order to filter out the selected Groups.
Cheers,
Tai Vu