[SalesForce] Dynamic SOQL binding

I have some filter conditions on my page and when user selects those filter conditions I need to display all those records that satisfy those filter conditions

like suppose these are the filter conditions that user selects

(Account name = 'Account1') AND (Contact name = 'Contact1')

now I need to put that in where clause of SOQL query. I was wondering how to do that

[Select id from Object where] I need those filters to be there after where. Any help or any other workaround is much appreciated. Thanks.

Best Answer

Hold on, I have just read your comment on the other answer.

You already have your filter criteria built up into a string?

In that case, you need to build the rest of your query into the string, and use Database.query like so:

// This deduced however you like
String filterValue = '(accountname = \'account1\') and (contactname =\'contact1\')';

String queryHeader = 'SELECT Id FROM Object WHERE ';
List<sObject> results = Database.query(queryHeader + filterValue);

Or any other manipulation of strings that you like.

You can find more out about dynamic SOQL here.

Related Solutions

[SalesForce] SOSL FIND verses SOQL WHERE

Perhaps you can explain why you can't just execute the SOSL; why do you need to convert it into SOQL?

If you do need to use SOQL sometimes, it sounds like your Apex code will have to start by parsing the user's input to identify the tokens used and then decide whether to execute Dynamic SOSL or Dynamic SOQL.

The documentation for SOSL's FIND term is several pages long. Parsing something that complicated and then mapping it to roughly equivalent SOQL would be a lot of work and require a lot of tests to be written.

But as you are in control, it is up to you how much of SOSL's syntax you allow your users access to use. So I suggest you create your own "mini-language" (simpler than FIND) for the allowed user input that supports the main things you know your users need to do. That should allow you to write simpler code and fewer tests.

(Or you might provide UI somewhat like Salesforce's view filtering to make it easier for your users to create their queries. That avoids the parsing part of the problem: you just create the Dynamic SOSL or Dynamic SOQL based on the selections.)

Take care to guard against SOQL injection.

[SalesForce] Dynamic Query String Where clause concatenation

As far as I get the question, there are no such structure as WHERE 1 in apex. Based on your question, next structure may be used:

List<String> and_conditions = new List<String>();
//add some condition like/
//  and_conditions.add( ' test__c = true AND test_data__c != null ');
//  and_conditions.add(' test__c = false AND test_data__c = \'Data\' ');
String where_clause = ' ';
if (!and_conditions.isEmpty()){
    for(Integer i = 0; i < and_conditions.size(); i++){
         if(i == 0){
             where_clause = ' WHERE (' + and_conditions.get(i) + ') ';
         }else{
             where_clause +=' AND (' + and_conditions.get(i) + ') ';
         }
    }    
}

That would support only AND clause as a root clause, but that is simple enough to understand pattern, and improve it on demand.

P.S. there are some statements which are always true. Like WHERE Id != null

P.S.S. With 1.5 year more experience, code written above can be improved

List<String> and_conditions = new List<String>();
//add some condition like/
//  and_conditions.add( ' test__c = true AND test_data__c != null ');
//  and_conditions.add(' test__c = false AND test_data__c = \'Data\' ');
String where_clause = ' ';
if (!and_conditions.isEmpty()){
    where_clause = 'WHERE (' + String.join(and_conditions, ' ) AND ( ') + ')';
}

Best Answer

Related Solutions

[SalesForce] SOSL FIND verses SOQL WHERE

[SalesForce] Dynamic Query String Where clause concatenation

Related Topic