Hi,

      I am trying to implement some select queries in Visualforce page. I am trying implement search funtionality using two or more fields. I want to search by name or city (and also with both). But I am unable to get the result if one of the fields is blank.

searchTest page has the account name and city as the input fields.

 

And the searchtest2 page has the display in a data table.

 

The code is :

 

public class accountController {
   
   private String nameString;
   private String cityString;
   public void setNameString(String val1) {
    nameString = val1!=NULL?val1:NULL;
    }
    public String getNameString() {
    return nameString;
    }
    public void setCityString(String val2) {
    cityString = val2 != NULL ?val2:NULL;
    }
    public String getCityString() {
    return cityString;
    }
   public List<Account> getAccounts() {

    if ( nameString!=NULL&&cityString!=NULL )
    return [SELECT name,BillingStreet,BillingCity,BillingState,BillingPostalcode,Phone FROM Account WHERE Account.Name LIKE :nameString AND Account.BillingCity LIKE :cityString ORDER BY LastModifiedDate LIMIT 120];
  
    else if ( nameString == NULL  )
    return [SELECT name,BillingCity FROM Account WHERE Account.BillingCity LIKE :cityString ORDER BY LastModifiedDate LIMIT 120];
  
    else if ( nameString != NULL&&cityString == NULL )
    return [SELECT name,BillingCity FROM Account WHERE Account.Name LIKE :nameString ORDER BY LastModifiedDate LIMIT 120];
   
    else
    return null;
    
       }
    public PageReference searchAccount() {
       
        return Page.searchTest2;

 

 

 

 

Please help. Thank you

public class testTabController {
 String tabInFocus = System.currentPageReference().getParameters().get('tab');
 public String getTabInFocus() {
  return tabInFocus;
 }
 public void setTabInFocus( String s ) {
  this.tabInFocus = s;
 }
}

URL: