Defaut user team: global setting and mass update

One of our customers would like to go from an "open access" model to a team based model. 

Is is possible to globally set the default team for new records or mass-update users' default teams? 

The field does not appear in the mass update sub panel. 

Any suggestion other than a good ol' SQL query? 

Cheers,

Damien

PS : Sugar ENT 7.9

Parents Reply Children
  • It depends on your skills.

    There is no user friendly interface to do so.

    The default teams assigned to a user is saved in the field "team_set_id" of own users table. So if you know the team_set_id to be configured on each user then you just need to write down a sql query, like:

    UPDATE users SET team_set_id = 'foo' WHERE user_name = 'bar';

    If the default teams of a user is defined by a single team then the team_set_id is the own team_id.

    In another hand if you don't know the team_set_id but you know the teams to be set as default for each user then you would need to write down a php script which will identify the team_set_id given a set of teams and then update the table as well.

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada