You need to sign in to do that
Don't have an account?

How to compare a multiselect picklist with a selectlist value by Apex
Hi buddies,
i want to compare a multiselected picklist value with a selected value by a Dynamic Query,but i was getting error like :
System.QueryException: expecting a left parentheses, found 'Sales User 3%'
private string salesuserquery ;
private string salesuser{get;set;}
My query is :
salesuserquery='select id,name,Forecast_User__c,(select id,name,Amount__c from Quotas__r) from QUX_Forecast__c where (Select_Any_User__c includes \''+String.escapeSingleQuotes(salesuser)+'%\')';
List<QUX_Forecast__c> lstfrcstusrs = Database.query(salesuserquery);
Multi Picklist field : Select_Any_User__c
Is anyone could suggest me.
i want to compare a multiselected picklist value with a selected value by a Dynamic Query,but i was getting error like :
System.QueryException: expecting a left parentheses, found 'Sales User 3%'
private string salesuserquery ;
private string salesuser{get;set;}
My query is :
salesuserquery='select id,name,Forecast_User__c,(select id,name,Amount__c from Quotas__r) from QUX_Forecast__c where (Select_Any_User__c includes \''+String.escapeSingleQuotes(salesuser)+'%\')';
List<QUX_Forecast__c> lstfrcstusrs = Database.query(salesuserquery);
Multi Picklist field : Select_Any_User__c
Is anyone could suggest me.
salesuserquery='select id,name,Forecast_User__c,(select id,name,Amount__c from Quotas__r) from QUX_Forecast__c where Select_Any_User__c includes (\''+String.escapeSingleQuotes(salesuser)+'\')';
All Answers
Use ISpickval instead of includes function.
Regards,
Ashish
The comparision is by Apex not formulae fields.So any idea on that part.
salesuserquery='select id,name,Forecast_User__c,(select id,name,Amount__c from Quotas__r) from QUX_Forecast__c where Select_Any_User__c includes (\''+String.escapeSingleQuotes(salesuser)+'\')';