Hey everybody,

I am currently in the process of deploying my first larger application that I have developed to my production org. However, I am running into issues with writing functioning apex test code. I’m only really familiar with basics of test classes, and I was hoping that a more experienced developer could lend a hand in helping me build a sleek, quality test class for a controller extension for a custom VF page.

The following code is used for one part of the application. This part includes a custom VF page, which displays a list of all child “ML_List__c” within the “ML_List_Container__c” parent object, and an extension, which attempts to create a string of emails and ids to be passed into an apex plugin later on. So far with the provided test code, I get 24% code coverage. However, I still have got a “No rows for assignment error”, and I’m kind of lost for a solution.

Code Samples:

Custom VF:

<apex:page StandardController="ML_List_Container__c" extensions="mLContainerExtension">
...
</apex:page>

* The symbol "..." refers to code deemed "irrelevant" that was cut out to decrease the size of the post.

Controller Extension:

public with sharing class mLContainerExtension {
	
	public final List<ML_List__c> marketingList;
	public final ML_List_Container__c currentRecord;
	public String emailContainerString {get;set;}
	public String idContainerString {get;set;}
	
    public mLContainerExtension(ApexPages.StandardController stdController) {
        marketingList = [
            SELECT Name, Id, Contact__r.Email, Contact__r.Id, Lead__r.Email, Lead__r.Id
            FROM ML_List__c
            WHERE ML_List_Container__c = :ApexPages.currentPage().getParameters().get('Id')
        ];
        currentRecord = [
        	SELECT Name, Id, description__c, CreatedBy.Name, CreatedDate
            FROM ML_List_Container__c
            WHERE Id = :ApexPages.currentPage().getParameters().get('Id')
            LIMIT 1
        ];
        emailContainerString = '';
        idContainerString = '';
        for (ML_List__c mLList : marketingList) {
        	String emailAdd = '';
        	String idAdd = '';
        	if (mLList.Lead__r.Email == null){
        		emailAdd = mLList.Contact__r.Email;
        	}
        	else {
        		emailAdd = mLList.Lead__r.Email;
        	}
        	if (mLList.Lead__r.Id == null){
        		idAdd = mLList.Contact__r.Id;
        	}
        	else {
        		idAdd = mLList.Lead__r.Id;
        	}
        	if (emailAdd != null) {
        		emailContainerString += emailAdd + ', ';
        	}
        	if (idAdd != null) {
        		idContainerString += idAdd + ', ';
        	}
        }
    }
    
    public List<ML_List__c> getMarketingList() {
        return marketingList;
    }
    
    public ML_List_Container__c getCurrentRecord() {
        return currentRecord;
    }

    public PageReference save() {
        update marketingList;
        return null;
    }
    
    public String getFinishPage() {
        return '/apex/ML_Container_Layout?id='+ currentRecord.Id + '&sfdc.override=1';
    }
}

Test Class (24% code coverage and contains "no rows for assignment" error):

@isTest
private class testMLContainerExtension {

    static testMethod void myUnitTest() {
        
                ML_List_Container__c mLLC = new ML_List_Container__c(Name = 'TestContainer');
		
		insert mLLC;

		ApexPages.StandardController sc = new ApexPages.standardController(mLLC);
		
		mLContainerExtension controller = new mLContainerExtension(sc);

    }

}

I will be very grateful for any ideas, suggestions, comments, or advice anyone may provide. Thank you for your time.

Thanks,
Thomas

Hey everybody,

I’ve recently encountered a problem with a project that I’m working on. I’m trying to dynamically rerender a pageBlockTable after the list it references to has been updated. I’ve been looking around the web for any possible solution to this issue, but with no success. I was wondering if any developers out there would mind looking through my code and help me debug this issue.

Background:

I have a visualforce page that has two tabs. One tab allows the user to search for contact records and then add any selected contact records to a new custom object record with a master-detail relationship. The second tab is used to list the 20 most recent of these “contact record lists” and allow the user to view all the children of each of these custom lists. The ideal user experience should be that the user searches for a list of contact records, the user adds them to a list, the user then clicks the second tab, and the user sees the newly created custom list in the pageBlockTable that houses all recent “custom record lists”.

Issue:

I was able to get the functionality to work, but the user is not able to see the newly created list in real time. In order to see it the user must refresh the page.


Code:

VF Page:

<apex:page controller="mLSearchController">
	<head>
		<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
		<style>
...
		</style>
	</head>
	<body>
		<apex:form id="mLSearch">
			<apex:sectionHeader title="Marketing List Search" help="http://developer.force.com"/>
			<apex:tabPanel switchType="client" selectedTab="mainTab" id="mLTabPanel" tabClass="activeTab" inactiveTabClass="inactiveTab" >
...
				<!-- TAB 2: LISTS -->
				<apex:tab label="Lists" name="savedTab" id="searchTab2" style="font-size:12px;">
					<apex:pageBlock id="containerResults" title="Lists" mode="edit">
						<apex:actionFunction action="{!selectContainer}" name="selectContainer" rerender="listResults">
							<apex:param name="container_sel_mL" value="" />
						</apex:actionFunction>
						<apex:actionFunction action="{!doNothing}" name="rerenderContainers" rerender="containerResults"/>
						<apex:actionFunction action="{!updateMLContainers}" name="updateContainers" rerender="containerResults"/>
...
			</apex:tabPanel>     
		</apex:form>
		<div id="opaque"/>
		<div id="popupcontent1" class="popupcontent">
			<apex:form id="popup001">
				<apex:pageBlock title="My Content" mode="edit">
					<apex:pageBlockButtons>
						<input type="button" class="btn" onclick="passListName();" Value="Create New List"/>
						<apex:commandButton action="{!createList}" value="Create List"/>
					</apex:pageBlockButtons>
					<apex:pageBlockSection title="My Content Section1" columns="1">
						<p>Industry:</p>
						<input type="text" name="mLName" id="container_name_mL"/>
					</apex:pageBlockSection>
				</apex:pageBlock>
			</apex:form>
		</div>
		<script type="text/javascript">
			function passListName() {
				var x = j$('#container_name_mL').val();
				if ((x!=null && x!="") && (x.length < 20)) {
					createNewList(
						document.getElementById("container_name_mL").value
					);
					hidepopup();
					updateContainers();
					rerenderContainers();
					prependColumns();
				} else {
					alert("You must enter name that is less than 20 characters.");
					return false;
				}
			}
			
			function showpopup()
			{
				document.getElementById('opaque').style.display='block';
				var popUp = document.getElementById("popupcontent1");
				popUp.style.display = "block";
			} 
			
			function hidepopup()
			{
				var popUp = document.getElementById("popupcontent1");
				popUp.style.display = "none";
				document.getElementById('opaque').style.display='none';
			}
			
			function prependColumns() {
				j$('.inputSection span').wrap("<a class='linkSelector' onclick='selConFunction(this)'></a>");
			}
			
			function selConFunction(e) {
				var containerString = j$(e).find('span').text();
				selectContainer(containerString);
				return false;
			}
		</script>
    </body>
	
	<!-- All "..." in the document signify excerpts that were taken out because they were irrelevant. -->
</apex:page>

Apex Controller:

