• bingi crm 7
  • NEWBIE
  • 15 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 14
    Questions
  • 32
    Replies
The current status of the remote service (an archiving service), including available space on the remote service
DropZonePageController uploads a file to the remote Service.
You should check the size of the file the user wants to upload.
  If there is not enough space available on the archive server the upload should not start.
 
Hi,
 I have  a issue on certificate can you please resolve this issue User-added image
Navigation please
I am new salesforce i want to save the data in database. is my reqirement  
ex:- I am working in construction department  my salesexeutive is get the data and save the database  in my salesforce org .
I create the custom object and after 10days we have get the some alter messages how we can achive this
HI,
 When we are the sandox to production two deployed after then what happening . One Example like i am create a flipkart site to  when registration form user is created that record will be save the our salesforce are any other data base .
I am try to integrated the values of this my code get json respons will not access throw the showing error
       error":"unauthorized_client","error_description":"The grant type is unauthorized for this client_id"
RestApi:
Class:-
public class Trybox {
   public string temp{get;set;}
    public PageReference Getauth() {
        return new PageReference('https://account.box.com/api/oauth2/authorize?response_type=code&client_id=wx7fximheqlekhc5e8ffiu14oa70o7m2');
    }

   public void Getauthen(){
        string code = apexpages.currentpage().getparameters().get('code');
    HttpRequest req = new HttpRequest();
     //searchtext.replaceAll(' ','+');
     req.setEndpoint('https://api.box.com/oauth2/token');
     req.setMethod('POST');
      req.setHeader('Accept','application/json');
     req.setBody('grant_type=authorization_code&code='+code+'&client_id=wx7fximheqlekhc5e8ffiu14oa70o7m2&client_secret=Ip8tJlTRAROhb6HMZ0uE1E7Uo8p0gsKb');
     Http http = new Http();
    HTTPResponse res = http.send(req);
       temp = res.getBody();
    }
}
visualforce:-
<apex:page controller="Trybox">
<apex:form >
<apex:commandButton value="Get Auth" action="{!Getauth}"/>
</apex:form>
 </apex:page>
User-added image
Visual Force:-

<apex:commandButton value="Postit" action="{!postit}"/>

Class:-
public class ChatterRestApi {
                                
    public PageReference postit() {
    Http http = new Http();
    HttpRequest req = new HttpRequest();
    
     req.setEndpoint('https://avenger2-dev-ed.my.salesforce.com/services/data/v37.0/chatter/feeds/user-profile/00528000003IL9C/feed-elements');
     req.setMethod('Post');
     req.setHeader('Authorization', 'OAuth '+UserInfo.getSessionId());
     req.setHeader('content-type','application/json');
     req.setBody('{ "body" : { "messageSegments" : [ { "type" : "Text", "text" : "When should we meet for release planning " }');
     
     HttpResponse res = http.send(req);
     System.debug(res);
        return null;
    }
}
I am write a trigger custom obj and opportunity (relationship) . 
i create one custom obj(Top_X_Designation__c) in that
1) type(picklist) Contract Flow DownHandoff 
2) Attachment (Check box)
Create one field Handoff Attached with picklist type with values are True, False on Opportunity Object.
Logic :-  If Type (Top X Designation) = "Contract Flow DownHandoff", and "Document Attached" = True then "Handoff Attached" = True, otherwise false.


trigger updaterecord on Top_X_Designation__c (after insert, after update){

  List<ID> OppIds = New List<ID>();

  for(Top_X_Designation__c  o : Trigger.new){
    if(o.Document_Attached__c == True && o.Type__c != 'Contract Flow DownHandoff'){
      OppIds.add(o.Type__c );
    }
  }

  List<Opportunity> oppList = [SELECT id, Handoff_Attached__c,Relationship__c FROM Opportunity WHERE id in :OppIds];
  for(integer i = 0 ; i < oppList.size(); i++){
    oppList[i].Handoff_Attached__c = 'True' ;
  }

  update oppList;
}
<apex:page controller="ContactSearchController1" sidebar="false">
<apex:form >
  <apex:pageMessages id="errors" />

  <apex:pageBlock title="Find Me A Customer!" mode="edit">

  <table width="100%" border="0">
  <tr>  
    <td width="200" valign="top">

      <apex:pageBlock title="Parameters" mode="edit" id="criteria">

      <script type="text/javascript">
      function doSearch() {
        searchServer(
          document.getElementById("Contact").value,
          document.getElementById("Speciality").value,
          document.getElementById("Qualification ").value,
          document.getElementById("MoblieNumber ").value,
          );
      }
      </script> 

      <apex:actionFunction name="searchServer" action="{!runSearch}" rerender="results,debug,errors">
          <apex:param name="Contact" value="" />
          <apex:param name="Speciality" value="" />
          <apex:param name="Qualification" value="" />
          <apex:param name="MoblieNumber" value="" />
      </apex:actionFunction>

      <table cellpadding="2" cellspacing="2">
      <tr>
        <td style="font-weight:bold;">Contact Area<br/>
        <input type="text" id="Contact" onkeyup="doSearch();"/>
        </td>
      </tr>
      <tr>
        <td style="font-weight:bold;">Speciality<br/>
        <input type="text" id="Speciality" onkeyup="doSearch();"/>
        </td>
      </tr>
      <tr>
        <td style="font-weight:bold;">Qualification<br/>
        <input type="text" id="Qualification" onkeyup="doSearch();"/>
        </td>
      </tr>
      </table>

      </apex:pageBlock>

    </td>
    <td valign="top">

    <apex:pageBlock mode="edit" id="results">

        <apex:pageBlockTable value="{!Doctor}" var="Doc">

            <apex:column >
                <apex:facet name="header">
                    <apex:commandLink value="Contact" action="{!toggleSort}" rerender="results,debug">
                        <apex:param name="sortField" value="Contact" assignTo="{!sortField}"/>
                    </apex:commandLink>
                </apex:facet>
                <apex:outputField value="{!Doc.Contact_Area__c}"/>
            </apex:column>

            <apex:column >
                <apex:facet name="header">
                    <apex:commandLink value="Speciality " action="{!toggleSort}" rerender="results,debug">
                        <apex:param name="sortField" value="Speciality " assignTo="{!sortField}"/>
                    </apex:commandLink>
                </apex:facet>
                <apex:outputField value="{!Doc.Speciality__c}"/>
            </apex:column>

            <apex:column >
                <apex:facet name="header">
                    <apex:commandLink value="Qualification" action="{!toggleSort}" rerender="results,debug">
                        <apex:param name="sortField" value="Qualification" assignTo="{!sortField}"/>
                    </apex:commandLink>
                </apex:facet>
                <apex:outputField value="{!Doc.Qualification__c}"/>
            </apex:column>


        </apex:pageBlockTable>

    </apex:pageBlock>

    </td>
  </tr>
  </table>

  <apex:pageBlock title="Debug - SOQL" id="debug">
      <apex:outputText value="{!debugSoql}" />           
  </apex:pageBlock>    
</apex:pageBlock>
  </apex:form>
</apex:page>


public  class ContactSearchController1 {

  // the soql without the order and limit
  public String soql {get;set;}
  // the collection of contacts to display
  public List<Doctor__c> Doctor {get;set;}

  // the current sort direction. defaults to asc
  public String sortDir {
    get  { if (sortDir == null) {  sortDir = 'asc'; } return sortDir;  }
    set;
  }

  // the current field to sort by. defaults to last name
  public String sortField {
    get  { if (sortField == null) {sortField = 'Speciality'; } return sortField;  }
    set;
  }

  // format the soql for display on the visualforce page
  public String debugSoql {
    get { return soql + ' order by ' + sortField + ' ' + sortDir + ' limit 20'; }
    set;
  }

