Apex Code Development You need to sign in to do that
Don't have an account?
Zuhair Shaikh Want to make a simple form that takes in a number and then searches records in a custom object containing that number
Hello folks. I have a custom object containing 125 records, from Joe Smith1 to Joe Smith125 (The numbers are part of the last name). I want to make a visualforce page that has one textbox and one button and if you enter a number like "12" in the text box and hit the button, it should then list all the records where Fname+Lname(Custom fields in the custom object) contain "12". The list should also be in a table/grid. I'd also appreciate help with creating a custom controller for this page.
This seems like a simple problem but none of the visualforce workbooks I have gone through let me know how to accomplish something like this. Thanks in advance.
This seems like a simple problem but none of the visualforce workbooks I have gone through let me know how to accomplish something like this. Thanks in advance.
Apex
public class OppsList{ // ApexPages.StandardSetController must be instantiated // for standard list controllers public String filterText {get; set;} public ApexPages.StandardSetController setCon { get { String sSOQL = 'SELECT Name, CloseDate FROM Opportunity'; if ((filterText != null) && (filterText != '')){ sSOQL += ' WHERE Name Like \'%' + filterText + '%\''; } setCon = new ApexPages.StandardSetController(Database.getQueryLocator(sSOQL)); return setCon; } set; } // Initialize setCon and return a list of records public List<Opportunity> getOpportunities() { return (List<Opportunity>) setCon.getRecords(); } }VF Page<apex:page controller="OppsList"> <apex:form> <apex:pageBlock> <apex:pageBlockSection> <apex:pageBlockSectionItem> <apex:inputText value="{!filterText}" id="filterText"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem> <apex:commandButton id="Filter" value="Filter"/> </apex:pageBlockSectionItem> </apex:pageBlockSection> </apex:pageBlock> </apex:form> <apex:pageBlock> <apex:pageBlockTable value="{!opportunities}" var="o"> <apex:column value="{!o.Name}"/> <apex:column value="{!o.CloseDate}"/> </apex:pageBlockTable> </apex:pageBlock> </apex:page>Let me know if this helps you.All Answers
Apex
public class OppsList{ // ApexPages.StandardSetController must be instantiated // for standard list controllers public String filterText {get; set;} public ApexPages.StandardSetController setCon { get { String sSOQL = 'SELECT Name, CloseDate FROM Opportunity'; if ((filterText != null) && (filterText != '')){ sSOQL += ' WHERE Name Like \'%' + filterText + '%\''; } setCon = new ApexPages.StandardSetController(Database.getQueryLocator(sSOQL)); return setCon; } set; } // Initialize setCon and return a list of records public List<Opportunity> getOpportunities() { return (List<Opportunity>) setCon.getRecords(); } }VF Page<apex:page controller="OppsList"> <apex:form> <apex:pageBlock> <apex:pageBlockSection> <apex:pageBlockSectionItem> <apex:inputText value="{!filterText}" id="filterText"/> </apex:pageBlockSectionItem> <apex:pageBlockSectionItem> <apex:commandButton id="Filter" value="Filter"/> </apex:pageBlockSectionItem> </apex:pageBlockSection> </apex:pageBlock> </apex:form> <apex:pageBlock> <apex:pageBlockTable value="{!opportunities}" var="o"> <apex:column value="{!o.Name}"/> <apex:column value="{!o.CloseDate}"/> </apex:pageBlockTable> </apex:pageBlock> </apex:page>Let me know if this helps you.