public with sharing class mLSearchController
{
	private String soqlContainer {get;set;}
	private String soqlMList {get;set;}
	public List<contactWrapper> contacts {get;set;} // this is the list of contacts queried from the search page
	public List<contactWrapper> leadList {get;set;} // this is the list of leads queried from the search page
	public List<ML_List_Container__c> containerList {get;set;}
	public List<ML_List__c> mList {get;set;}
	public List<contactWrapper> selectedList {        
		get {
            if (selectedList == null) selectedList = new List<contactWrapper>();
            return selectedList;
        }
        set;
	}

	public mLSearchController() {
		updateMLContainers();
	}

...
	
    public PageReference createList(){
     	List<ML_List__c> batchList = new List<ML_List__c>();
		ML_List_Container__c newContainer = new ML_List_Container__c();
     	String container_name_mL = Apexpages.currentPage().getParameters().get('container_name_mL');
     	
     	selectedList.clear();
		
		for (contactWrapper cw : contacts) {
			if (cw.checked)
				selectedList.add(new contactWrapper(cw.conObj));
		}
		for (contactWrapper cwL : leadList) {
			if (cwL.checked)
				selectedList.add(new contactWrapper(cwL.leadObj));
		}
     	
     	newContainer.Name = container_name_mL;
     	try {
			insert newContainer;
		} catch (Exception e) {
			ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'ERROR - Something is wrong...'));
		}
     	for (contactWrapper newItem : selectedList) {
     		ML_List__c newListItem = new ML_List__c();
     		newListItem.ML_List_Container__c = newContainer.Id;
     		if (newItem.conObj != null) {
	     		newListItem.Name = newItem.conObj.Name;
	     		newListItem.Contact__c = newItem.conObj.Id;
	     		batchList.add(newListItem);
     		} else if (newItem.leadObj != null) {
 				newListItem.Name = newItem.leadObj.Name;
     			newListItem.Lead__c = newItem.leadObj.Id;
     			batchList.add(newListItem);
     		}
     	}
     	insert batchList;
    	return null;
    }

    public PageReference doNothing() {
    	return null;
	}
    
    public PageReference selectContainer() {
    	String container_sel_mL = Apexpages.currentPage().getParameters().get('container_sel_mL');
    	soqlMList = 'SELECT Name, Contact__c, Lead__c FROM ML_List__c where ML_List_Container__r.Name = :container_sel_mL';
    	mList = Database.query(soqlMList);
    	return null;
    }
    
    public PageReference updateMLContainers() {
    	soqlContainer = 'SELECT Name, CreatedDate FROM ML_List_Container__c ORDER BY CreatedDate desc LIMIT 20';
		containerList = Database.query(soqlContainer);
		system.debug('Well, I think that something is off...');
    	return null;
    }
}

// All "..." in the document signify excerpts that were taken out because they were irrelevant.

Failed Solutions:

• Directing “rerendering” to the id attribute in the pageBlockTable
• Directing “rerendering” to the id attribute in the pageBlock
• Wrapping outputPanel around the desired pageBlockTable, and directing “rerendering” to the id attribute in the outputPanel
• Even tried using javascript to set a timed rerender function that would just rerender the desired section after 2 seconds.

Conclusion:

At this point, I’m pretty stumped as to why the pageBlockTable is not rerendering. I was hoping that some developers out there might be kind enough to help me out with this problem. Thanks so much for your time. Any and all suggestions/ideas are greatly appreciated.

Hey Everyone,

Right now, I’m developing a new feature for our org, and I was wondering if any developers would mind looking over my code and guiding me to the best possible solution.

For this project, I am trying to create a visualforce page where the user can search through our org’s list of contacts and leads. The functionality is a lot like what you would see on a search layout. The user would enter filter keywords, a queried list would display in front of them, and then the user could select multiple records to pass onto an action or button.


Luckily, I was able to successfully handle selecting multiple records and storing them in an Apex list. However, I am having an issue with developing a way for the user to see how many current records are selected, and see this number in real-time.

I tried to solve this by creating an integer in my Apex controller that would be increased if the user checks a checkbox, and decrease if the user unchecks the box.  This seems that it works fine for selecting individual records, but I’m not sure how to make sure the “select all checkbox” updates the integer correctly, especially since I’m working with two different objects.


Here is my Visualforce Page:

<!-- Below is the Visualforce Markup for the two main pageBlockTables that each display the
      contact and lead records that were queried from the Apex Controller -->
	  
<apex:pageBlockTable id="results" value="{!contacts}" var="item">
		<apex:column width="23">
			<apex:facet name="header">
				<input type="checkbox" id="contactCB" onchange="checkAll(this);"/>
			</apex:facet>
			<apex:inputCheckbox styleClass="columnCheck" value="{!item.checked}" onchange="updateSelected(this)"/>
		</apex:column>
			<apex:column value="{!item.conObj.firstname}"/>
			<apex:column value="{!item.conObj.lastname}"/>
			<apex:column value="{!item.conObj.Title}"/>
			<apex:column value="{!item.conObj.account.Industry}"/>
			<apex:column value="{!item.conObj.Phone}"/>
			<apex:column value="{!item.conObj.Email}"/>
			<apex:column value="{!item.conObj.MailingCity}"/>
			<apex:column value="{!item.conObj.MailingState}"/>
		</apex:pageBlockTable>
		<apex:pageBlockTable id="resultsLead" value="{!leadList}" var="item">
		<apex:column width="23">
			<apex:facet name="header">
				<input type="checkbox" id="leadCB" onchange="checkAll2(this);"/>
			</apex:facet>
			<apex:inputCheckbox styleClass="columnCheck2" value="{!item.checked}" onchange="updateSelected(this)"/>
		</apex:column>
			<apex:column value="{!item.leadObj.firstname}"/>
			<apex:column value="{!item.leadObj.lastname}"/>
			<apex:column value="{!item.leadObj.Title}"/>
			<apex:column value="{!item.leadObj.Industry}"/>
			<apex:column value="{!item.leadObj.Company}"/>
			<apex:column value="{!item.leadObj.NumberOfEmployees}"/>
			<apex:column value="{!item.leadObj.AnnualRevenue}"/>
			<apex:column value="{!item.leadObj.Phone}"/>
			<apex:column value="{!item.leadObj.Email}"/>
			<apex:column value="{!item.leadObj.City}"/>
			<apex:column value="{!item.leadObj.State}"/>
</apex:pageBlockTable>

Here is my Javascript:

function checkAll(e) {
	if (j$(e).is(':checked')) {
		j$('.columnCheck').prop('checked', true);
	} else {
		j$('.columnCheck').prop('checked', false);
	}
}
function checkAll2(e) {
	if (j$(e).is(':checked')) {
		j$('.columnCheck2').prop('checked', true);
	} else {
		j$('.columnCheck2').prop('checked', false);
	}
}
function updateSelected(e) {
	if (j$(e).is(':checked')) {
		upSel();
	} else {
		downSel();
	}
}

Here is another slice of my visualforce:

<apex:actionFunction name="mainSearch" action="{!runMarketingSearch}" rerender="results, resultsLead, debug, selectedQuery, totalQuery">
   <apex:param name="title_mL" value="" />
   <apex:param name="industry_mL" value="" />
   <apex:param name="company_mL" value="" />
   <apex:param name="revenue_mL" value="" />
   <apex:param name="employNum_mL" value="" />
   <apex:param name="cityInput" value="" />
   <apex:param name="stateInput" value="" />
  </apex:actionFunction>
  <apex:actionFunction name="upSel" action="{!increaseSelected}" rerender="selectedQuery, totalQuery"/>
  <apex:actionFunction name="downSel" action="{!decreaseSelected}" rerender="selectedQuery, totalQuery"/>
