-
How to use IN clause in Dynamic query?
Can we use IN clause in dynamic query? please give the example.
-
3 Replies
-
MAP<ID,Opportunity> os = new MAP<Id,Opportunity>([Select ID from Opportunity]);
SET<ID> keys = os.keyset();
String s = 'SELECT RecordTypeId, COUNT(Id) os FROM Opportunity Where Id IN ';
s+=':keys GROUP BY RecordTypeId';
AggregateResult[] ars = Database.query(s);
System.debug(ars[0].get('RecordTypeId')); -
It is very simple assume you have a Set<String> or Set<Id> named "ids"
Set ids = new Set();
String dynamicQuery = "SELECT ID FROM SomeObject__c WHERE SomeID IN :ids";
Database.query(dynamicQuery);
You don't have to do anything when complier will compile the code it will find set of ids and put it into your query
-
Hi
list<string> setAccIds = new list<string>();
setAccIds .addAll(AcctoCon_Sync.keySet());AccQuery = 'SELECT Id ,AccArticleId , ' + title + ',' + answer + ' FROM ' + articleType;
AccQuery += ' WHERE PublishStatus = \'Online\' AND language = \'en_US\' AND AccQuery IN :' + setAccIds ;Thanks
Log In to reply.
Popular Salesforce Blogs
Salesforce Configuration Vs Salesforce Customization and Their Best Practices
What Is Configuration In Salesforce? Salesforce design is everything you can do inside the CRM framework. This implies you can add another field to your…
Customer Success With Salesforce Customer Portal | The Ultimate Guide
Tech writers are in a unique position to understand the products and portals they write about thoroughly. Not only portals but also how self-service changes…
MuleSoft, the Integration Platform You Need | Salesforce
Normally, most companies use some type of software to carry out their business process management and administration. On many occasions, they use several different software,…
Popular Salesforce Videos
Salesforce Video Wall
Salesforce approached Obscura with the opportunity to create imaginative media for the 107’ long LED video wall in the lobby of their flagship San Francisco…
Salesforce Security – An Encryption Guide For The Paranoid
If you are using Salesforce, you would be having a lot of data stored in Salesforce objects. Some of it would even be sensitive enough…
Salesforce For Non Programmers | Salesforce For Non Technicals
You can learn Salesforce without any programming language. You can plan Salesforce Administrator Certification which requires no coding skills. Watch this video to learn how.