  // init the controller and display some sample data when the page loads
  public ContactSearchController1() {
    soql = 'select name, Contact_Area__c, Speciality__c, Qualification__c,Mobile_Number__c,Email__c from Doctor__c where name != null';
    runQuery();
  }

  // toggles the sorting of query from asc<-->desc
 public void toggleSort() {
    // simply toggle the direction
    sortDir = sortDir.equals('asc') ? 'desc' : 'asc';
    // run the query again
    runQuery();
  }

  // runs the actual query
 public void runQuery() {

    try {
      Doctor = Database.query(soql + ' order by ' + sortField + ' ' + sortDir + 'limit 20');
    } 
    catch (Exception e) {
      ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
    }

  } 

  // runs the search with parameters passed via Javascript
  public PageReference runSearch() {

    String ContactArea = Apexpages.currentPage().getParameters().get('ContactArea');
    String Speciality = Apexpages.currentPage().getParameters().get('Speciality');
    String Qualification = Apexpages.currentPage().getParameters().get('Qualification');
    String MoblieNumber = Apexpages.currentPage().getParameters().get('Moblie Number');
    String Email = Apexpages.currentPage().getParameters().get('Email');

    soql = 'select name, Contact_Area__c, Speciality__c, Qualification__c,Mobile_Number__c,Email__c from Doctor__c where name != null';
    if (!ContactArea.equals(''))
      soql += ' and ContactAreaincludes (\''+ContactArea+'\')';
   // if (!Contact_Area__c.equals(''))
  // soql += ' and Contact_Area__c LIKE \''+String.escapeSingleQuotes(Contact)+'%\'';
    if (!Speciality.equals(''))
      soql += ' and Speciality LIKE \''+String.escapeSingleQuotes(Speciality)+'%\'';
    if (!Qualification.equals(''))
      soql += ' and Qualification LIKE \''+String.escapeSingleQuotes(Qualification)+'%\'';
    if (!MoblieNumber.equals(''))
      soql += ' and MoblieNumber includes (\''+MoblieNumber+'\')';
    if (!Email.equals(''))
      soql += ' and Email includes (\''+Email+'\')';
    // run the query again
    runQuery();

    return null;
  }
  }
User-added image
visual force page
<apex:page standardController="OpportunityLineItem" extensions="Displayprods1">
    <apex:form>
    <apex:pageBlock>
        <apex:repeat value="{!OppList}" var="a">
            <apex:inputText  value="{!a.name}"/>
            <apex:inputText  value="{!a.Quantity}"/>
            <apex:inputText  value="{!a.ListPrice}"/>
            <apex:inputText  value="{!a.nameTotalPrice}"/>
        </apex:repeat>
    </apex:pageBlock> 
    </apex:form>
</apex:page>