<table width="100%" border="0">
<tr> 
  <td style="width:375px" valign="top">
 
   <apex:pageBlockButtons >
    <apex:commandButton action="{!saveObjects}" value="Save"/>
    <apex:commandButton action="{!next}" value="See Results"/>
   </apex:pageBlockButtons>
...

Here is my Apex Controller:

public with sharing class mLSearchController{
	private String soqlCon {get;set;}
	private String soqlLead {get;set;}
	public List<contactWrapper> contacts {get;set;}
	public List<contactWrapper> leadList {get;set;}
	public List<contactWrapper> selectedList {        
		get {
            if (selectedList == null) selectedList = new List<contactWrapper>();
            return selectedList;
        }
        set;
        }
	public List<contactWrapper> debugSoql {
	    get { return selectedList; }
	    set;
  	}
  	public Integer queryTotal {get;set;}
  	public Integer queryContactSel {get;set;}
  	public Integer queryLeadTotalSel {get;set;}
  	public Integer querySel {get;set;}
	
	
	public mLSearchController() {}
  
	public void runQuery() {

		try {

		} catch (Exception e) {
			ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
		}
	}
	
	public PageReference runMarketingSearch() {
		String title_mL = Apexpages.currentPage().getParameters().get('title_mL');
		String industry_mL = Apexpages.currentPage().getParameters().get('industry_mL');
		String company_mL = Apexpages.currentPage().getParameters().get('company_mL');
		String revenue_mL = Apexpages.currentPage().getParameters().get('revenue_mL');
		String employNum_mL = Apexpages.currentPage().getParameters().get('employNum_mL');
		String cityInput = Apexpages.currentPage().getParameters().get('cityInput');
		String stateInput = Apexpages.currentPage().getParameters().get('stateInput');
		soqlCon = 'select firstname, lastname, Title, Email, Phone, account.Industry, MailingCity, MailingState, LastActivityDate from Contact WHERE account.name != null and LastActivityDate != LAST_N_DAYS:60';
		soqlLead = 'select firstname, lastname, Title, Phone, Email, Industry, Company, NumberOfEmployees, AnnualRevenue, City, State from Lead WHERE Company != null and LastActivityDate != LAST_N_DAYS:60';
      	if (!title_mL.equals('')) {
      		soqlCon += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
      		soqlLead += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
      	}
      	if (!industry_mL.equals('')) {
      		soqlCon += ' and account.Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
      		soqlLead += ' and Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
      	}
      	if (!cityInput.equals('')) {
      		soqlCon += ' and MailingCity LIKE \'' + String.escapeSingleQuotes(cityInput) + '%\'';
      		soqlLead += ' and City LIKE \'' + String.escapeSingleQuotes(cityInput) + '%\'';
      	}
      	if (!stateInput.equals('')) {
      		soqlCon += ' and MailingState LIKE \'' + String.escapeSingleQuotes(stateInput) + '%\'';
      		soqlLead += ' and State LIKE \'' + String.escapeSingleQuotes(stateInput) + '%\'';
      	}
      	if (!company_mL.equals('')) {
      		soqlLead += ' and Company LIKE \'%' + String.escapeSingleQuotes(company_mL) + '%\'';
      	}
      	
      	//if (!revenue_mL.equals('')) soqlLead += ' and AnnualRevenue LIKE \'%' + String.escapeSingleQuotes(revenue_mL) + '%\'';
      	if (revenue_mL == 'tier1_mL') {
      		soqlLead += ' and (AnnualRevenue < 1000000.00)';
      	} else if (revenue_mL == 'tier2_mL') {
      		soqlLead += ' and (AnnualRevenue >= 1000000.00 AND AnnualRevenue < 5000000.00)';
      	} else if (revenue_mL == 'tier3_mL') {
      		soqlLead += ' and (AnnualRevenue >= 5000000.00 AND AnnualRevenue < 10000000.00)';
      	} else if (revenue_mL == 'tier4_mL') {
      		soqlLead += ' and (AnnualRevenue >= 10000000.00 AND AnnualRevenue < 25000000.00)';
      	} else if (revenue_mL == 'tier5_mL') {
      		soqlLead += ' and (AnnualRevenue >= 25000000.00 AND AnnualRevenue < 50000000.00)';
      	} else if (revenue_mL == 'tier6_mL') {
      		soqlLead += ' and (AnnualRevenue >= 50000000.00 AND AnnualRevenue < 100000000.00)';
      	} else if (revenue_mL == 'tier7_mL') {
      		soqlLead += ' and (AnnualRevenue >= 100000000.00 AND AnnualRevenue < 250000000.00)';
      	} else if (revenue_mL == 'tier8_mL') {
      		soqlLead += ' and (AnnualRevenue >= 250000000.00 AND AnnualRevenue < 500000000.00)';
      	} else if (revenue_mL == 'tier9_mL') {
      		soqlLead += ' and (AnnualRevenue >= 500000000.00 AND AnnualRevenue < 2500000000.00)';
      	} else if (revenue_mL == 'tier10_mL') {
      		soqlLead += ' and (AnnualRevenue >= 2500000000.00)';
      	} else {
      		
      	}
      	
      	
      	if (employNum_mL == 'tier1_mL') {
      		soqlLead += ' and (NumberOfEmployees >= 1 AND NumberOfEmployees <= 100)';
      	} else if (employNum_mL == 'tier2_mL') {
      		soqlLead += ' and (NumberOfEmployees >= 101 AND NumberOfEmployees <= 500)';
      	} else if (employNum_mL == 'tier3_mL') {
      		soqlLead += ' and (NumberOfEmployees >= 501 AND NumberOfEmployees <= 3500)';
      	} else if (employNum_mL == 'tier4_mL') {
      		soqlLead += ' and (NumberOfEmployees > 3500)';
      	} else {
      		
      	}
      		contacts = new List<contactWrapper>();
      		leadList = new List<contactWrapper>();
			for (Contact conRec : Database.query(soqlCon + ' limit 20')) {
				contactWrapper cr = new contactWrapper(conRec);
				contacts.add(cr);
			}
			for (Lead leadRec : Database.query(soqlLead + ' limit 20')) {
				contactWrapper lr = new contactWrapper(leadRec);
				leadList.add(lr);
			}
			queryTotal = contacts.size() + leadList.size();
			querySel = selectedList.size();
    	return null;
	}
	
	public PageReference increaseSelected() {
		querySel++;
		return null;
	}
	
	public PageReference decreaseSelected() {
		querySel--;
		return null;
	}
	
	/*public PageReference contactAllSelected() {
		querySel = contacts.size();
		return null;
	}
	
	public PageReference leadAllSelected() {
		querySel = 0;
		return null;
	}*/
    
    public PageReference next() {
	selectedList.clear();
	for (contactWrapper cw : contacts) {
		if (cw.checked)
			selectedList.add(new contactWrapper(cw.conObj));
	}
	if (selectedList.size() > 0) {
		debugSoql = new List<contactWrapper>(selectedList);
		querySel = selectedList.size();
		return Page.ML_Search_Layout;
	} else {
		ApexPages.addMessage(new ApexPages.message(ApexPages.severity.ERROR,'Please select at least one Category.'));
		return null;
	}       
} 

}

Thanks so much for your time. I’m grateful for any help or suggestions on this issue.

Hey everyone,

I am currently working on a project that our organization is going to implement in our salesforce org, in order to increase user’s efficiency searching for specific contacts and leads. I proposed to create a visualforce page and an Apex controller that would allow users to search for contacts and leads in real time using javascript/jQuery/ajax. Everything seems to be working flawlessly, except for one of the two picklist fields, Revenue and Number of Employees. For both of these fields, I gave them both a list of ranged options, each representing a different tier for their respective values. After the user selects an option, the page’s Apex Controller would handle all values that were passed using conditional statements. Here are the two picklists:

