[SalesForce] SOQL query with Multi Select Picklist in where clause

I am trying to build a query in Apex code to fetch all records where a multi select picklist has either of 2 values selected. When I build my query and string as option 1 it does not return back any data . However option 2 returns back corrent number of rows.

option1

    string str = '\'Ann-OP\',\'Ann-RP\'';

    List<Announcement__c> aL = [SELECT Id, Name FROM Announcement__c 
                                  WHERE Public_groups__c INCLUDES (:str) ];

option2

    List<Announcement__c> aL = [SELECT Id, Name FROM Announcement__c 
                                 WHERE Public_groups__c INCLUDES('Ann-OP', 'Ann-RP') ];

Best Answer

SOQL reads String str = '\'Ann-OP\',\'Ann-RP\''; as a single Picklist value rather than two Picklist values Ann-Op and Ann-RP.

Try writing a dynamic SOQL query.

Example:

List<String> includesList = new List<String>{'\'Ann-OP\'','\'Ann-RP\''};
String queryString = 'SELECT Id, Name FROM Announcement__c  WHERE Public_groups__c INCLUDES(';
for(String includeValue :includesList)
    queryString += includeValue + ',';
queryString = queryString.removeEnd(',') +')';
List<Announcement__c> aL = (List<Announcement__c>)Database.query(queryString);

Related Solutions

[SalesForce] Creating multi-select picklist\selectoption list through query

Visual Force Page

<apex:page standardController="Contract" extensions="newContractController" >
<apex:form >
    <apex:inputfield value="{!myContract.AccountId}">
        <apex:actionSupport event="onchange" action="{!accountChanged}" />
    </apex:inputfield>

    <apex:selectList value="{!selectedSubAccounts}" >
        <apex:selectOptions value="{!subAccountOptions}" />        
    </apex:selectList>

</apex:form>

Controller

public class newContractController {

    public List<SelectOption> subAccountOptions { get; set; }
    public string [] selectedSubAccounts { get; set; }

    public Id accountId { get; set; }
    public Contract myContract { get; set; }

    public newContractController(ApexPages.StandardController controller) {
        myContract =  new Contract();
    }

    public void accountChanged() {

        Account [] accounts = [SELECT Name, Id FROM Account WHERE ParentId = :myContract.AccountId];

        List<SelectOption> options = new List<SelectOption>();

        for (Account a : accounts) {
            options.add(new SelectOption(a.Id,a.Name));        
        }

        subAccountOptions = options;

    }

}

Here's something that may help. Accounts already have a field called Parent Account which will allow for a hierarchy of Accounts. You may want to use that instead of creating a custom Sub Account.

In this page when you pick an Account it will cause an event which will query for all Accounts that whose parent is the one you just picked

[SalesForce] Creating a dynamic multi-select picklist

I've had simliar requirements and the jQuery Multi-Select works fantastically well for this. In particular the filtered version is amazing if you have a lot of options to choose from.

Multi-Select w/Filters

Multi-Select w/Filters

Best Answer

Related Solutions

[SalesForce] Creating multi-select picklist\selectoption list through query

[SalesForce] Creating a dynamic multi-select picklist

Related Topic