Apex Code Development You need to sign in to do that
Don't have an account?
Lloyd Silver Failure Message: "System.QueryException: line 1:832 no viable alternative at character ' '"
I had someone edit a class and unfortunately they've gone missing and I'm getting an error when deploying:
Failure Message: "System.QueryException: line 1:832 no viable alternative at character ' '", Failure Stack Trace: "Class.EstimateCommList.searchEsti: line 266, column 1 Class.TestEstimateCommListClass.DoListTest: line 114, column 1"
I'd appreciate some help in fixing this. I've attached the code for both classes below.
Thanks!
Failure Message: "System.QueryException: line 1:832 no viable alternative at character ' '", Failure Stack Trace: "Class.EstimateCommList.searchEsti: line 266, column 1 Class.TestEstimateCommListClass.DoListTest: line 114, column 1"
I'd appreciate some help in fixing this. I've attached the code for both classes below.
Thanks!
public without sharing class EstimateCommList {
public list<Data_Estimated_Comm> LDEC {get;set;}
public User user;
public String curruserid;
public String CId;
public String sort_by {get;set;}
public Date from_date {get;set;}
public Date to_date {get;set;}
public string fromdate{get; set;}
public string todate{get; set;}
public map<string,List<string>> JuniorContactsMap;
public String User_Selection{get;set;}
public Boolean IsEmptyList{get;set;}
public List<string> cLst;
public Boolean hasAgencyAccess{get;set;}
public Boolean IsAgency{get;set;}
public map<string,string> AccountMap;
public Date StartingDate;
public EstimateCommList() {
curruserid = UserInfo.getUserId();
system.debug('curruserid:'+curruserid);
//get user record with contact__c
user = [Select u.Name, u.Id, u.ContactId,u.contact.accountid,u.contact.Agency_Commission_Access__c From User u where u.Id =:curruserid];
CId = user.ContactId;
if(user.contact.Agency_Commission_Access__c==true){
hasAgencyAccess=true;
}
else{
hasAgencyAccess=false;
}
IsAgency=false;
if(test.isrunningtest()){
User_Selection=CId;
}
system.debug('CId:'+CId);
//Added for Datepicker variale convertion into date time.
fromdate=string.valueOf(string.valueOf(System.today().month()+'/'+System.today().day()+'/'+System.today().year()));
system.debug('@@@@@@@@@@'+fromdate);
todate= string.valueOf(System.today().addmonths(6).month()+'/'+System.today().addmonths(6).day()+'/'+System.today().addmonths(6).year());
system.debug('@@@@@@@@@@'+todate);
IsEmptyList=false;
system.debug('**************'+IsEmptyList);
JuniorContactsMap=new map<string,List<string>>();
for(contact g:[select id,name,ReportsToId from contact]){
if(JuniorContactsMap.containskey(g.ReportsToId)){
JuniorContactsMap.get(g.ReportsToId).add(g.id);
}
else{
list<string> temp=new List<string>();
temp.add(g.id);
JuniorContactsMap.put(g.ReportsToId,temp);
}
}
system.debug('################'+JuniorContactsMap);
cLst=new List<string>();
cLst.add(CId);
List<string> cLst1=new List<string>();
cLst1.add(CId);
List<string> TList=new List<string>();
TList.add('Test');
while(TList.size() >=1){
system.debug('^^^^^^^^^^^^^^^^^'+cLst1);
List<string> TempConList=Childcontacts(cLst1);
if(TempConList.size()>0){
cLst.addall(TempConList);
cLst1=TempConList;
}
else{
TList.remove(0);
}
}
system.debug('***************'+cLst);
StartingDate=date.newinstance(2014,7,1);
system.debug('######'+StartingDate);
list<Estimated_Commissions__c> LEC = [Select e.Valid_From__c, e.SystemModstamp, e.Name, e.LastModifiedDate,
e.LastModifiedById, e.LastActivityDate, e.IsDeleted, e.Insurance_Case__c, e.Insurance_Case__r.name,
e.Id, e.FYC_Rate__c, e.FYC_Amount__c, e.Excess_Commission_amount__c,
e.Excess_Commission_Rate__c, e.CreatedDate, e.CreatedById, e.Case_Split__c,
e.Agent__c, e.Agency__c , e.Agent__r.Name , e.Agency__r.Name,
e.Insurance_Case__r.Target_Premium__c, e.Insurance_Case__r.Product__r.Name,e.Insurance_Case__r.Submitted_Date__c,
e.Insurance_Case__r.Primary_Insured_or_Annuitant__r.Name, e.Insurance_Case__r.Premium_Mode__c,
e.Insurance_Case__r.Policy_Number__c,
e.Insurance_Case__r.Line_of_Business__c, e.Insurance_Case__r.Carrier__r.Name
From Estimated_Commissions__c e
where e.Agent__c =:CId AND e.Insurance_Case__r.Submitted_Date__c >=: StartingDate
order by CreatedDate desc limit 1000 ];
system.debug('LEC:'+LEC);
if(LDEC == null) LDEC = new list<Data_Estimated_Comm>{};
for ( Estimated_Commissions__c EC : LEC){
// Create a Data record and add it to the list
Data_Estimated_Comm DEC = new Data_Estimated_Comm();
DEC.Agency = EC.Agency__r.Name;
DEC.Agent = EC.Agent__r.Name;
DEC.Casesplit = EC.Case_Split__c;
DEC.ExcessCommAmt = EC.Excess_Commission_amount__c;
DEC.ExcessCommRate = EC.Excess_Commission_Rate__c;
DEC.FYCAmt = EC.FYC_Amount__c;
DEC.FYCRate = EC.FYC_Rate__c;
DEC.Insurance_Commission_Name = EC.Name;
DEC.PolicyNumber = EC.Insurance_Case__r.Policy_Number__c;
DEC.LineOfBusiness = EC.Insurance_Case__r.Line_of_Business__c;
DEC.Carrier = EC.Insurance_Case__r.Carrier__r.Name;
DEC.Product = EC.Insurance_Case__r.Product__r.Name;
DEC.Client = EC.Insurance_Case__r.Primary_Insured_or_Annuitant__r.Name;
DEC.PremiumMode = EC.Insurance_Case__r.Premium_Mode__c;
DEC.Premium = EC.Insurance_Case__r.Target_Premium__c;
DEC.Valid_From = EC.Valid_From__c;
//new changes
DEC.InsuranceCase= EC.Insurance_Case__c;
DEC.InsuranceCaseName= EC.Insurance_Case__r.Name;
LDEC.add(DEC);
}
}
public List<SelectOption> getSort() {
List<SelectOption> options1 = new List<SelectOption>();
options1.add(new SelectOption('Valid_From__c','Date'));
options1.add(new SelectOption('Agent__r.Name','Agent Name'));
options1.add(new SelectOption('Insurance_Case__r.Carrier__r.Name','Carrier'));
options1.add(new SelectOption('Insurance_Case__r.Line_of_Business__c','Line Of Business'));
options1.add(new SelectOption('Insurance_Case__r.Product__r.Name','Product'));
options1.add(new SelectOption('Insurance_Case__r.Policy_Number__c','Policy Number'));
options1.add(new SelectOption('Insurance_Case__r.Primary_Insured_or_Annuitant__r.Name','Client'));
options1.add(new SelectOption('Insurance_Case__r.Premium_Mode__c','Premium Mode'));
options1.add(new SelectOption('Insurance_Case__r.Target_Premium__c','Premium'));
options1.add(new SelectOption('FYC_Rate__c','FYC Rate'));
options1.add(new SelectOption('FYC_Amount__c','FYC Amount'));
options1.add(new SelectOption('Excess_Commission_Rate__c','Excess Rate'));
options1.add(new SelectOption('Excess_Commission_amount__c','Excess Amount'));
return options1;
}
//Method which will call each time for inner hierarchy of contacts
public List<string> Childcontacts(List<string> CurrentContactsIDList){
List<string> d=new List<string>();
for(string w:CurrentContactsIDList){
system.debug('%%%%%%%%%%%%%%%'+w+'-'+JuniorContactsMap.get(w));
if(JuniorContactsMap.containskey(w)){
for(string l:JuniorContactsMap.get(w)){
d.add(l);
}
}
}
return d;
}
//Method which will have all users list in hierarchy of user logged in
public List<SelectOption> getAllusers() {
List<SelectOption> options1 = new List<SelectOption>();
AccountMap=new MAp<string,string>();
integer i=0;
List<contact> mylst=[select id,name,accountid from contact where id IN:cLst];
for(contact w:[select id,name,accountid from contact where id IN:cLst]){
AccountMap.put(w.id,w.accountid);
if(w.id==CId){
contact q=mylst[0];
mylst[0]=mylst[i];
mylst[i]=q;
}
i++;
}
system.debug('###############'+AccountMap);
for(contact c:mylst){
options1.add(new SelectOption(c.id,c.name));
}
return options1;
}
public pagereference searchEsti() {
List<Estimated_Commissions__c> LEC = new List<Estimated_Commissions__c>{};
//New chanages as part of input date picker format changes
Datetime Dt1;
string Dt2;
Datetime Dt3;
string Dt4;
system.debug('##############'+fromdate+'-'+todate);
if(fromdate !=null && fromdate !=''){
List<string> a=fromdate.split('/');
Dt1=Datetime.newinstance(integer.valueOf(a[2]),integer.valueOf(a[0]),integer.valueOf(a[1]));
Dt2=Dt1.format('yyyy-MM-dd');
}
else{
Dt2=null;
}
if(todate !=null && todate !=''){
List<string> b=todate.split('/');
Dt3=Datetime.newinstance(integer.valueOf(b[2]),integer.valueOf(b[0]),integer.valueOf(b[1]));
Dt4=Dt3.format('yyyy-MM-dd');
}
else{
Dt4=null;
}
system.debug('######'+Dt2+'-'+Dt4);
String DB1 = 'Select e.Valid_From__c, e.SystemModstamp, e.Name, e.LastModifiedDate,';
DB1 += 'e.LastModifiedById, e.LastActivityDate, e.IsDeleted, e.Insurance_Case__c,e.Insurance_Case__r.name,';
DB1 += 'e.Id, e.FYC_Rate__c, e.FYC_Amount__c, e.Excess_Commission_amount__c, ';
DB1 += 'e.Excess_Commission_Rate__c, e.CreatedDate, e.CreatedById, e.Case_Split__c,';
DB1 += 'e.Agent__c, e.Agency__c , e.Agent__r.Name , e.Agency__r.Name,';
DB1 += 'e.Insurance_Case__r.Target_Premium__c, e.Insurance_Case__r.Product__r.Name,';
DB1 += 'e.Insurance_Case__r.Primary_Insured_or_Annuitant__r.Name, e.Insurance_Case__r.Premium_Mode__c,';
DB1 += 'e.Insurance_Case__r.Policy_Number__c, e.Insurance_Case__r.Submitted_Date__c, ';
DB1 += 'e.Insurance_Case__r.Line_of_Business__c, e.Insurance_Case__r.Carrier__r.Name';
DB1 += ' From Estimated_Commissions__c e ';
if(IsAgency==false){
DB1 += ' where e.Agent__c =\''+User_Selection+'\'';
}
else if(IsAgency==true){
//DB1 += ' where e.Agency__c =\''+AccountMap.get(User_Selection)+'\'';
DB1 += ' where e.Agency__c =\''+user.Contact.accountId+'\'';
}
//New changes as part of input date chaanges
DB1 += ' and e.Insurance_Case__r.Submitted_Date__c >= '+ StartingDate;
if(Dt2!=null){
DB1 += ' and e.Valid_From__c >= ' + Dt2;
}
if(Dt4!=null){
DB1 += ' and e.Valid_From__c <= ' + Dt4;
}
DB1 += ' order by '+ sort_by + ' asc ' ;
DB1 += ' limit 10';
system.debug('#################'+DB1);
LEC = DataBase.query(DB1);
system.debug('LEC:'+LEC);
LDEC = new list<Data_Estimated_Comm>{};
for ( Estimated_Commissions__c est : LEC){
// Create a Data record and add it to the list
Data_Estimated_Comm DEC = new Data_Estimated_Comm();
DEC.Agency = est.Agency__r.Name;
DEC.Agent = est.Agent__r.Name;
DEC.Casesplit = est.Case_Split__c;
DEC.ExcessCommAmt = est.Excess_Commission_amount__c;
DEC.ExcessCommRate = est.Excess_Commission_Rate__c;
DEC.FYCAmt = est.FYC_Amount__c;
DEC.FYCRate = est.FYC_Rate__c;
DEC.Insurance_Commission_Name = est.Name;
DEC.PolicyNumber = est.Insurance_Case__r.Policy_Number__c;
DEC.LineOfBusiness = est.Insurance_Case__r.Line_of_Business__c;
DEC.Carrier = est.Insurance_Case__r.Carrier__r.Name;
DEC.Product = est.Insurance_Case__r.Product__r.Name;
DEC.Client = est.Insurance_Case__r.Primary_Insured_or_Annuitant__r.Name;
DEC.PremiumMode = est.Insurance_Case__r.Premium_Mode__c;
DEC.Premium = est.Insurance_Case__r.Target_Premium__c;
DEC.Valid_From = est.Valid_From__c;
//new changes
DEC.InsuranceCase= est.Insurance_Case__c;
DEC.InsuranceCaseName= est.Insurance_Case__r.Name;
LDEC.add(DEC);
}
return null;
}
}
/**
* This class contains unit tests for validating the behavior of Apex classes
* and triggers.
*
* Unit tests are class methods that verify whether a particular piece
* of code is working properly. Unit test methods take no arguments,
* commit no data to the database, and are flagged with the testMethod
* keyword in the method definition.
*
* All test methods in an organization are executed whenever Apex code is deployed
* to a production organization to confirm correctness, ensure code
* coverage, and prevent regressions. All Apex classes are
* required to have at least 75% code coverage in order to be deployed
* to a production organization. In addition, all triggers must have some code coverage.
*
* The @isTest class annotation indicates this class only contains test
* methods. Classes defined with the @isTest annotation do not count against
* the organization size limit for all Apex scripts.
*
* See the Apex Language Reference for more information about Testing and Code Coverage.
*/
@isTest(SeeAllData=false)
private class TestEstimateCommListClass {
static testMethod void DoListTest() {
RecordType r = [Select Name, Id From RecordType where Name ='Carriers' ];
profile w = [Select Name, Id From profile where Name ='Authenticated Website' ];
Account a= new Account();
a.Name = 'atest';
a.Type = r.Name;
a.RecordTypeId = r.Id;
system.debug('a:'+a);
insert a;
contact con=new contact(lastname='test two',accountid=a.id,Email='client321@mixcimizer.com');
insert con;
User u = new User();
u.Username = 'cooks@gmail.com';
u.LastName = 'mycook';
u.Email = 'client321@mixcimizer.com';
u.profileid = w.id;
u.contactid = con.id;
u.alias =u.LastName.substring(0,4);
u.CommunityNickname ='4321new';
u.MobilePhone ='9875643456';
u.TimeZoneSidKey = 'Asia/Kolkata';
u.LocaleSidKey = 'en_IE_EURO';
u.EmailEncodingKey = 'ISO-8859-1';
u.LanguageLocaleKey = 'en_US';
u.IsActive = true;
INSERT U;
Carrier_Product__c p = new Carrier_Product__c();
p.Name = 'ptest';
p.Carrier__c = a.Id;
p.Line_of_Business__c = 'Life Insurance';
p.Plan_Type__c = 'Term Life Insurance';
insert p;
Insurance_Case__c ic = new Insurance_Case__c();
ic.Carrier__c = a.Id;
ic.Product__c = p.Id;
ic.X1035_Exchange_Amount__c = 1000;
ic.X1035_Exchange_Carrier__c = 'test';
ic.Approved_Rating_Additional_Insured__c = 'test';
ic.Approved_Rating_Primary_Insured__c = 'test';
ic.Elimination_Period__c = '';
ic.Excess_Premium__c = 1000;
ic.Face_Amount__c = 500;
ic.Line_of_Business__c = 'Life Insurance';
ic.Lump_Sum_Amount__c = 500;
ic.Modal_Premium__c = 1000;
ic.Policy_Number__c = '123';
ic.Premium_Mode__c = 'Monthly';
ic.Premium_Payment_Method__c = '';
ic.Policy_Date__c = system.today();
ic.Proposed_Face_Amount__c = 100;
ic.Proposed_Premium__c = 100;
ic.Proposed_Type_Of_Insurance__c = '';
ic.Rating_Applied_For_Additional_Insured__c = '';
ic.Rating_Applied_For_Primary_Insured__c = '';
ic.Source_of_Funds__c = '';
ic.State_of_Issue__c = 'Alabama';
ic.Status__c = 'Inforce';
ic.Target_Premium__c = 1000;
insert ic;
ic.X1035_Exchange_Amount__c = 2000;
ic.X1035_Received_Date__c = system.today();
ic.X1035_Received__c = true;
ic.Lump_Sum_Amount__c = 400;
ic.Lump_Sum_Received__c = true;
ic.Lump_Sum_Received_Date__c = system.today();
update ic;
Estimated_Commissions__c e = new Estimated_Commissions__c();
e.Insurance_Case__c = ic.id;
e.agent__c=con.id;
insert e;
system.runas(u){
EstimateCommList ecl = new EstimateCommList();
ecl.getAllusers();
ecl.getSort();
ecl.sort_by='Valid_From__c';
ecl.searchEsti();
Data_Estimated_Comm Dec = new Data_Estimated_Comm();
EstimateCommList ec2 = new EstimateCommList();
ec2.getAllusers();
ec2.getSort();
ec2.sort_by='Valid_From__c';
ec2.searchEsti();
}
}
}
DB1 += ' and e.Insurance_Case__r.Submitted_Date__c >= :StartingDate' ;
All Answers
You are using dynamic SOQL. In dynamic SOQL you need to user SOQL Injection in your query.
For more details about SOQL Injection please follow this link
http://simplyforce.blogspot.in/2011/03/salesforce-applications-with-security_14.html
If you still not able to get rid of error than please ping your debug log
system.debug('#################'+DB1); at line no 265.
I compared the code of the version above with what has been previously deployed (successfully). The only changes are in the EstimateCommList class and not the test class.
Those changes are:
Line 22: public Date StartingDate;
Line 90: StartingDate=date.newinstance(2014,7,1);
Line 91: system.debug('######'+StartingDate);
Line 99: e.Insurance_Case__r.Target_Premium__c, e.Insurance_Case__r.Product__r.Name,e.Insurance_Case__r.Submitted_Date__c,
Line 104: where e.Agent__c =:CId AND e.Insurance_Case__r.Submitted_Date__c >=: StartingDate
Line 238: DB1 += 'e.Insurance_Case__r.Policy_Number__c, e.Insurance_Case__r.Submitted_Date__c, ';
Line 252: DB1 += ' and e.Insurance_Case__r.Submitted_Date__c >= '+ StartingDate;
I can't see where any of those changes would all of a sudden cause an issue with deployment.
My goal with the class is to simply add a WHERE statement to the query to retrieve records that have a date field equal or greater than a specific date (7/1/14). This is on line 104 as follows:
and on line 252
This class deployed successfully before we added the requirement to check the Submitted_Date__c versus that date (7/1/14). The previous developer tried to accomplish this by declaring StartingDate. But maybe it would be easier to specifically state the date instead such as (and I know this won't work):
where e.Agent__c =:CId AND e.Insurance_Case__r.Submitted_Date__c >= 07/01/14
Thanks for your help. We're supposed to be rolling this out over the weekend.
28.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO 22:13:32.092 (92217441)|EXECUTION_STARTED 22:13:32.092 (92260090)|CODE_UNIT_STARTED|[EXTERNAL]|066i000000485kw|VF: /apex/Estimatecomm_List 22:13:32.093 (93507999)|VF_DESERIALIZE_VIEWSTATE_BEGIN|066i000000485kw 22:13:32.128 (128358871)|VF_DESERIALIZE_VIEWSTATE_END 22:13:32.134 (134984785)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(hasAgencyAccess) 22:13:32.135 (135011109)|SYSTEM_MODE_ENTER|true 22:13:32.135 (135044453)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|hasAgencyAccess 22:13:32.135 (135089409)|METHOD_ENTRY|[1]|01pi0000005RBuG|EstimateCommList.EstimateCommList() 22:13:32.135 (135109401)|METHOD_EXIT|[1]|EstimateCommList 22:13:32.135 (135121557)|CODE_UNIT_FINISHED|hasAgencyAccess 22:13:32.135 (135131038)|CODE_UNIT_FINISHED|EstimateCommList get(hasAgencyAccess) 22:13:32.135 (135341150)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(IsAgency) 22:13:32.135 (135352730)|SYSTEM_MODE_ENTER|true 22:13:32.135 (135361923)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|IsAgency 22:13:32.135 (135373272)|CODE_UNIT_FINISHED|IsAgency 22:13:32.135 (135380328)|CODE_UNIT_FINISHED|EstimateCommList get(IsAgency) 22:13:32.135 (135497667)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(LDEC) 22:13:32.135 (135514131)|SYSTEM_MODE_ENTER|true 22:13:32.135 (135531648)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|LDEC 22:13:32.135 (135551053)|CODE_UNIT_FINISHED|LDEC 22:13:32.135 (135564014)|CODE_UNIT_FINISHED|EstimateCommList get(LDEC) 22:13:32.136 (136340871)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(fromdate) 22:13:32.136 (136356930)|SYSTEM_MODE_ENTER|true 22:13:32.136 (136372245)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|fromdate 22:13:32.136 (136388640)|CODE_UNIT_FINISHED|fromdate 22:13:32.136 (136399761)|CODE_UNIT_FINISHED|EstimateCommList get(fromdate) 22:13:32.136 (136502207)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(todate) 22:13:32.136 (136516166)|SYSTEM_MODE_ENTER|true 22:13:32.136 (136531359)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|todate 22:13:32.136 (136547221)|CODE_UNIT_FINISHED|todate 22:13:32.136 (136557589)|CODE_UNIT_FINISHED|EstimateCommList get(todate) 22:13:32.136 (136763498)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(Sort) 22:13:32.136 (136779902)|SYSTEM_MODE_ENTER|true 22:13:32.138 (138648382)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList invoke(getSort) 22:13:32.138 (138757664)|SYSTEM_CONSTRUCTOR_ENTRY|[142]|<init>() 22:13:32.138 (138788615)|SYSTEM_CONSTRUCTOR_EXIT|[142]|<init>() 22:13:32.138 (138862628)|SYSTEM_METHOD_ENTRY|[143]|LIST<System.SelectOption>.add(Object) 22:13:32.138 (138892998)|SYSTEM_METHOD_EXIT|[143]|LIST<System.SelectOption>.add(Object) 22:13:32.138 (138931699)|SYSTEM_METHOD_ENTRY|[144]|LIST<System.SelectOption>.add(Object) 22:13:32.138 (138982684)|SYSTEM_METHOD_EXIT|[144]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139042238)|SYSTEM_METHOD_ENTRY|[145]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139089975)|SYSTEM_METHOD_EXIT|[145]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139132784)|SYSTEM_METHOD_ENTRY|[146]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139157523)|SYSTEM_METHOD_EXIT|[146]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139191904)|SYSTEM_METHOD_ENTRY|[147]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139215617)|SYSTEM_METHOD_EXIT|[147]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139251408)|SYSTEM_METHOD_ENTRY|[148]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139275167)|SYSTEM_METHOD_EXIT|[148]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139313999)|SYSTEM_METHOD_ENTRY|[149]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139360940)|SYSTEM_METHOD_EXIT|[149]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139419773)|SYSTEM_METHOD_ENTRY|[150]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139474562)|SYSTEM_METHOD_EXIT|[150]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139544141)|SYSTEM_METHOD_ENTRY|[151]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139573250)|SYSTEM_METHOD_EXIT|[151]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139612185)|SYSTEM_METHOD_ENTRY|[152]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139636756)|SYSTEM_METHOD_EXIT|[152]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139671308)|SYSTEM_METHOD_ENTRY|[153]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139695209)|SYSTEM_METHOD_EXIT|[153]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139729190)|SYSTEM_METHOD_ENTRY|[154]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139755877)|SYSTEM_METHOD_EXIT|[154]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139791234)|SYSTEM_METHOD_ENTRY|[155]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139815053)|SYSTEM_METHOD_EXIT|[155]|LIST<System.SelectOption>.add(Object) 22:13:32.139 (139865307)|CODE_UNIT_FINISHED|EstimateCommList invoke(getSort) 22:13:32.139 (139877196)|CODE_UNIT_FINISHED|EstimateCommList get(Sort) 22:13:32.140 (140001223)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(sort_by) 22:13:32.140 (140013767)|SYSTEM_MODE_ENTER|true 22:13:32.140 (140024465)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|sort_by 22:13:32.140 (140036862)|CODE_UNIT_FINISHED|sort_by 22:13:32.140 (140043638)|CODE_UNIT_FINISHED|EstimateCommList get(sort_by) 22:13:32.140 (140183480)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(Allusers) 22:13:32.140 (140194644)|SYSTEM_MODE_ENTER|true 22:13:32.140 (140206517)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList invoke(getAllusers) 22:13:32.140 (140250979)|SYSTEM_CONSTRUCTOR_ENTRY|[177]|<init>() 22:13:32.140 (140272459)|SYSTEM_CONSTRUCTOR_EXIT|[177]|<init>() 22:13:32.143 (143546105)|SOQL_EXECUTE_BEGIN|[180]|Aggregations:0|select id, name, accountid from contact where id IN :tmpVar1 22:13:32.149 (149682801)|SOQL_EXECUTE_END|[180]|Rows:1 22:13:32.150 (150169356)|SOQL_EXECUTE_BEGIN|[181]|Aggregations:0|select id, name, accountid from contact 22:13:32.153 (153474150)|SOQL_EXECUTE_END|[181]|Rows:1 22:13:32.153 (153561317)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocator.iterator() 22:13:32.153 (153812661)|SYSTEM_METHOD_ENTRY|[7]|QueryLocatorIterator.QueryLocatorIterator() 22:13:32.153 (153830249)|SYSTEM_METHOD_EXIT|[7]|QueryLocatorIterator 22:13:32.153 (153969788)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocator.iterator() 22:13:32.154 (154001931)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.154 (154103399)|SYSTEM_METHOD_ENTRY|[33]|LIST<Contact>.size() 22:13:32.154 (154141457)|SYSTEM_METHOD_EXIT|[33]|LIST<Contact>.size() 22:13:32.154 (154161233)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.154 (154176561)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocatorIterator.next() 22:13:32.154 (154198705)|SYSTEM_METHOD_ENTRY|[48]|Database.QueryLocatorIterator.hasNext() 22:13:32.154 (154226209)|SYSTEM_METHOD_ENTRY|[33]|LIST<Contact>.size() 22:13:32.154 (154242309)|SYSTEM_METHOD_EXIT|[33]|LIST<Contact>.size() 22:13:32.154 (154257911)|SYSTEM_METHOD_EXIT|[48]|Database.QueryLocatorIterator.hasNext() 22:13:32.154 (154319798)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocatorIterator.next() 22:13:32.154 (154407597)|SYSTEM_METHOD_ENTRY|[182]|MAP<String,String>.put(Object, Object) 22:13:32.154 (154486447)|SYSTEM_METHOD_EXIT|[182]|MAP<String,String>.put(Object, Object) 22:13:32.154 (154555409)|SYSTEM_METHOD_ENTRY|[183]|Id.compareTo(Id, Id, Boolean) 22:13:32.154 (154614332)|SYSTEM_METHOD_EXIT|[183]|Id.compareTo(Id, Id, Boolean) 22:13:32.154 (154680296)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.154 (154702147)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.154 (154776291)|SYSTEM_METHOD_ENTRY|[191]|String.valueOf(Object) 22:13:32.154 (154831246)|SYSTEM_METHOD_EXIT|[191]|String.valueOf(Object) 22:13:32.154 (154867030)|SYSTEM_METHOD_ENTRY|[191]|System.debug(ANY) 22:13:32.154 (154879540)|USER_DEBUG|[191]|DEBUG|###############{003e000000HoeyMAAR=001e000000IRBXyAAP} 22:13:32.154 (154890287)|SYSTEM_METHOD_EXIT|[191]|System.debug(ANY) 22:13:32.154 (154906190)|SYSTEM_METHOD_ENTRY|[193]|LIST<Contact>.iterator() 22:13:32.155 (155089884)|SYSTEM_METHOD_EXIT|[193]|LIST<Contact>.iterator() 22:13:32.155 (155137160)|SYSTEM_METHOD_ENTRY|[193]|system.ListIterator.hasNext() 22:13:32.155 (155168594)|SYSTEM_METHOD_EXIT|[193]|system.ListIterator.hasNext() 22:13:32.155 (155293159)|SYSTEM_METHOD_ENTRY|[194]|LIST<System.SelectOption>.add(Object) 22:13:32.155 (155345939)|SYSTEM_METHOD_EXIT|[194]|LIST<System.SelectOption>.add(Object) 22:13:32.155 (155362540)|SYSTEM_METHOD_ENTRY|[193]|system.ListIterator.hasNext() 22:13:32.155 (155383356)|SYSTEM_METHOD_EXIT|[193]|system.ListIterator.hasNext() 22:13:32.155 (155427468)|CODE_UNIT_FINISHED|EstimateCommList invoke(getAllusers) 22:13:32.155 (155448201)|CODE_UNIT_FINISHED|EstimateCommList get(Allusers) 22:13:32.156 (156786573)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(User_Selection) 22:13:32.156 (156805933)|SYSTEM_MODE_ENTER|true 22:13:32.156 (156826030)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|User_Selection 22:13:32.156 (156846556)|CODE_UNIT_FINISHED|User_Selection 22:13:32.156 (156857515)|CODE_UNIT_FINISHED|EstimateCommList get(User_Selection) 22:13:32.158 (158599700)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(fromdate,07/01/2014) 22:13:32.158 (158615117)|SYSTEM_MODE_ENTER|true 22:13:32.158 (158630314)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(fromdate,07/01/2014) 22:13:32.158 (158659575)|CODE_UNIT_FINISHED|EstimateCommList set(fromdate,07/01/2014) 22:13:32.158 (158672251)|CODE_UNIT_FINISHED|EstimateCommList set(fromdate,07/01/2014) 22:13:32.158 (158703602)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(todate,01/03/2015) 22:13:32.158 (158716701)|SYSTEM_MODE_ENTER|true 22:13:32.158 (158729471)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(todate,01/03/2015) 22:13:32.158 (158751222)|CODE_UNIT_FINISHED|EstimateCommList set(todate,01/03/2015) 22:13:32.158 (158764303)|CODE_UNIT_FINISHED|EstimateCommList set(todate,01/03/2015) 22:13:32.158 (158804926)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(sort_by,Valid_From__c) 22:13:32.158 (158815864)|SYSTEM_MODE_ENTER|true 22:13:32.158 (158826978)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(sort_by,Valid_From__c) 22:13:32.158 (158850883)|CODE_UNIT_FINISHED|EstimateCommList set(sort_by,Valid_From__c) 22:13:32.158 (158862656)|CODE_UNIT_FINISHED|EstimateCommList set(sort_by,Valid_From__c) 22:13:32.158 (158896499)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(User_Selection,003e000000HoeyMAAR) 22:13:32.158 (158907022)|SYSTEM_MODE_ENTER|true 22:13:32.158 (158918057)|CODE_UNIT_STARTED|[EXTERNAL]|EstimateCommList set(User_Selection,003e000000HoeyMAAR) 22:13:32.158 (158938488)|CODE_UNIT_FINISHED|EstimateCommList set(User_Selection,003e000000HoeyMAAR) 22:13:32.158 (158950017)|CODE_UNIT_FINISHED|EstimateCommList set(User_Selection,003e000000HoeyMAAR) 22:13:32.158 (158998503)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(hasAgencyAccess) 22:13:32.159 (159011628)|SYSTEM_MODE_ENTER|true 22:13:32.159 (159027902)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|hasAgencyAccess 22:13:32.159 (159043759)|CODE_UNIT_FINISHED|hasAgencyAccess 22:13:32.159 (159054684)|CODE_UNIT_FINISHED|EstimateCommList get(hasAgencyAccess) 22:13:32.159 (159162096)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(IsAgency) 22:13:32.159 (159176857)|SYSTEM_MODE_ENTER|true 22:13:32.159 (159190542)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|IsAgency 22:13:32.159 (159206543)|CODE_UNIT_FINISHED|IsAgency 22:13:32.159 (159216326)|CODE_UNIT_FINISHED|EstimateCommList get(IsAgency) 22:13:32.186 (186570804)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(hasAgencyAccess) 22:13:32.186 (186595440)|SYSTEM_MODE_ENTER|true 22:13:32.186 (186610542)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|hasAgencyAccess 22:13:32.186 (186632504)|CODE_UNIT_FINISHED|hasAgencyAccess 22:13:32.186 (186641249)|CODE_UNIT_FINISHED|EstimateCommList get(hasAgencyAccess) 22:13:32.186 (186743077)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(LDEC) 22:13:32.186 (186753769)|SYSTEM_MODE_ENTER|true 22:13:32.186 (186763061)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|LDEC 22:13:32.186 (186775530)|CODE_UNIT_FINISHED|LDEC 22:13:32.186 (186782198)|CODE_UNIT_FINISHED|EstimateCommList get(LDEC) 22:13:32.186 (186869753)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(IsAgency) 22:13:32.186 (186880064)|SYSTEM_MODE_ENTER|true 22:13:32.186 (186888892)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|IsAgency 22:13:32.186 (186899350)|CODE_UNIT_FINISHED|IsAgency 22:13:32.186 (186906105)|CODE_UNIT_FINISHED|EstimateCommList get(IsAgency) 22:13:32.188 (188145624)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(fromdate) 22:13:32.188 (188160430)|SYSTEM_MODE_ENTER|true 22:13:32.188 (188171098)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|fromdate 22:13:32.188 (188184012)|CODE_UNIT_FINISHED|fromdate 22:13:32.188 (188191051)|CODE_UNIT_FINISHED|EstimateCommList get(fromdate) 22:13:32.188 (188268873)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(todate) 22:13:32.188 (188279011)|SYSTEM_MODE_ENTER|true 22:13:32.188 (188288128)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|todate 22:13:32.188 (188299838)|CODE_UNIT_FINISHED|todate 22:13:32.188 (188306899)|CODE_UNIT_FINISHED|EstimateCommList get(todate) 22:13:32.189 (189695350)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(Sort) 22:13:32.189 (189708497)|SYSTEM_MODE_ENTER|true 22:13:32.189 (189723355)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList invoke(getSort) 22:13:32.189 (189803670)|SYSTEM_CONSTRUCTOR_ENTRY|[142]|<init>() 22:13:32.189 (189818928)|SYSTEM_CONSTRUCTOR_EXIT|[142]|<init>() 22:13:32.189 (189866838)|SYSTEM_METHOD_ENTRY|[143]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189884597)|SYSTEM_METHOD_EXIT|[143]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189902893)|SYSTEM_METHOD_ENTRY|[144]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189915141)|SYSTEM_METHOD_EXIT|[144]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189931403)|SYSTEM_METHOD_ENTRY|[145]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189943017)|SYSTEM_METHOD_EXIT|[145]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189958962)|SYSTEM_METHOD_ENTRY|[146]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189970708)|SYSTEM_METHOD_EXIT|[146]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189987144)|SYSTEM_METHOD_ENTRY|[147]|LIST<System.SelectOption>.add(Object) 22:13:32.189 (189998778)|SYSTEM_METHOD_EXIT|[147]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190014809)|SYSTEM_METHOD_ENTRY|[148]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190027541)|SYSTEM_METHOD_EXIT|[148]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190043932)|SYSTEM_METHOD_ENTRY|[149]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190055666)|SYSTEM_METHOD_EXIT|[149]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190080921)|SYSTEM_METHOD_ENTRY|[150]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190098553)|SYSTEM_METHOD_EXIT|[150]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190117510)|SYSTEM_METHOD_ENTRY|[151]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190129463)|SYSTEM_METHOD_EXIT|[151]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190145485)|SYSTEM_METHOD_ENTRY|[152]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190157172)|SYSTEM_METHOD_EXIT|[152]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190173295)|SYSTEM_METHOD_ENTRY|[153]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190185227)|SYSTEM_METHOD_EXIT|[153]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190200897)|SYSTEM_METHOD_ENTRY|[154]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190212382)|SYSTEM_METHOD_EXIT|[154]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190228691)|SYSTEM_METHOD_ENTRY|[155]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190240313)|SYSTEM_METHOD_EXIT|[155]|LIST<System.SelectOption>.add(Object) 22:13:32.190 (190281756)|CODE_UNIT_FINISHED|EstimateCommList invoke(getSort) 22:13:32.190 (190292119)|CODE_UNIT_FINISHED|EstimateCommList get(Sort) 22:13:32.190 (190493715)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(sort_by) 22:13:32.190 (190505045)|SYSTEM_MODE_ENTER|true 22:13:32.190 (190514604)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|sort_by 22:13:32.190 (190526569)|CODE_UNIT_FINISHED|sort_by 22:13:32.190 (190533688)|CODE_UNIT_FINISHED|EstimateCommList get(sort_by) 22:13:32.191 (191103862)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(Allusers) 22:13:32.191 (191116307)|SYSTEM_MODE_ENTER|true 22:13:32.191 (191128751)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList invoke(getAllusers) 22:13:32.191 (191168419)|SYSTEM_CONSTRUCTOR_ENTRY|[177]|<init>() 22:13:32.191 (191177562)|SYSTEM_CONSTRUCTOR_EXIT|[177]|<init>() 22:13:32.191 (191469998)|SOQL_EXECUTE_BEGIN|[180]|Aggregations:0|select id, name, accountid from contact where id IN :tmpVar1 22:13:32.196 (196237980)|SOQL_EXECUTE_END|[180]|Rows:1 22:13:32.196 (196495119)|SOQL_EXECUTE_BEGIN|[181]|Aggregations:0|select id, name, accountid from contact 22:13:32.198 (198899203)|SOQL_EXECUTE_END|[181]|Rows:1 22:13:32.198 (198978423)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocator.iterator() 22:13:32.199 (199127010)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocator.iterator() 22:13:32.199 (199151321)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.199 (199197679)|SYSTEM_METHOD_ENTRY|[33]|LIST<Contact>.size() 22:13:32.199 (199218508)|SYSTEM_METHOD_EXIT|[33]|LIST<Contact>.size() 22:13:32.199 (199239726)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.199 (199256215)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocatorIterator.next() 22:13:32.199 (199281320)|SYSTEM_METHOD_ENTRY|[48]|Database.QueryLocatorIterator.hasNext() 22:13:32.199 (199307839)|SYSTEM_METHOD_ENTRY|[33]|LIST<Contact>.size() 22:13:32.199 (199326411)|SYSTEM_METHOD_EXIT|[33]|LIST<Contact>.size() 22:13:32.199 (199344260)|SYSTEM_METHOD_EXIT|[48]|Database.QueryLocatorIterator.hasNext() 22:13:32.199 (199402456)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocatorIterator.next() 22:13:32.199 (199463744)|SYSTEM_METHOD_ENTRY|[182]|MAP<String,String>.put(Object, Object) 22:13:32.199 (199534611)|SYSTEM_METHOD_EXIT|[182]|MAP<String,String>.put(Object, Object) 22:13:32.199 (199589931)|SYSTEM_METHOD_ENTRY|[183]|Id.compareTo(Id, Id, Boolean) 22:13:32.199 (199623279)|SYSTEM_METHOD_EXIT|[183]|Id.compareTo(Id, Id, Boolean) 22:13:32.199 (199673692)|SYSTEM_METHOD_ENTRY|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.199 (199689758)|SYSTEM_METHOD_EXIT|[181]|Database.QueryLocatorIterator.hasNext() 22:13:32.199 (199724713)|SYSTEM_METHOD_ENTRY|[191]|String.valueOf(Object) 22:13:32.199 (199752351)|SYSTEM_METHOD_EXIT|[191]|String.valueOf(Object) 22:13:32.199 (199771135)|SYSTEM_METHOD_ENTRY|[191]|System.debug(ANY) 22:13:32.199 (199781271)|USER_DEBUG|[191]|DEBUG|###############{003e000000HoeyMAAR=001e000000IRBXyAAP} 22:13:32.199 (199787712)|SYSTEM_METHOD_EXIT|[191]|System.debug(ANY) 22:13:32.199 (199796840)|SYSTEM_METHOD_ENTRY|[193]|LIST<Contact>.iterator() 22:13:32.199 (199807421)|SYSTEM_METHOD_EXIT|[193]|LIST<Contact>.iterator() 22:13:32.199 (199816154)|SYSTEM_METHOD_ENTRY|[193]|system.ListIterator.hasNext() 22:13:32.199 (199831882)|SYSTEM_METHOD_EXIT|[193]|system.ListIterator.hasNext() 22:13:32.199 (199879329)|SYSTEM_METHOD_ENTRY|[194]|LIST<System.SelectOption>.add(Object) 22:13:32.199 (199902715)|SYSTEM_METHOD_EXIT|[194]|LIST<System.SelectOption>.add(Object) 22:13:32.199 (199912045)|SYSTEM_METHOD_ENTRY|[193]|system.ListIterator.hasNext() 22:13:32.199 (199924637)|SYSTEM_METHOD_EXIT|[193]|system.ListIterator.hasNext() 22:13:32.199 (199954184)|CODE_UNIT_FINISHED|EstimateCommList invoke(getAllusers) 22:13:32.199 (199966397)|CODE_UNIT_FINISHED|EstimateCommList get(Allusers) 22:13:32.201 (201168255)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|EstimateCommList get(User_Selection) 22:13:32.201 (201182258)|SYSTEM_MODE_ENTER|true 22:13:32.201 (201215869)|CODE_UNIT_STARTED|[EXTERNAL]|01pi0000005RBuG|User_Selection 22:13:32.201 (201238844)|CODE_UNIT_FINISHED|User_Selection 22:13:32.201 (201252271)|CODE_UNIT_FINISHED|EstimateCommList get(User_Selection) 22:13:32.206 (206837517)|VF_SERIALIZE_VIEWSTATE_BEGIN|066i000000485kw 22:13:32.210 (210826248)|VF_SERIALIZE_VIEWSTATE_END 22:13:32.997 (228439832)|CUMULATIVE_LIMIT_USAGE 22:13:32.997|LIMIT_USAGE_FOR_NS|(default)| Number of SOQL queries: 4 out of 100 Number of query rows: 4 out of 1000000 Number of SOSL queries: 0 out of 20 Number of DML statements: 0 out of 0 Number of DML rows: 0 out of 0 Maximum CPU time: 0 out of 10000 Maximum heap size: 0 out of 6000000 Number of callouts: 0 out of 10 Number of Email Invocations: 0 out of 0 Number of future calls: 0 out of 10 Number of Mobile Apex push calls: 0 out of 10 22:13:32.997|CUMULATIVE_LIMIT_USAGE_END 22:13:32.228 (228476792)|CODE_UNIT_FINISHED|VF: /apex/Estimatecomm_List 22:13:32.230 (230043732)|EXECUTION_FINISHEDDB1 += ' and e.Insurance_Case__r.Submitted_Date__c >= :StartingDate' ;