Hi friends,

 i want to show leads which are associated with email domains on a visualforce page (which i use it in lead page layout).

For Ex :-

A lead with email 1234@ABC.com is existing in my leads.
When a new lead is created with the same domain 56789@ABC.com.  Then the prevoius lead should be shown in the visualforce page (which i use it in lead page layout).


I tried it but could not get it solved : 

here is my Visualforce page and Extension controller, please do make any changes :


<apex:page standardController="Lead" extensions="GetDomain">
   <apex:pageBlock >
      <apex:pageBlockTable value="{!LeadLst}" var="ld">
         <apex:column value="{!ld.Name}"/>
         <apex:column value="{!ld.Email}"/>
         <apex:column value="{!ld.PartnerAccount.Name}" headerValue="Account"/>
      </apex:pageBlockTable>
   </apex:pageBlock>
</apex:page>


CONTROLLER :

public with sharing class GetDomain {

    public List<Lead> LeadLst { get; set; }

    public GetDomain(ApexPages.StandardController controller) {
        String email = '%' + [SELECT Name, Email, PartnerAccount.Name FROM Lead WHERE Id =: apexpages.currentpage().getparameters().get('id')].email.substringAfter('@')+ '%';
        LeadLst = [SELECT Name, Email FROM Lead WHERE Email LIKE: email];      
    }

}


Did i miss anything that should be there.!


Any help would be approciated.

Thanks,
Avinash Guptha