<tr>
<td>
  <p>Revenue:</p>
</td>
<td>                         
  <select id="revenue_mL" onchange="runSearch();">
   <option value=""></option>
   <option value="tier1_mL">Less than $1 Million</option>
   <option value="tier2_mL">$1 million - $5 million</option>
   <option value="tier3_mL">$5 million - $10 million</option>
   <option value="tier4_mL">$10 million - under $25 million</option>
   <option value="tier5_mL">$25 million - under $50 million</option>
   <option value="tier6_mL">$50 million - under $100 million</option>
   <option value="tier7_mL">$100 million - under $250 million</option>
   <option value="tier8_mL">$250 million - under $500 million</option>
   <option value="tier9_mL">$500 million - under $2.5 billion</option>
   <option value="tier10_mL">Over $2.5 billion</option>
  </select>
</td>
</tr>
<tr>
<td>
  <p>Employees:</p>
</td>
<td>
  <select id="employNum_mL" onchange="runSearch();">
   <option value=""></option>
   <option value="tier1_mL">1-100 Employees</option>
   <option value="tier2_mL">101-500 Employees</option>
   <option value="tier3_mL">501-3,500 Employees</option>
   <option value="tier4_mL">3,500+ Employees</option>
  </select>
</td>
</tr>

Both picklists have the event, “onchange”, attributed to them. So, anytime the picklist is changed to a different value, the runSearch() function is executed. The function, runSearch(), is used to “scoop” all the data from the form using an <apex:actionFunction> tag. Here is the runSearch() javascript function:

function runSearch() {
	var e = document.getElementById("employNum_mL");
	var strUser = e.options[e.selectedIndex].value;
	var f = document.getElementById("revenue_mL");
	var strUser2 = f.options[f.selectedIndex].value;
	mainSearch(
		document.getElementById("title_mL").value,
		document.getElementById("industry_mL").value,
		document.getElementById("company_mL").value,
		strUser2,
		strUser,
		document.getElementById("zipInput").value
	);
}

Here is the actionFunction tag that sends the form parameters to the apex controller:

<apex:actionFunction name="mainSearch" action="{!runMarketingSearch}" rerender="results, resultsLead">
	  <apex:param name="title_mL" value="" />
	  <apex:param name="industry_mL" value="" />
	  <apex:param name="company_mL" value="" />
	  <apex:param name="revenue_mL" value="" />
	  <apex:param name="employNum_mL" value="" />
	  <apex:param name="zipInput" value="" />
  </apex:actionFunction>

Finally, all the data ends up in the Apex Controller. Here is the apex controller:

public with sharing class mLSearchController{
private String soqlCon {get;set;}
private String soqlLead {get;set;}
public List<Contact> contacts {get;set;}
public List<Lead> leadList {get;set;}

public mLSearchController() {
  runQuery();
}
 
public void runQuery() {
  try {
   contacts = Database.query(soqlCon + ' limit 20');
   leadList = Database.query(soqlLead + ' limit 20');
  } catch (Exception e) {
   ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
  }
}

public PageReference runMarketingSearch() {
  String title_mL = Apexpages.currentPage().getParameters().get('title_mL');
  String industry_mL = Apexpages.currentPage().getParameters().get('industry_mL');
  String company_mL = Apexpages.currentPage().getParameters().get('company_mL');
  String revenue_mL = Apexpages.currentPage().getParameters().get('revenue_mL');
  String employNum_mL = Apexpages.currentPage().getParameters().get('employNum_mL');
  String zipcode = Apexpages.currentPage().getParameters().get('zipInput');
  soqlCon = 'select firstname, lastname, Title, Email, Phone, account.Industry, MailingCity, MailingState, MailingPostalCode from Contact where account.name != null';
  soqlLead = 'select firstname, lastname, Title, Phone, Email, Industry, Company, NumberOfEmployees, AnnualRevenue, City, State, PostalCode from Lead where Company != null';
       if (!title_mL.equals('')) {
        soqlCon += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
        soqlLead += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
       }
       if (!industry_mL.equals('')) {
        soqlCon += ' and account.Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
        soqlLead += ' and Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
       }
       if (!zipcode.equals('')) {
        soqlCon += ' and MailingPostalCode LIKE \'' + String.escapeSingleQuotes(zipcode) + '%\'';
        soqlLead += ' and PostalCode LIKE \'' + String.escapeSingleQuotes(zipcode) + '%\'';
       }
       if (!company_mL.equals('')) {
        soqlLead += ' and Company LIKE \'%' + String.escapeSingleQuotes(company_mL) + '%\'';
       }
 
       // ===============================================================================================
  // THIS IS THE REVENUE CONDITIONAL STATEMENTS ALL SEEM TO WORK EXCEPT FOR tier9_mL AND tier10_mL
  // ===============================================================================================
       if (revenue_mL == 'tier1_mL') {
        soqlLead += ' and (AnnualRevenue < 1000000)';
       } else if (revenue_mL == 'tier2_mL') {
        soqlLead += ' and (AnnualRevenue >= 1000000 AND AnnualRevenue < 5000000)';
       } else if (revenue_mL == 'tier3_mL') {
        soqlLead += ' and (AnnualRevenue >= 5000000 AND AnnualRevenue < 10000000)';
       } else if (revenue_mL == 'tier4_mL') {
        soqlLead += ' and (AnnualRevenue >= 10000000 AND AnnualRevenue < 25000000)';
       } else if (revenue_mL == 'tier5_mL') {
        soqlLead += ' and (AnnualRevenue >= 25000000 AND AnnualRevenue < 50000000)';
       } else if (revenue_mL == 'tier6_mL') {
        soqlLead += ' and (AnnualRevenue >= 50000000 AND AnnualRevenue < 100000000)';
       } else if (revenue_mL == 'tier7_mL') {
        soqlLead += ' and (AnnualRevenue >= 100000000 AND AnnualRevenue < 250000000)';
       } else if (revenue_mL == 'tier8_mL') {
        soqlLead += ' and (AnnualRevenue >= 250000000 AND AnnualRevenue < 500000000)';
       } else if (revenue_mL == 'tier9_mL') {
        soqlLead += ' and (AnnualRevenue >= 500000000 AND AnnualRevenue < 2500000000)';
       } else if (revenue_mL == 'tier10_mL') {
        soqlLead += ' and (AnnualRevenue >= 2500000000)';
       } else {
       
       }
      
       if (employNum_mL == 'tier1_mL') {
        soqlLead += ' and (NumberOfEmployees >= 1 AND NumberOfEmployees <= 100)';
       } else if (employNum_mL == 'tier2_mL') {
        soqlLead += ' and (NumberOfEmployees >= 101 AND NumberOfEmployees <= 500)';
       } else if (employNum_mL == 'tier3_mL') {
        soqlLead += ' and (NumberOfEmployees >= 501 AND NumberOfEmployees <= 3500)';
       } else if (employNum_mL == 'tier4_mL') {
        soqlLead += ' and (NumberOfEmployees > 3500)';
       } else {
       
       }
       runQuery();
     return null;
}

}

   The problem that I am faced with is that the Revenue picklist is not functioning correctly, while the Number of Employees picklist is working fine. The apex seems to be appending the correct data from the revenue picklist, except for the last two values, tier9_mL and tier10_mL. Here are two lead use cases that are in my sandbox I do have two Lead cases. One lead has an annual revenue of $10,000,000, and another has $4,000,000,000. For some reason, the query is able to pull the $10 million lead, but not the $4 billion. I was hoping that any more experienced developers might be kind enough to look at my problem and help guide me to where the issue is. Any suggestions, ideas, etc. are greatly appreciated. Thanks so much for your time.

