Cannot set inbound group email for non-Administrator users

pstevens · 5 July 2023 16:28

@pgr YES!

The whole implementation of Group Email was a bit of a mess.

Group email accounts do not get marked as “is_group”= 1 in the database so they are not selected properly throughout SuiteCRM (I fixed this).
Subscriptions do not get added to users because it only runs when “is_group”=1 (I fixed this). You’ll also have to re-save the accounts once the patch is applied to update the subscriptions and the “is_group”
Only admins can see group accounts because the filter of available accounts do not take into account subscriptions but only if the user is an admin. (I fixed this) Now the user can see folders subscribed to AND that he/she has access to.
The JS that generates the list in the user preferences cannot handle a second array of group accounts in the JSON list, so they cannot be selected for viewing in the selection list. (I fixed this). (this one is nasty in the cache and difficult to fix, you’ll have to R&R all the js files after the patch)
Deleted group accounts get shown too! There is no mechanism when an email account is deleted to mark it as deleted =1. (I fixed this)

Long story short, there are a bunch of fixes that need to be applied to make they whole system of Group Emails work.

All the required fixes are listed here (there are about 4-5 changes that need to be made to various files):

github.com/salesagility/SuiteCRM-Core

Folder Selection for Group Inbound email Folders not working in user Profile

opened 03:23PM - 02 Jun 23 UTC

pstevens71

Type: Bug Priority:Important Area: Emails Status: Fix Proposed

#### Issue There are a bunch of issues surrounding group email accounts. I…'ve proposed some fixes already. First, group email accounts do not get marked as "is_group" = 1 currently. I proposed a fix in 7.12 branch for this that should still be applicable in Core. Also, when a group email is deleted, the folders do no get marked as "deleted=1". I have proposed a fix for this as well. However, when group folders are correctly marked in "folders" in the database as is_group =1 they no longer appear on the list of folders in users and admin folder selection in user profile. When they are NOT marked as "is_group" they go into the JSON array that makes the pick list as "userFolders" like this... `"userFolders": [{ "id": "", "name": "--None--", "has_child": 0, "is_group": 0, "selected": false }, { "id": "5d269064-84eb-a6cd-bf75-6478c44c1bea", "name": "INBOX (replypersonal)", "has_child": "1", "is_group": "0", "is_dynamic": "1", "folder_type": "inbound", "created_by": "1", "deleted": "0",................................` When properly marked they go into the JSON like this: `"groupFolders": [{ "id": "", "name": "--None--", "has_child": 0, "is_group": 1, "selected": false, "origName": "" }, { "id": "e0e86af8-fac6-8f28-4c90-6478d52d1153", "name": "INBOX (reply2)", "has_child": "1", "is_group": "1", "is_dynamic": "1", "folder_type": "inbound", "created_by": "1",.......................` Currently trying to track down exactly which JS is responsible for the list in: \modules\Emails\javascript\ajax.js AND \modules\Emails\javascript\EmailUI.js Finally, the security group filter is not being properly applied to the list of available folders. #### Expected Behavior A list of both personal and accessible group accounts should appear in the list. Once they appear in the list, when the list saves it will update the folders_subscriptions table in the database with the user ID and the folder ID to manage subscriptions. #### Actual Behavior Only a list of userFolders appear in the list. #### Possible Fix Modify the JS in settingsFolderRefresh: function (o) and probably another one I haven't found yet, to populate the list initially (which I haven't found yet). #### Steps to Reproduce 1. Create a group email 2. Make sure it's marked as "is_group" = 1 in the inbound email table in the database 3.Make sure related folders are marked as "is_group"=1 in the folders table in the database 4. Go to a profile as admin (or user) and try and add the folder to subscriptions. It's not available. #### Context #### Your Environment * SuiteCRM Version used: 7.13 (issue in 7.12 as well, I'm testing both). * * Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): * Environment name and version (e.g. MySQL, PHP 7): * Operating System and version (e.g Ubuntu 16.04):

Also, don’t forget to add the user and the group account to the same security group. If you check out my super long post on this one, there is a video demonstrating 1. It not working and 2. working after the patches and how it works.