I have a table I'm setting up in SQL Server to map request types to the grou

scotts over 10 years ago

I have a table I'm setting up in SQL Server to map request types to the group that does the work. I plan to use this to dynamicaly assign a request by request type to the correct group.

Type Group
reports Business Reporting
File work Customer Targeting

When a request comes in as reports, I want to lookup Business Reporting and assign the following group task to that group.
My question is this, how do I find the group ID for any given group so I can set up my lookup table properly?
Thanks for any help,...

Discussion posts and replies are publicly visible

0 David Williams over 10 years ago

I hold the group ID in the table for the mapping when doing things like this. You can then have a group table if you wanted and a group creation and process mapping process to maintain it all.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aleksi White
Appian Employee
over 10 years ago

You can use the getgroupuuid() function to return the UUID for the given group
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel