Hi, instead of taking question choices, can I directly pass the values of list collector from alm_hardware table and use it in the multi-row variable set?
Hi Guna, are the list collector field values static across the alm_hardware table? If so, then yes, those are typically persisted in the sys_choice table, so it would be a matter of querying against that table with the proper conditions and populating the result set into the MRVS, alternatively using the appropriate reference qualifier on a reference field that is one of the MRVS fields, if you want to provide the requester the ability to create manual entries in the MRVS table. Hope this answers the question. Let me know.
Hey Moody, Thanks for the video, So are we completely building Multi row on addition or removal of choice from the list collector .....Is there any possibility on Multi row to have the following functionality where there would an option to select a group and in another column we need to have an option to multi select users on each row in multi row variable set .. The target is to be able to remove multiple users from different groups on a single submission of the request.
Hi Kalyan, unfortunately list collector type variables cannot be part of a multi-row variable set. That is one limitation of multi-row variable sets. You would probably need to implement a custom widget and use it as a macro to do this. I've only ever implemented a solution to update the memberships of one group at a time per submission, which is relatively easy with the combination of a Reference variable to the sys_user_group table, in conjunction with a list collector variable for the memberships.
Thanks, it was too helpful for my client’s requirement😊
hello if u have that code , please share .
Amazing Content! Thanks.
Hi Michael, can you share the link to the code again? Your github repo is only xml files, but no JS. Thanks in advance.
Hi, instead of taking question choices, can I directly pass the values of list collector from alm_hardware table and use it in the multi-row variable set?
Hi Guna, are the list collector field values static across the alm_hardware table? If so, then yes, those are typically persisted in the sys_choice table, so it would be a matter of querying against that table with the proper conditions and populating the result set into the MRVS, alternatively using the appropriate reference qualifier on a reference field that is one of the MRVS fields, if you want to provide the requester the ability to create manual entries in the MRVS table. Hope this answers the question. Let me know.
Hey Moody, Thanks for the video, So are we completely building Multi row on addition or removal of choice from the list collector .....Is there any possibility on Multi row to have the following functionality where there would an option to select a group and in another column we need to have an option to multi select users on each row in multi row variable set .. The target is to be able to remove multiple users from different groups on a single submission of the request.
Hi Kalyan, unfortunately list collector type variables cannot be part of a multi-row variable set. That is one limitation of multi-row variable sets. You would probably need to implement a custom widget and use it as a macro to do this. I've only ever implemented a solution to update the memberships of one group at a time per submission, which is relatively easy with the combination of a Reference variable to the sys_user_group table, in conjunction with a list collector variable for the memberships.
@@moodycoda4230 ok thanks Moody..
Hi, We are unable to access the github code
any one code please , i am unable to get the code
Where can i access this code snippet?
All code can be found in this repository: github.com/mmoody1977G/sharing/tree/Share01
Font too small