Hey everybody,

I have been debugging a strange I/O issue that I've encountered with an Apex Plugin I'm trying to implement into a Visual Workflow. I have been trying to use Apex to successfully handle an input string parameter and pass it to an output string parameter. In other words, Visual Workflow throws up a screen for the user to enter a value, he/she hits the “Next” button, and an Apex Plugin takes their input and pushes it to a completely different variable.

Here is an outline of the flow:

1. Screen: debug001; Input Textbox: Input for “CurrentId” Var
2. Apex Trigger: Send Email Plugin; Input: CampId => "CurrentId", Output: AccountId => "TextString001"
3. String: debug002; Output Text: {!TextString001}

Here is the code for the Apex Plugin:

global with sharing class CreateSendGridEmail implements Process.Plugin {
	
	global Process.PluginResult invoke(Process.PluginRequest request) { 
		String CampId = (String) request.inputParameters.get('CampId');
		system.debug(CampId);

		// return to Flow
		Map<String,Object> result = new Map<String,Object>();
		result.put('AccountID', CampId);
		return new Process.PluginResult(result);
	} 
	
		global Process.PluginDescribeResult describe() { 
        Process.PluginDescribeResult result = new Process.PluginDescribeResult();
        result.Name = 'SendGrid Send One-Off Email';
        result.Tag = 'Email';
        result.inputParameters = new 
           List<Process.PluginDescribeResult.InputParameter>{ 
               new Process.PluginDescribeResult.InputParameter('CampId', 
               Process.PluginDescribeResult.ParameterType.STRING, true) 
            };
        result.outputParameters = new 
           List<Process.PluginDescribeResult.OutputParameter>{ 
	           new Process.PluginDescribeResult.OutputParameter('AccountID',
	           Process.PluginDescribeResult.ParameterType.STRING)
           }; 
        return result; 
    }
}

The problem occurs in the final screen of the Visual Workflow. The screen is completely blank. Looking in the debug logs. The variable "CampId" returns null. For some reason my code is unable to pull the input parameter’s source from the flow.  At this point, I feel lost on how to resolve this issue. I looked at multiple other Process.Plugin examples and code snippets, but I can’t find anything that I’m missing. I was hoping to see if there were any developers out there who could give me some assistance with this issue. I'm thankful for any and all suggestions, ideas, etc. for this problem.

Thanks so much for your time.

Hey everybody,

I am currently working on a Visualforce component where it will display a filtered related list on the main page layout of the "Projects" ("PE_Projects__c") custom object. I've looked up various sources on how to achieve a filtered related list, and I've created a rough bit of code to test. However, everytime I load a Projects page, an error message appears in the Visualforce window saying: "Content cannot be displayed: Cannot modify a collection while it is being iterated." After researching this error a bit, I've tried using the addAll() method to copy a finished list to the "projConList" list. However, I'm still back at square one.


Visualforce Code:

<apex:page standardController="PE_Projects__c" extensions="ProjectRolesMainClass">
     <apex:form>
    <apex:pageBlock >
        <apex:pageBlockTable value="{!projConList}" var="p">
            <apex:column value="{!p.Name}"/>
            <apex:column value="{!p.Project_Contacts_con__c}"/>
        </apex:pageBlockTable>
    </apex:pageBlock>
    </apex:form>
</apex:page>

Apex Code:

public class ProjectRolesMainClass {
    public List<Project_Contacts__c> projConList{get;set;}
    public ProjectRolesMainClass(ApexPages.StandardController controller) {
        List<Project_Contacts__c> tempList=[select Id, Project_Contacts_con__c from Project_Contacts__c where Project_Contacts_proj__c=:ApexPages.currentPage().getParameters().get('id')];
        for(Project_Contacts__c PR:tempList) {
			tempList.add(PR);
        }
        projConList.addAll(tempList);
    }
}

I was hoping some experienced VF developers would mind helping a newbie out by providing any suggestions, ideas, solutions, etc.

Thanks so much for your time.

Hey everyone,

I'm new to Apex and VisualForce, and I wanted to see if any developers out there could give a newbie like me some direction in how to tackle this project I'm working on.

In our Org, we have a custom object called "Projects", that is a child of the "Accounts" object. This object is used to store info on the status, cost, hours spent, etc. of each of our firm's projects. I am currently developing a way to easily store a number of project-specific contacts in a related list under each project. Each related list should have a default contact that is the default for all projects in the same account, but also should have the ability to add or subtract from the list.

In order to solve this, I've proposed creating a custom "junction" object to bridge "Projects" and "Contacts" under the same account. I am planning on using APEX and VisualForce to create a related list that can be set with default contacts when created, but also be flexible enough to allow the user to add new contacts for that specific project. Once all needed contacts are in the related list, the user is able to fire a Conga Composer email that sends an email to all those contacts within the related list.

At this point, this is the best solution that I have come up with. Like I said, I am new to apex coding and VisualForce, so any and all suggestions or ideas are greatly appreciated.

Thank you for your time,
Thomas

Hey,

I'm in the process of developing a custom button on Salesforce that is able to toggle a checkbox on and off.
At this point, I am using the Salesforce AJAX Toolkit in order to do the main backend functions of the custom button.
I have the backend working, but I was hoping I could have the custom button label toggle between "Start Process" and "End Process".
To do this, I assume I would need the custom button to change it's own label.
I attempted this by placing these lines in my code:

    var toggleButton = new sforce.SObject("Lead");
    var toggleButtonT ="{!Lead.Begin_Touch_Process}"; //my attempt to reference the button
    toggleButtonT.Id = "00bc0000000QoaE"; // my attempt to reference the button id
    toggleButtonT.Label = "test"; // entering new value for the button label
    result = sforce.connection.update([toggleButton]); // updating the button

NOTE:  {!RequireScript} is already mentioned in script.
It's also entirely possible that I cannot change the name of the button with the AJAX Toolkit.

I am very new to Salesforce and learning about this tool, so any ideas or suggestions will be greatly appreciated!


Thanks,
TF

Hey Everyone,

Right now, I’m developing a new feature for our org, and I was wondering if any developers would mind looking over my code and guiding me to the best possible solution.

For this project, I am trying to create a visualforce page where the user can search through our org’s list of contacts and leads. The functionality is a lot like what you would see on a search layout. The user would enter filter keywords, a queried list would display in front of them, and then the user could select multiple records to pass onto an action or button.


Luckily, I was able to successfully handle selecting multiple records and storing them in an Apex list. However, I am having an issue with developing a way for the user to see how many current records are selected, and see this number in real-time.

I tried to solve this by creating an integer in my Apex controller that would be increased if the user checks a checkbox, and decrease if the user unchecks the box.  This seems that it works fine for selecting individual records, but I’m not sure how to make sure the “select all checkbox” updates the integer correctly, especially since I’m working with two different objects.


Here is my Visualforce Page:

<!-- Below is the Visualforce Markup for the two main pageBlockTables that each display the
      contact and lead records that were queried from the Apex Controller -->
	  