class controller
public class Displayprods1
{
    public List<OpportunityLineItem> proList{get;set;}
    List<OpportunityLineItemwrapper> OppList  {get;set;}
    public Displayprods1(ApexPages.StandardController controller)
    {
        OppList = new List<OpportunityLineItemwrapper>();
    }
    public OpportunityLineItem[] getOpportunityLineItemlist() {
        return [select id,Quantity,ListPrice,TotalPrice from OpportunityLineItem limit10];
        
    }
    public void populate()
    {
        list<OpportunityLineItem > plist = [select id,Quantity,ListPrice,TotalPrice from OpportunityLineItem limit10];
        for(OpportunityLineItem pr:plist)
        {
            OpportunityLineItemwrapper w1 = new OpportunityLineItemwrapper();
            w1.name = pr.name;
            w1.Quantity = Integer.valueOf(pr.Quantity);
            w1.ListPrice = pr.ListPrice;
            w1.TotalPrice = pr.TotalPrice;
            OppList.add(w1);
        }
    }
}
wrapper class
public class OpportunityLineItemwrapper {
// all the line record instance create
        public OpportunityLineItem pro{get; set;} 
        public  string name {get;set;}
        public  integer Quantity {get;set;} // number
        public  decimal ListPrice {get;set;} // currency
        public  decimal TotalPrice {get;set;} // currency 
        public  Boolean selected {get; set;} // true
        public OpportunityLineItemwrapper()
        {      
               name  = '';
               Quantity = 0;
               ListPrice = 0 ;
               TotalPrice = 0;
        }
     
}
public class Displayprods1
{
public List<OpportunityLineItem> proList{get;set;}
public list<wrapper1> wrp{get;set;}
List<OpportunityLineItemwrapper> OppList = new List<OpportunityLineItemwrapper>();
public Displayprods1(ApexPages.StandardController controller)
{
}
public void populate(){
list<OpportunityLineItem > plist = [select id,Quantity,ListPrice,TotalPrice from OpportunityLineItem limit10];
for(OpportunityLineItem pr:plist){
wrapper1 w1 = new wrapper1();
w1.name = pr.name;
w1.Quantity = pr.Quantity;
w1.ListPrice = pr.ListPrice;
w1.TotalPrice = pr.TotalPrice;
wrp.add(w1);
}
}
}
-------------------------------------------------------------------
wrapper class
public class OpportunityLineItemwrapper
{
// all the line record instance create
public OpportunityLineItem pro{get; set;}
public string name {get;set;}
public integer Quantity {get;set;}
public decimal ListPrice {get;set;}
public decimal TotalPrice {get;set;}
 public Boolean selected {get; set;}
 public OpportunityLineItemwrapper() { name = ''; Quantity = 0 ; ListPrice = 0 ; TotalPrice = 0;
}
}
public class Displayprods
{

 //This is where we have defined the Wrapper Class. 
    public class OpportunityLineItemwrapper
    {
      // all the line record instance create
        public OpportunityLineItem prd{get; set;}
        public Boolean selected {get; set;}
        public OpportunityLineItemwrapper(OpportunityLineItem a)
        {
            prd = a;
            selected = false;
        }
    }
 // This is the Wrapper Name for the object Opportunity Line Items
    List<OpportunityLineItemwrapper> OppList = new List<OpportunityLineItemwrapper>();
    List<OpportunityLineItem> selectedProducts = new List<OpportunityLineItem>();

 //Defines a Map to store all items selected based on the ID from the  ID from the URl.
    Map<Id,OpportunityLineItem> selectedProductsMap = new Map<Id,OpportunityLineItem>();
   

    public Displayprodsinopprtunity(ApexPages.StandardController controller) {

    }
        
    public List<OpportunityLineItemwrapper> getProducts() {
        ID str = ApexPages.currentPage().getParameters().get('ID');         
        OppList.clear();
        
        for(OpportunityLineItem a : [Select Id,Quantity,
ListPrice,PricebookEntry.Product2Id,TotalPrice
 PricebookEntry.Name From OpportunityLineItem
 where Opportunity.id=:str]){
            
            
            OpportunityLineItemwrapper opplineItem = new OpportunityLineItemwrapper(a);            
            if (selectedProductsMap.get(a.Id) != null)
                opplineItem.selected = true;

            OppList.add(opplineItem);        
        }
        return OppList;
    }
    
    public PageReference getSelected() {
        selectedProducts.clear();
        for(OpportunityLineItemwrapper accwrapper : OppList)
        if(accwrapper.selected == true) {
            selectedProducts.add(accwrapper.prd);
            selectedProductsMap.put(accwrapper.prd.id, accwrapper.prd);
        }
        return null;    
        
    }
    
    public List<OpportunityLineItem> GetSelectedProducts()  {
        if(selectedProducts.size()>0)
   return selectedProducts;
        else
   return null;
    }    

    public void updateQuantity() {
        List<Id> SelectedIds = new List<Id>();
       
        for(OpportunityLineItem litem: selectedProducts) {            
             OpportunityLineItem updateQuantity = new OpportunityLineItem (Id=litem.Id,Quantity=22); 
             Update updateQuantity ;            
        }      
    }
        }
