+ Start a Discussion
kminevkminev 

WHERE IN(myArray) query

Hi,

 

I need to run the following query in an apex trigger:

 

I need to select contact where Account.Name IN(myArrOfAccount)

 

How dow I run this in apex?

 

Here is a sample code that I am trying to run:

 

 

String[] accs = myObj.MyMultiSelectPickList__c.split(';');

								
				Contact[] contacts = [select c.Email from Contact c where c.Account.Name IN :accs and c.ActiveCustomUser__c = true];
				

 

 

The above code simply took all the values from the pick list intead of only the selected values.

 

Any ideas.

 

Thanks in advance.

the_wolfthe_wolf

Hi kminev,

 

in SOQL the join IN function work on an object  , not with a string list. (See this link )

 

For your example:

 

..WHERE c.ActiveCustomUser__c = true and c.AccountName IN (SELECT Name from Account) ] ;

Pradeep_NavatarPradeep_Navatar

In my opinion, you can use list<string> instead of string array.

 

Give the array declaration like  List<string> accs = new List<String>();

 

Hope this helps.