<apex:pageBlockTable id="results" value="{!contacts}" var="item">
		<apex:column width="23">
			<apex:facet name="header">
				<input type="checkbox" id="contactCB" onchange="checkAll(this);"/>
			</apex:facet>
			<apex:inputCheckbox styleClass="columnCheck" value="{!item.checked}" onchange="updateSelected(this)"/>
		</apex:column>
			<apex:column value="{!item.conObj.firstname}"/>
			<apex:column value="{!item.conObj.lastname}"/>
			<apex:column value="{!item.conObj.Title}"/>
			<apex:column value="{!item.conObj.account.Industry}"/>
			<apex:column value="{!item.conObj.Phone}"/>
			<apex:column value="{!item.conObj.Email}"/>
			<apex:column value="{!item.conObj.MailingCity}"/>
			<apex:column value="{!item.conObj.MailingState}"/>
		</apex:pageBlockTable>
		<apex:pageBlockTable id="resultsLead" value="{!leadList}" var="item">
		<apex:column width="23">
			<apex:facet name="header">
				<input type="checkbox" id="leadCB" onchange="checkAll2(this);"/>
			</apex:facet>
			<apex:inputCheckbox styleClass="columnCheck2" value="{!item.checked}" onchange="updateSelected(this)"/>
		</apex:column>
			<apex:column value="{!item.leadObj.firstname}"/>
			<apex:column value="{!item.leadObj.lastname}"/>
			<apex:column value="{!item.leadObj.Title}"/>
			<apex:column value="{!item.leadObj.Industry}"/>
			<apex:column value="{!item.leadObj.Company}"/>
			<apex:column value="{!item.leadObj.NumberOfEmployees}"/>
			<apex:column value="{!item.leadObj.AnnualRevenue}"/>
			<apex:column value="{!item.leadObj.Phone}"/>
			<apex:column value="{!item.leadObj.Email}"/>
			<apex:column value="{!item.leadObj.City}"/>
			<apex:column value="{!item.leadObj.State}"/>
</apex:pageBlockTable>

Here is my Javascript:

function checkAll(e) {
	if (j$(e).is(':checked')) {
		j$('.columnCheck').prop('checked', true);
	} else {
		j$('.columnCheck').prop('checked', false);
	}
}
function checkAll2(e) {
	if (j$(e).is(':checked')) {
		j$('.columnCheck2').prop('checked', true);
	} else {
		j$('.columnCheck2').prop('checked', false);
	}
}
function updateSelected(e) {
	if (j$(e).is(':checked')) {
		upSel();
	} else {
		downSel();
	}
}

Here is another slice of my visualforce:

<apex:actionFunction name="mainSearch" action="{!runMarketingSearch}" rerender="results, resultsLead, debug, selectedQuery, totalQuery">
   <apex:param name="title_mL" value="" />
   <apex:param name="industry_mL" value="" />
   <apex:param name="company_mL" value="" />
   <apex:param name="revenue_mL" value="" />
   <apex:param name="employNum_mL" value="" />
   <apex:param name="cityInput" value="" />
   <apex:param name="stateInput" value="" />
  </apex:actionFunction>
  <apex:actionFunction name="upSel" action="{!increaseSelected}" rerender="selectedQuery, totalQuery"/>
  <apex:actionFunction name="downSel" action="{!decreaseSelected}" rerender="selectedQuery, totalQuery"/>
<table width="100%" border="0">
<tr> 
  <td style="width:375px" valign="top">
 
   <apex:pageBlockButtons >
    <apex:commandButton action="{!saveObjects}" value="Save"/>
    <apex:commandButton action="{!next}" value="See Results"/>
   </apex:pageBlockButtons>
...

Here is my Apex Controller:

public with sharing class mLSearchController{
	private String soqlCon {get;set;}
	private String soqlLead {get;set;}
	public List<contactWrapper> contacts {get;set;}
	public List<contactWrapper> leadList {get;set;}
	public List<contactWrapper> selectedList {        
		get {
            if (selectedList == null) selectedList = new List<contactWrapper>();
            return selectedList;
        }
        set;
        }
	public List<contactWrapper> debugSoql {
	    get { return selectedList; }
	    set;
  	}
  	public Integer queryTotal {get;set;}
  	public Integer queryContactSel {get;set;}
  	public Integer queryLeadTotalSel {get;set;}
  	public Integer querySel {get;set;}
	
	
	public mLSearchController() {}
  
	public void runQuery() {

		try {

		} catch (Exception e) {
			ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
		}
	}
	
	public PageReference runMarketingSearch() {
		String title_mL = Apexpages.currentPage().getParameters().get('title_mL');
		String industry_mL = Apexpages.currentPage().getParameters().get('industry_mL');
		String company_mL = Apexpages.currentPage().getParameters().get('company_mL');
		String revenue_mL = Apexpages.currentPage().getParameters().get('revenue_mL');
		String employNum_mL = Apexpages.currentPage().getParameters().get('employNum_mL');
		String cityInput = Apexpages.currentPage().getParameters().get('cityInput');
		String stateInput = Apexpages.currentPage().getParameters().get('stateInput');
		soqlCon = 'select firstname, lastname, Title, Email, Phone, account.Industry, MailingCity, MailingState, LastActivityDate from Contact WHERE account.name != null and LastActivityDate != LAST_N_DAYS:60';
		soqlLead = 'select firstname, lastname, Title, Phone, Email, Industry, Company, NumberOfEmployees, AnnualRevenue, City, State from Lead WHERE Company != null and LastActivityDate != LAST_N_DAYS:60';
      	if (!title_mL.equals('')) {
      		soqlCon += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
      		soqlLead += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
      	}
      	if (!industry_mL.equals('')) {
      		soqlCon += ' and account.Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
      		soqlLead += ' and Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
      	}
      	if (!cityInput.equals('')) {
      		soqlCon += ' and MailingCity LIKE \'' + String.escapeSingleQuotes(cityInput) + '%\'';
      		soqlLead += ' and City LIKE \'' + String.escapeSingleQuotes(cityInput) + '%\'';
      	}
      	if (!stateInput.equals('')) {
      		soqlCon += ' and MailingState LIKE \'' + String.escapeSingleQuotes(stateInput) + '%\'';
      		soqlLead += ' and State LIKE \'' + String.escapeSingleQuotes(stateInput) + '%\'';
      	}
      	if (!company_mL.equals('')) {
      		soqlLead += ' and Company LIKE \'%' + String.escapeSingleQuotes(company_mL) + '%\'';
      	}
      	
      	//if (!revenue_mL.equals('')) soqlLead += ' and AnnualRevenue LIKE \'%' + String.escapeSingleQuotes(revenue_mL) + '%\'';
      	if (revenue_mL == 'tier1_mL') {
      		soqlLead += ' and (AnnualRevenue < 1000000.00)';
      	} else if (revenue_mL == 'tier2_mL') {
      		soqlLead += ' and (AnnualRevenue >= 1000000.00 AND AnnualRevenue < 5000000.00)';
      	} else if (revenue_mL == 'tier3_mL') {
      		soqlLead += ' and (AnnualRevenue >= 5000000.00 AND AnnualRevenue < 10000000.00)';
      	} else if (revenue_mL == 'tier4_mL') {
      		soqlLead += ' and (AnnualRevenue >= 10000000.00 AND AnnualRevenue < 25000000.00)';
      	} else if (revenue_mL == 'tier5_mL') {
      		soqlLead += ' and (AnnualRevenue >= 25000000.00 AND AnnualRevenue < 50000000.00)';
      	} else if (revenue_mL == 'tier6_mL') {
      		soqlLead += ' and (AnnualRevenue >= 50000000.00 AND AnnualRevenue < 100000000.00)';
      	} else if (revenue_mL == 'tier7_mL') {
      		soqlLead += ' and (AnnualRevenue >= 100000000.00 AND AnnualRevenue < 250000000.00)';
      	} else if (revenue_mL == 'tier8_mL') {
      		soqlLead += ' and (AnnualRevenue >= 250000000.00 AND AnnualRevenue < 500000000.00)';
      	} else if (revenue_mL == 'tier9_mL') {
      		soqlLead += ' and (AnnualRevenue >= 500000000.00 AND AnnualRevenue < 2500000000.00)';
      	} else if (revenue_mL == 'tier10_mL') {
      		soqlLead += ' and (AnnualRevenue >= 2500000000.00)';
      	} else {
      		
      	}
      	
      	
      	if (employNum_mL == 'tier1_mL') {
      		soqlLead += ' and (NumberOfEmployees >= 1 AND NumberOfEmployees <= 100)';
      	} else if (employNum_mL == 'tier2_mL') {
      		soqlLead += ' and (NumberOfEmployees >= 101 AND NumberOfEmployees <= 500)';
      	} else if (employNum_mL == 'tier3_mL') {
      		soqlLead += ' and (NumberOfEmployees >= 501 AND NumberOfEmployees <= 3500)';
      	} else if (employNum_mL == 'tier4_mL') {
      		soqlLead += ' and (NumberOfEmployees > 3500)';
      	} else {
      		
      	}
      		contacts = new List<contactWrapper>();
      		leadList = new List<contactWrapper>();
			for (Contact conRec : Database.query(soqlCon + ' limit 20')) {
				contactWrapper cr = new contactWrapper(conRec);
				contacts.add(cr);
			}
			for (Lead leadRec : Database.query(soqlLead + ' limit 20')) {
				contactWrapper lr = new contactWrapper(leadRec);
				leadList.add(lr);
			}
			queryTotal = contacts.size() + leadList.size();
			querySel = selectedList.size();
    	return null;
	}
	
	public PageReference increaseSelected() {
		querySel++;
		return null;
	}
	
	public PageReference decreaseSelected() {
		querySel--;
		return null;
	}
	
	/*public PageReference contactAllSelected() {
		querySel = contacts.size();
		return null;
	}
	
	public PageReference leadAllSelected() {
		querySel = 0;
		return null;
	}*/
    
    public PageReference next() {
	selectedList.clear();
	for (contactWrapper cw : contacts) {
		if (cw.checked)
			selectedList.add(new contactWrapper(cw.conObj));
	}
	if (selectedList.size() > 0) {
		debugSoql = new List<contactWrapper>(selectedList);
		querySel = selectedList.size();
		return Page.ML_Search_Layout;
	} else {
		ApexPages.addMessage(new ApexPages.message(ApexPages.severity.ERROR,'Please select at least one Category.'));
		return null;
	}       
} 

}