i am writing the visual force using extension on the page they are showing the required filed has missing wTHIS IS VF PAGESHOW ERROR MESSAGE 
public class leaddetails {
    public lead leads{set;get;}
    public lead lead{set;get;}
    public leaddetails(ApexPages.StandardController controller){
        leads =(lead)controller.getRecord();
    }
    public pageReference createLead(){
        if(leads.name!=null){
            account acc=new account();
            acc.Name=lead.name;
            acc.Parentid= lead.company;
            acc.AnnualRevenue=lead.AnnualRevenue;
            acc.Fax=lead.Fax;
            acc.Type='Other';
            acc.Phone=lead.MobilePhone;
            acc.Industry=lead.Industry;
            insert acc;
            contact con=new contact();
             con.lastName=lead.lastName;
            con.firstName=lead.firstName;
            con.Description=lead.Industry;
            con.Title=acc.Name;
            con.Email=lead.Email;
            con.Phone=lead.MobilePhone;
            insert con;
             pageReference p=new pageReference('/'+acc.id);
            return p;
         }else{
        Insert leads;
         pageReference p=new pageReference('/'+leads.id);
            return p;

}
   }
    public void cancelLead(){
        lead=null;
    }
}
 
Hi,
 I have  a issue on certificate can you please resolve this issue User-added image
Navigation please
I am try to integrated the values of this my code get json respons will not access throw the showing error
       error":"unauthorized_client","error_description":"The grant type is unauthorized for this client_id"
RestApi:
Class:-
public class Trybox {
   public string temp{get;set;}
    public PageReference Getauth() {
        return new PageReference('https://account.box.com/api/oauth2/authorize?response_type=code&client_id=wx7fximheqlekhc5e8ffiu14oa70o7m2');
    }

   public void Getauthen(){
        string code = apexpages.currentpage().getparameters().get('code');
    HttpRequest req = new HttpRequest();
     //searchtext.replaceAll(' ','+');
     req.setEndpoint('https://api.box.com/oauth2/token');
     req.setMethod('POST');
      req.setHeader('Accept','application/json');
     req.setBody('grant_type=authorization_code&code='+code+'&client_id=wx7fximheqlekhc5e8ffiu14oa70o7m2&client_secret=Ip8tJlTRAROhb6HMZ0uE1E7Uo8p0gsKb');
     Http http = new Http();
    HTTPResponse res = http.send(req);
       temp = res.getBody();
    }
}
visualforce:-
<apex:page controller="Trybox">
<apex:form >
<apex:commandButton value="Get Auth" action="{!Getauth}"/>
</apex:form>
 </apex:page>
User-added image
I am write a trigger custom obj and opportunity (relationship) . 
i create one custom obj(Top_X_Designation__c) in that
1) type(picklist) Contract Flow DownHandoff 
2) Attachment (Check box)
Create one field Handoff Attached with picklist type with values are True, False on Opportunity Object.
Logic :-  If Type (Top X Designation) = "Contract Flow DownHandoff", and "Document Attached" = True then "Handoff Attached" = True, otherwise false.


