Hitting Soql Governor Limit in my method

Question

I've to test my sharing code. In my test classs I have to test if user1 creates record then it is visible to all user(400)..for that I have to get all manager id(399 user) based on user1 id...

example user1----->user2(manager of user1)---->user(manager of user2)------>user3(manager of user3)........---->user400(manager of user 399)

Code Is:

public class Parrent{
     public static List<Id> getAll(List<Id> ids){
        List<Id> mIds = new List<Id>();
        for(user u : [select ManagerId from user where id in:ids and ManagerId!=null])
            mIds.add(u.ManagerId); 
       if(mIds.size()>0)
            mIds.addAll(getAll(mIds));
       return mIds;
      }
}

If this code gets all manager id based on the user id

Thanks in advance
Karthick

Answer 1

In most companies the number of "levels" of management won't exceed 5 or 10. (Think about how many levels of management you need to go from you to the boss of your company.) So why is your test trying to set up (presumably) more than 100 levels and so causing the SOQL governor limit to be hit?

Perhaps your test should have say 100 users each reporting to 10 managers who each report to 1 manager?

(It is possible to use less queries as the answer to your other question here explains but that is probably not necessary here Getting All Manager Id.)

Answer 2

You just need to bulkify your query, and avoid to use query inside a loop. See this :

• SFDC Official solutions.

• SFDC99 Solution