Apex code:
public with sharing class CallCentre
{
public String search { get; set; }
public String searchquery { get; set; }
public list <Contact> con{get;set;}
public list<contact> contact{get;set;}
public string searchstring {get;set;}
public void search()
{
string query=
'SELECT Name, Units_1__c, Email, Phone, tenant_street__c, tenant_city__c,
( SELECT SVMXC__Problem_Description__c,Type_of_Order__c
FROM SVMXC__Service_Order__r) from
Contact WHERE Tenant_Street__c like \'%'+search+'%\' Limit 10';
con = Database.query(query);
system.debug('Con List'+con.size()+con);
}
public void clear()
{
con.clear();
}
public CallCentre()
{
Id id=apexpages.currentpage().getparameters().get('ID');
contact = [SELECT Name, Units_1__c, Email , Phone, tenant_street__c,
tenant_city__c,(SELECT SVMXC__Problem_Description__c,Type_of_Order__c from SVMXC__Service_Order__r) from Contact WHERE Id= :id];
System.debug(' ***** '+ contact);
}
}
VF code:
<apex:page controller="CallCentre" sidebar="false" extensions="mycontactcontroller" >
<apex:form >
<apex:pageBlock title="Contact Service Department">
<apex:OutputText value=" Address : "/>
<apex:inputText label="Address" value="{!search}"/>
<apex:commandButton value="search" action="{!Search}" rerender="pbt"/>
</apex:pageBlock>
<apex:pageBlock title="Search Results" >
<apex:pageBlockTable id="pbt" value="{! con}" var="c">
<apex:column value="{!c.Name}"/>
<apex:column value="{!c.Units_1__c}"/>
<apex:column value="{!c.Email}"/>
<apex:column value="{!c.phone}"/>
<apex:column value="{!c.tenant_street__c}"/>
<apex:outputLink value="/apex/displaycontactrecord?id={!c.id}">{!c.name} </apex:outputLink>
</apex:column>