Thanks so much for your time. I’m grateful for any help or suggestions on this issue.

Hey everyone,

I am currently working on a project that our organization is going to implement in our salesforce org, in order to increase user’s efficiency searching for specific contacts and leads. I proposed to create a visualforce page and an Apex controller that would allow users to search for contacts and leads in real time using javascript/jQuery/ajax. Everything seems to be working flawlessly, except for one of the two picklist fields, Revenue and Number of Employees. For both of these fields, I gave them both a list of ranged options, each representing a different tier for their respective values. After the user selects an option, the page’s Apex Controller would handle all values that were passed using conditional statements. Here are the two picklists:

<tr>
<td>
  <p>Revenue:</p>
</td>
<td>                         
  <select id="revenue_mL" onchange="runSearch();">
   <option value=""></option>
   <option value="tier1_mL">Less than $1 Million</option>
   <option value="tier2_mL">$1 million - $5 million</option>
   <option value="tier3_mL">$5 million - $10 million</option>
   <option value="tier4_mL">$10 million - under $25 million</option>
   <option value="tier5_mL">$25 million - under $50 million</option>
   <option value="tier6_mL">$50 million - under $100 million</option>
   <option value="tier7_mL">$100 million - under $250 million</option>
   <option value="tier8_mL">$250 million - under $500 million</option>
   <option value="tier9_mL">$500 million - under $2.5 billion</option>
   <option value="tier10_mL">Over $2.5 billion</option>
  </select>
</td>
</tr>
<tr>
<td>
  <p>Employees:</p>
</td>
<td>
  <select id="employNum_mL" onchange="runSearch();">
   <option value=""></option>
   <option value="tier1_mL">1-100 Employees</option>
   <option value="tier2_mL">101-500 Employees</option>
   <option value="tier3_mL">501-3,500 Employees</option>
   <option value="tier4_mL">3,500+ Employees</option>
  </select>
</td>
</tr>

Both picklists have the event, “onchange”, attributed to them. So, anytime the picklist is changed to a different value, the runSearch() function is executed. The function, runSearch(), is used to “scoop” all the data from the form using an <apex:actionFunction> tag. Here is the runSearch() javascript function:

function runSearch() {
	var e = document.getElementById("employNum_mL");
	var strUser = e.options[e.selectedIndex].value;
	var f = document.getElementById("revenue_mL");
	var strUser2 = f.options[f.selectedIndex].value;
	mainSearch(
		document.getElementById("title_mL").value,
		document.getElementById("industry_mL").value,
		document.getElementById("company_mL").value,
		strUser2,
		strUser,
		document.getElementById("zipInput").value
	);
}

Here is the actionFunction tag that sends the form parameters to the apex controller:

<apex:actionFunction name="mainSearch" action="{!runMarketingSearch}" rerender="results, resultsLead">
	  <apex:param name="title_mL" value="" />
	  <apex:param name="industry_mL" value="" />
	  <apex:param name="company_mL" value="" />
	  <apex:param name="revenue_mL" value="" />
	  <apex:param name="employNum_mL" value="" />
	  <apex:param name="zipInput" value="" />
  </apex:actionFunction>

Finally, all the data ends up in the Apex Controller. Here is the apex controller:

