function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ashish2802Ashish2802 

Update Role on Partner User using apex for bulk data upload

Hello, I have a requirement to update roles on partner user record using trigger where the user records will be created using bulk upload process.
I am stuck with the Role id assignment as it requires querying the UserRoleID using the Role Name based on conditions.

Below is my code snippet.

    @future
    public static void updatePartnerUserRoles(Set<Id> userIds){
        String roleName = '';
        List<User> updatedUsers = new List<User>();
        for(User u : [Select Id, Contact.Agent_Type__c,  Account.Name From User Where Id IN : userIds]){
            if(u.Contact.Agent_Type__c == 'Admin'){
                roleName = u.Account.Name + ' Partner Manager';
                u.UserRoleId = [Select Id From UserRole Where Name = :roleName LIMIT 1].Id;
                updatedUsers.add(u);
            }
            else if(u.Contact.Agent_Type__c == 'Non-Admin'){
                roleName = u.Account.Name + ' Partner User';
                u.UserRoleId = [Select Id From UserRole Where Name = :roleName LIMIT 1].Id;
                updatedUsers.add(u);
            }
       }
       Database.update(updatedUsers); 
    }
   
The code snippet has a SOQL query inside for Loop and I am not able to figure out an alternative solution.
 
Pradeep SinghPradeep Singh
Hi, you can refer below code:- 
@future
public static void updatePartnerUserRoles(Set<Id> userIds){
	String roleName = '';
	Map<string,id> roleMap = new map<string,id>();
	for(Role r : [SELECT Id, Name FROM UserRole]){
		roleMap.put(r.name,r.id);
	}
	
	if(roleMap.size() > 0){
		List<User> updatedUsers = new List<User>();
		for(User u : [Select Id, Contact.Agent_Type__c,  Account.Name From User Where Id IN : userIds]){
			if(u.Contact.Agent_Type__c == 'Admin'){
				roleName = u.Account.Name + ' Partner Manager';
				if(roleMap.containskey(roleName)){
					u.UserRoleId = roleMap.get(rolename);
					updatedUsers.add(u);
				}
			}
			else if(u.Contact.Agent_Type__c == 'Non-Admin'){
				roleName = u.Account.Name + ' Partner User';
				if(roleMap.containskey(roleName)){
					u.UserRoleId = roleMap.get(rolename);
					updatedUsers.add(u);
				}
			}
	   }
	   Database.update(updatedUsers); 
   }
}