Hi community,
In our application there is a need of creating 800+ groups. To avoid that we started maintaining group information in table. In our database table we have user id, group id and the branch name. Based on the branch and group id we are retrieving the list of users and assigning tasks to them. The issue is when a task is assigned for users of branch1 and group 1 and then later when I add new member in the table, the new member is not one of the assignees of the task. The client is not okay with creating 800+ groups. Anyone have solution for this?
Discussion posts and replies are publicly visible
You will face an issue if you're intending to promote the Groups and the GroupIds (in your database) between environments, as the Group Id will not be the same when you push from DEV to TEST and TEST to PROD. Unless you're prepared to set up all 800 Groups in each environment by hand this is not a great design pattern.
Stewart Burchell I agree with you. Its a growing company in future the groups will increase for sure.