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
I usually end up exposing the Groups via an API and creating a Service Backed Record Type that consumes the API. Much easier to query then. I think I'll write up a small blog post on this.
Apologies in advance for bumping this thread, finally got around to writing up a blog post on how to query groups using Record Types for those who are interested: https://blog.appiandevs.io/003-a-better-way-to-work-with-groups-in-appian-part-1/
Hi Mathieu Drouin , I am not able to access the blog. It is giving 404.
Fixed - I updated the title since it will be a multi part series!