function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
システム管理者 182システム管理者 182 

SOQLでのデータ呼び出し方法について

SOQLにて呼び出したデータを、更に複数条件を指定して、フィルターをかけて絞り込むことなど出来るのでしょうか？
※LIST・MAPでは、LOOP等を行い必要が出てきてしまう為処理時間を要してしまう

もしご存じの方おられましたらご教授伊
ANUTEJANUTEJ (Salesforce Developers) 
Hi there,

>> https://salesforce.stackexchange.com/questions/12522/is-there-a-way-to-do-like-against-a-list-of-values

As mentioned in the above link, you can add the values to a list and use that list in the soql, below is an example for the same:
  
String[] filters = new String[]{'acme%','ib%'};
List<Accounts> accs = [select id, name from Account where name like :filters];

Similar to the above example you can modify it to your implementation.

Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.  

Thanks.