public with sharing class mLSearchController{
private String soqlCon {get;set;}
private String soqlLead {get;set;}
public List<Contact> contacts {get;set;}
public List<Lead> leadList {get;set;}

public mLSearchController() {
  runQuery();
}
 
public void runQuery() {
  try {
   contacts = Database.query(soqlCon + ' limit 20');
   leadList = Database.query(soqlLead + ' limit 20');
  } catch (Exception e) {
   ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
  }
}

public PageReference runMarketingSearch() {
  String title_mL = Apexpages.currentPage().getParameters().get('title_mL');
  String industry_mL = Apexpages.currentPage().getParameters().get('industry_mL');
  String company_mL = Apexpages.currentPage().getParameters().get('company_mL');
  String revenue_mL = Apexpages.currentPage().getParameters().get('revenue_mL');
  String employNum_mL = Apexpages.currentPage().getParameters().get('employNum_mL');
  String zipcode = Apexpages.currentPage().getParameters().get('zipInput');
  soqlCon = 'select firstname, lastname, Title, Email, Phone, account.Industry, MailingCity, MailingState, MailingPostalCode from Contact where account.name != null';
  soqlLead = 'select firstname, lastname, Title, Phone, Email, Industry, Company, NumberOfEmployees, AnnualRevenue, City, State, PostalCode from Lead where Company != null';
       if (!title_mL.equals('')) {
        soqlCon += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
        soqlLead += ' and Title LIKE \'%' + String.escapeSingleQuotes(title_mL) + '%\'';
       }
       if (!industry_mL.equals('')) {
        soqlCon += ' and account.Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
        soqlLead += ' and Industry LIKE \'%' + String.escapeSingleQuotes(industry_mL) + '%\'';
       }
       if (!zipcode.equals('')) {
        soqlCon += ' and MailingPostalCode LIKE \'' + String.escapeSingleQuotes(zipcode) + '%\'';
        soqlLead += ' and PostalCode LIKE \'' + String.escapeSingleQuotes(zipcode) + '%\'';
       }
       if (!company_mL.equals('')) {
        soqlLead += ' and Company LIKE \'%' + String.escapeSingleQuotes(company_mL) + '%\'';
       }
 
       // ===============================================================================================
  // THIS IS THE REVENUE CONDITIONAL STATEMENTS ALL SEEM TO WORK EXCEPT FOR tier9_mL AND tier10_mL
  // ===============================================================================================
       if (revenue_mL == 'tier1_mL') {
        soqlLead += ' and (AnnualRevenue < 1000000)';
       } else if (revenue_mL == 'tier2_mL') {
        soqlLead += ' and (AnnualRevenue >= 1000000 AND AnnualRevenue < 5000000)';
       } else if (revenue_mL == 'tier3_mL') {
        soqlLead += ' and (AnnualRevenue >= 5000000 AND AnnualRevenue < 10000000)';
       } else if (revenue_mL == 'tier4_mL') {
        soqlLead += ' and (AnnualRevenue >= 10000000 AND AnnualRevenue < 25000000)';
       } else if (revenue_mL == 'tier5_mL') {
        soqlLead += ' and (AnnualRevenue >= 25000000 AND AnnualRevenue < 50000000)';
       } else if (revenue_mL == 'tier6_mL') {
        soqlLead += ' and (AnnualRevenue >= 50000000 AND AnnualRevenue < 100000000)';
       } else if (revenue_mL == 'tier7_mL') {
        soqlLead += ' and (AnnualRevenue >= 100000000 AND AnnualRevenue < 250000000)';
       } else if (revenue_mL == 'tier8_mL') {
        soqlLead += ' and (AnnualRevenue >= 250000000 AND AnnualRevenue < 500000000)';
       } else if (revenue_mL == 'tier9_mL') {
        soqlLead += ' and (AnnualRevenue >= 500000000 AND AnnualRevenue < 2500000000)';
       } else if (revenue_mL == 'tier10_mL') {
        soqlLead += ' and (AnnualRevenue >= 2500000000)';
       } else {
       
       }
      
       if (employNum_mL == 'tier1_mL') {
        soqlLead += ' and (NumberOfEmployees >= 1 AND NumberOfEmployees <= 100)';
       } else if (employNum_mL == 'tier2_mL') {
        soqlLead += ' and (NumberOfEmployees >= 101 AND NumberOfEmployees <= 500)';
       } else if (employNum_mL == 'tier3_mL') {
        soqlLead += ' and (NumberOfEmployees >= 501 AND NumberOfEmployees <= 3500)';
       } else if (employNum_mL == 'tier4_mL') {
        soqlLead += ' and (NumberOfEmployees > 3500)';
       } else {
       
       }
       runQuery();
     return null;
}

}

   The problem that I am faced with is that the Revenue picklist is not functioning correctly, while the Number of Employees picklist is working fine. The apex seems to be appending the correct data from the revenue picklist, except for the last two values, tier9_mL and tier10_mL. Here are two lead use cases that are in my sandbox I do have two Lead cases. One lead has an annual revenue of $10,000,000, and another has $4,000,000,000. For some reason, the query is able to pull the $10 million lead, but not the $4 billion. I was hoping that any more experienced developers might be kind enough to look at my problem and help guide me to where the issue is. Any suggestions, ideas, etc. are greatly appreciated. Thanks so much for your time.

Hey everybody,

I am currently working on a Visualforce component where it will display a filtered related list on the main page layout of the "Projects" ("PE_Projects__c") custom object. I've looked up various sources on how to achieve a filtered related list, and I've created a rough bit of code to test. However, everytime I load a Projects page, an error message appears in the Visualforce window saying: "Content cannot be displayed: Cannot modify a collection while it is being iterated." After researching this error a bit, I've tried using the addAll() method to copy a finished list to the "projConList" list. However, I'm still back at square one.


Visualforce Code:

<apex:page standardController="PE_Projects__c" extensions="ProjectRolesMainClass">
     <apex:form>
    <apex:pageBlock >
        <apex:pageBlockTable value="{!projConList}" var="p">
            <apex:column value="{!p.Name}"/>
            <apex:column value="{!p.Project_Contacts_con__c}"/>
        </apex:pageBlockTable>
    </apex:pageBlock>
    </apex:form>
</apex:page>

Apex Code:

public class ProjectRolesMainClass {
    public List<Project_Contacts__c> projConList{get;set;}
    public ProjectRolesMainClass(ApexPages.StandardController controller) {
        List<Project_Contacts__c> tempList=[select Id, Project_Contacts_con__c from Project_Contacts__c where Project_Contacts_proj__c=:ApexPages.currentPage().getParameters().get('id')];
        for(Project_Contacts__c PR:tempList) {
			tempList.add(PR);
        }
        projConList.addAll(tempList);
    }
}

I was hoping some experienced VF developers would mind helping a newbie out by providing any suggestions, ideas, solutions, etc.

Thanks so much for your time.

Hey everyone,

I'm new to Apex and VisualForce, and I wanted to see if any developers out there could give a newbie like me some direction in how to tackle this project I'm working on.

In our Org, we have a custom object called "Projects", that is a child of the "Accounts" object. This object is used to store info on the status, cost, hours spent, etc. of each of our firm's projects. I am currently developing a way to easily store a number of project-specific contacts in a related list under each project. Each related list should have a default contact that is the default for all projects in the same account, but also should have the ability to add or subtract from the list.

In order to solve this, I've proposed creating a custom "junction" object to bridge "Projects" and "Contacts" under the same account. I am planning on using APEX and VisualForce to create a related list that can be set with default contacts when created, but also be flexible enough to allow the user to add new contacts for that specific project. Once all needed contacts are in the related list, the user is able to fire a Conga Composer email that sends an email to all those contacts within the related list.

At this point, this is the best solution that I have come up with. Like I said, I am new to apex coding and VisualForce, so any and all suggestions or ideas are greatly appreciated.

Thank you for your time,
Thomas

Hey,

I'm in the process of developing a custom button on Salesforce that is able to toggle a checkbox on and off.
At this point, I am using the Salesforce AJAX Toolkit in order to do the main backend functions of the custom button.
I have the backend working, but I was hoping I could have the custom button label toggle between "Start Process" and "End Process".
To do this, I assume I would need the custom button to change it's own label.
I attempted this by placing these lines in my code:

    var toggleButton = new sforce.SObject("Lead");
    var toggleButtonT ="{!Lead.Begin_Touch_Process}"; //my attempt to reference the button
    toggleButtonT.Id = "00bc0000000QoaE"; // my attempt to reference the button id
    toggleButtonT.Label = "test"; // entering new value for the button label
    result = sforce.connection.update([toggleButton]); // updating the button

NOTE:  {!RequireScript} is already mentioned in script.
It's also entirely possible that I cannot change the name of the button with the AJAX Toolkit.

I am very new to Salesforce and learning about this tool, so any ideas or suggestions will be greatly appreciated!


Thanks,
TF