You need to sign in to do that
Don't have an account?
Vandana Rattan
Display SOQL results in Visualforce page
I have created a Custom Lead Convert Page. I need to show a list of duplicate contacts on Lead Conversion. I have been trying to do so using Apex:Repeat and Apex:PageBlockTable but nothing is getting displayed. My SOQL does return results. Kindly suggest. My Controller and Visualforce Page are given below:-
VisualForce Page:
VisualForce Page:
<apex:page standardController="Lead" extensions="LeadConvertController"> <apex:includescript value="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" /> <apex:sectionHeader title="Convert {!$ObjectType.Lead.label}" subtitle="{!Lead.name}"/> <apex:form id="leadForm"> <apex:pageBlock mode="edit" > <apex:pageblockbuttons > <apex:commandbutton value="Convert" action="{!ConvertLead}"/> <apex:commandbutton value="Cancel" action="{!Cancel}"/> </apex:pageblockbuttons> <apex:pageblocksection id="LeadConvertPBS" title="Convert Lead"> <apex:pageBlockSectionItem > <apex:outputLabel value=" Record Owner" for="Record Owner"/> <apex:inputField value="{!lead.OwnerID}" id="recOwner1" /> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem > <apex:outputLabel for="Account Name">Account Name</apex:outputLabel> <apex:inputField required="true" id="company" value="{!lead.Company}" /> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem > <apex:OutputLabel for="Send Email to the Owner">Send Email to the Owner</apex:OutputLabel> <apex:inputCheckbox onclick="{!lead.Ownerid}"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem > <apex:outputLabel for="Oppt Name">Opportunity Name:</apex:outputLabel> <apex:inputField required="true" id="opptName" value="{!lead.Company}" /> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem > <apex:outputLabel for="ConStatus">Converted Status:</apex:outputLabel> <apex:inputField id="ConStatus" value="{!lead.Status}" /> </apex:pageBlockSectionItem> <apex:pageblockSectionItem > <!-- <apex:outputLabel for="no oppty">Do not create new opportunity upon conversion</apex:outputLabel> <apex:inputCheckbox id="noOppty"/>--> </apex:pageblockSectionItem> </apex:pageblocksection> <!--<apex:outputPanel id="contactList" layout="block"> <apex:pageBlockSection title="Contact List"> </apex:pageBlockSection> <apex:repeat value="{!lstDupContact}"> <apex:outputText value="{!lstDupContact}"></apex:outputText> </apex:repeat> </apex:outputPanel>--> <apex:pageBlockTable value="{!lstDupContact}" var="ct"> <apex:column value="{!ct.id}"/> <apex:column value="{!ct.firstName}"/> <apex:column value="{!ct.lastName}"/> </apex:pageBlockTable> </apex:pageBlock> </apex:form> </apex:page>
public class LeadConvertController{ Lead lead; public List<Contact> lstDupContact {get; set;} public LeadConvertController(ApexPages.StandardController controller) { this.lead = (Lead)controller.getRecord(); } public PageReference ConvertLead(){ System.debug('Inside Lead Convert Controller'); Database.LeadConvert lc = new database.LeadConvert(); lc.setLeadId(lead.Id); Lead leadRecord = [SELECT firstName, lastName, email from lead where id =: lead.Id]; System.debug('lead Owner >> ' + lead.OwnerId); //GroupMember grpMember = [Select UserOrGroupId from groupmember where groupid= :lead.OwnerId]; //System.debug('GroupMember--->' + grpMember.UserOrGroupId); //lc.setOwnerId(grpMember.UserOrGroupId); lc.setConvertedStatus('Qualified'); // Database.LeadConvertResult lcr = Database.convertLead(lc); //if(lcr.isSuccess()){ // String aId = lcr.getAccountId(); lstDupContact = [SELECT id, firstName, lastName, email from Contact where (firstName =: leadRecord.FirstName OR lastName =: leadRecord.LastName) AND email =: leadRecord.email]; System.debug('lstDupContacts >>>' + lstDupContact); PageReference redirect = new PageReference('https://c.cs7.visual.force.com/apex/CustomLeadConvert?retURL=%2F00QM0000005IVfb&scontrolCaching=1&id=00QM0000005IVfb&id=' + lead.Id + '&sfdc.override=1'); redirect.setRedirect(false); return redirect; //} return new PageReference('/'+''); } public List<Contact> getLstDupContact(){ return lstDupContact; } }
All Answers