Hello,

I need to create sharing rules for opportunities using the account country as a criterion. I tried doing that by simply creating a new field and using formula to populate the field with the account country, but sharing rules can't use fields with formulas as criteria.

A possible alternative is to populate my custom text field and populate it with an Apex trigger. I have created a trigger which does exactly what I need and now I need to deploy it. Since I have limited experience in Apex, I need some help to create the test required for this field.

Thanks for your help!

trigger AccountCountry on Opportunity (before insert, before update){
Set<Id> ownerIds = new Set<Id>();
Set<Id> AccountIds = new Set<Id>();
for (Opportunity op : Trigger.new) {  
ownerIds.add(op.OwnerId);  
accountIds.add(op.AccountId);
}

Map<Id, Account> accountMap = new Map<Id, Account>([SELECT BillingCountry FROM Account WHERE Id IN :accountIds]);
String AccountCountryName;
for (Opportunity op : Trigger.new) { 

// add the BillingCountry 
AccountCountryName = accountMap.get(op.AccountId).BillingCountry; 

// set the name :-) 

op.Account_Country__c = AccountCountryName;}     

static testMethod void testAccountCountry() {

??

}