trigger updaterecord on Top_X_Designation__c (after insert, after update){

  List<ID> OppIds = New List<ID>();

  for(Top_X_Designation__c  o : Trigger.new){
    if(o.Document_Attached__c == True && o.Type__c != 'Contract Flow DownHandoff'){
      OppIds.add(o.Type__c );
    }
  }

  List<Opportunity> oppList = [SELECT id, Handoff_Attached__c,Relationship__c FROM Opportunity WHERE id in :OppIds];
  for(integer i = 0 ; i < oppList.size(); i++){
    oppList[i].Handoff_Attached__c = 'True' ;
  }

  update oppList;
}
<apex:page controller="ContactSearchController1" sidebar="false">
<apex:form >
  <apex:pageMessages id="errors" />

  <apex:pageBlock title="Find Me A Customer!" mode="edit">

  <table width="100%" border="0">
  <tr>  
    <td width="200" valign="top">

      <apex:pageBlock title="Parameters" mode="edit" id="criteria">

      <script type="text/javascript">
      function doSearch() {
        searchServer(
          document.getElementById("Contact").value,
          document.getElementById("Speciality").value,
          document.getElementById("Qualification ").value,
          document.getElementById("MoblieNumber ").value,
          );
      }
      </script> 

      <apex:actionFunction name="searchServer" action="{!runSearch}" rerender="results,debug,errors">
          <apex:param name="Contact" value="" />
          <apex:param name="Speciality" value="" />
          <apex:param name="Qualification" value="" />
          <apex:param name="MoblieNumber" value="" />
      </apex:actionFunction>

      <table cellpadding="2" cellspacing="2">
      <tr>
        <td style="font-weight:bold;">Contact Area<br/>
        <input type="text" id="Contact" onkeyup="doSearch();"/>
        </td>
      </tr>
      <tr>
        <td style="font-weight:bold;">Speciality<br/>
        <input type="text" id="Speciality" onkeyup="doSearch();"/>
        </td>
      </tr>
      <tr>
        <td style="font-weight:bold;">Qualification<br/>
        <input type="text" id="Qualification" onkeyup="doSearch();"/>
        </td>
      </tr>
      </table>

      </apex:pageBlock>

    </td>
    <td valign="top">

    <apex:pageBlock mode="edit" id="results">

        <apex:pageBlockTable value="{!Doctor}" var="Doc">

            <apex:column >
                <apex:facet name="header">
                    <apex:commandLink value="Contact" action="{!toggleSort}" rerender="results,debug">
                        <apex:param name="sortField" value="Contact" assignTo="{!sortField}"/>
                    </apex:commandLink>
                </apex:facet>
                <apex:outputField value="{!Doc.Contact_Area__c}"/>
            </apex:column>

            <apex:column >
                <apex:facet name="header">
                    <apex:commandLink value="Speciality " action="{!toggleSort}" rerender="results,debug">
                        <apex:param name="sortField" value="Speciality " assignTo="{!sortField}"/>
                    </apex:commandLink>
                </apex:facet>
                <apex:outputField value="{!Doc.Speciality__c}"/>
            </apex:column>

            <apex:column >
                <apex:facet name="header">
                    <apex:commandLink value="Qualification" action="{!toggleSort}" rerender="results,debug">
                        <apex:param name="sortField" value="Qualification" assignTo="{!sortField}"/>
                    </apex:commandLink>
                </apex:facet>
                <apex:outputField value="{!Doc.Qualification__c}"/>
            </apex:column>


        </apex:pageBlockTable>

    </apex:pageBlock>

    </td>
  </tr>
  </table>

  <apex:pageBlock title="Debug - SOQL" id="debug">
      <apex:outputText value="{!debugSoql}" />           
  </apex:pageBlock>    
</apex:pageBlock>
  </apex:form>
</apex:page>


public  class ContactSearchController1 {

  // the soql without the order and limit
  public String soql {get;set;}
  // the collection of contacts to display
  public List<Doctor__c> Doctor {get;set;}

  // the current sort direction. defaults to asc
  public String sortDir {
    get  { if (sortDir == null) {  sortDir = 'asc'; } return sortDir;  }
    set;
  }

  // the current field to sort by. defaults to last name
  public String sortField {
    get  { if (sortField == null) {sortField = 'Speciality'; } return sortField;  }
    set;
  }

  // format the soql for display on the visualforce page
  public String debugSoql {
    get { return soql + ' order by ' + sortField + ' ' + sortDir + ' limit 20'; }
    set;
  }

  // init the controller and display some sample data when the page loads
  public ContactSearchController1() {
    soql = 'select name, Contact_Area__c, Speciality__c, Qualification__c,Mobile_Number__c,Email__c from Doctor__c where name != null';
    runQuery();
  }

