function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
huniversehuniverse 

select Query for StandardSetController

Hi,

 

Below is my code to get records from pagetable

 

 public ApexPages.StandardSetController con {
     
         get {
         
            if(con == null) {
                                       
               String qryString = 'select Id, Name, PLZ__c, Ort__c, Strasse__c from Account ' ;
                  MyList= Database.query(qryString);
               List<Account> qryString1 = MyList;
            con = new ApexPages.StandardSetController(qryString1);
               con.setPageSize(16);
               
            }
            
            return con;
        }
        set;
    }


    public Boolean hasNext {
        get {
            return con.getHasNext();
        }
        set;
    }

 

here PLZ__c, Ort__c, Strasse__c are textboxed i need to search the record based on user input from account table. Is there any way to modify this query in order to search and paging both work together.

 

 

Thanks,