Has anyone ever created a query for Security Groups? I need to pull the security groups for an application. If I were smarter or more experienced, I would have created a Group Type of System to enter the system abbreviation for the security group when I first created the application. In that way, I could have used the a!groupsByType() function. The only way to do that now, is to create all new security groups and go through all of the application objects to reassign the security groups for all applications!! :(
I created an expression rule to pull all of the custom security groups. It returns all of the custom security groups from all of the applications when I am looking for one application. The data is returned with type List of Variant. It seems to me that there should be a way to filter the data returned to see if the name contains the application abbreviation I am looking for. I'm stuck on how to do that.
a!groupsByType(cons!PMSO_CustomGroupType).data
I set the output to a local variable in the expression rule and tried several types of queries. No joy there either. I kept getting different error codes. I couldn't get the query structured correctly.
If someone could point me in the right direction, I would appreciate it.
Discussion posts and replies are publicly visible
What do you try to achieve?
I go a different route. Each group has an "All Groups" group, holding all the groups of an app. Then, I could create a new group with a membership rule to add all these groups by name.
I could not find the "All Groups" group. So I made one and put in just the Groups I wanted the User to be able to select. I use the function groupMembers() to pull the groups.
local!groups: a!groupMembers( group: cons!PMSO_AllGroups, direct: true, memberType: "GROUP", pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data,
This works to a point. I am getting all the groups that I want the user to select from into a local variable that is a list of groups. This is what I get in the Local Variable.
The next step is to get it to work in a dropdownField(). This is the the JSON for that.
a!dropdownField( choiceLabels: local!groups, choiceValues: local!groups, label: "Security Group", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", saveInto: {}, searchDisplay: "AUTO", validations: {} )
This is what I get in the dropdown.
How do I get the name? It seems like I need to convert the List of Groups to List of Text??
Use another local variable, populated using a foreach() and the group() function to get the names.
I used the getgroupnames() function. IT WORKS!!! Thanks again Stefan!!!
local!groupNames: a!forEach( items: local!groups, expression: getgroupnames(fv!item) ),
You are welcome :-)
Nothing wrong with getgroupnames(), but it comes from a plugin. If you want to minimize plugin usage, the built-in function group() would work just as well for your use case.
a!localVariables( local!groups: a!groupMembers( group: cons!GT_GRP_USERS, memberType: "GROUP", direct: true, pagingInfo: a!pagingInfo(1, 10) ).data, local!groupNames: a!forEach( items: local!groups, expression: group(fv!item, "groupName") ), local!selected, { a!dropdownField( choiceLabels: local!groupNames, choiceValues: local!groupNames, value: local!selected, saveInto: local!selected, placeholder: "-- Select a Group --" ) } )