  // toggles the sorting of query from asc<-->desc
 public void toggleSort() {
    // simply toggle the direction
    sortDir = sortDir.equals('asc') ? 'desc' : 'asc';
    // run the query again
    runQuery();
  }

  // runs the actual query
 public void runQuery() {

    try {
      Doctor = Database.query(soql + ' order by ' + sortField + ' ' + sortDir + 'limit 20');
    } 
    catch (Exception e) {
      ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
    }

  } 

  // runs the search with parameters passed via Javascript
  public PageReference runSearch() {

    String ContactArea = Apexpages.currentPage().getParameters().get('ContactArea');
    String Speciality = Apexpages.currentPage().getParameters().get('Speciality');
    String Qualification = Apexpages.currentPage().getParameters().get('Qualification');
    String MoblieNumber = Apexpages.currentPage().getParameters().get('Moblie Number');
    String Email = Apexpages.currentPage().getParameters().get('Email');

    soql = 'select name, Contact_Area__c, Speciality__c, Qualification__c,Mobile_Number__c,Email__c from Doctor__c where name != null';
    if (!ContactArea.equals(''))
      soql += ' and ContactAreaincludes (\''+ContactArea+'\')';
   // if (!Contact_Area__c.equals(''))
  // soql += ' and Contact_Area__c LIKE \''+String.escapeSingleQuotes(Contact)+'%\'';
    if (!Speciality.equals(''))
      soql += ' and Speciality LIKE \''+String.escapeSingleQuotes(Speciality)+'%\'';
    if (!Qualification.equals(''))
      soql += ' and Qualification LIKE \''+String.escapeSingleQuotes(Qualification)+'%\'';
    if (!MoblieNumber.equals(''))
      soql += ' and MoblieNumber includes (\''+MoblieNumber+'\')';
    if (!Email.equals(''))
      soql += ' and Email includes (\''+Email+'\')';
    // run the query again
    runQuery();

    return null;
  }
  }
User-added image
visual force page
<apex:page standardController="OpportunityLineItem" extensions="Displayprods1">
    <apex:form>
    <apex:pageBlock>
        <apex:repeat value="{!OppList}" var="a">
            <apex:inputText  value="{!a.name}"/>
            <apex:inputText  value="{!a.Quantity}"/>
            <apex:inputText  value="{!a.ListPrice}"/>
            <apex:inputText  value="{!a.nameTotalPrice}"/>
        </apex:repeat>
    </apex:pageBlock> 
    </apex:form>
</apex:page>

class controller
public class Displayprods1
{
    public List<OpportunityLineItem> proList{get;set;}
    List<OpportunityLineItemwrapper> OppList  {get;set;}
    public Displayprods1(ApexPages.StandardController controller)
    {
        OppList = new List<OpportunityLineItemwrapper>();
    }
    public OpportunityLineItem[] getOpportunityLineItemlist() {
        return [select id,Quantity,ListPrice,TotalPrice from OpportunityLineItem limit10];
        
    }
    public void populate()
    {
        list<OpportunityLineItem > plist = [select id,Quantity,ListPrice,TotalPrice from OpportunityLineItem limit10];
        for(OpportunityLineItem pr:plist)
        {
            OpportunityLineItemwrapper w1 = new OpportunityLineItemwrapper();
            w1.name = pr.name;
            w1.Quantity = Integer.valueOf(pr.Quantity);
            w1.ListPrice = pr.ListPrice;
            w1.TotalPrice = pr.TotalPrice;
            OppList.add(w1);
        }
    }
}
wrapper class
public class OpportunityLineItemwrapper {
// all the line record instance create
        public OpportunityLineItem pro{get; set;} 
        public  string name {get;set;}
        public  integer Quantity {get;set;} // number
        public  decimal ListPrice {get;set;} // currency
        public  decimal TotalPrice {get;set;} // currency 
        public  Boolean selected {get; set;} // true
        public OpportunityLineItemwrapper()
        {      
               name  = '';
               Quantity = 0;
               ListPrice = 0 ;
               TotalPrice = 0;
        }
     
}