-
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
Service Cloud in Salesforce - Learn All About it Here!
This area of the Salesforce platform is dedicated to supporting and helping our customers. As a result, customers are happier and more loyal, contributing to…
Salesforce Interview Questions You Need to Know in 2024
Here are some potential line-based Salesforce interview questions that you could include in a blog post: Interview Questions to Crack your Next Interview 1. What…
Object Records Creation Using CSV File | Salesforce Guide
When the records and column values on the CSV file contain quotations, uploading the CSV file to create records becomes complicated. As a result, I…
Popular Salesforce Videos
Drive Adoption with In-App Guidance and our Prebuilt Salesforce Package!
With In-App Guidance generally available in the Winter ‘20 release, there’s no better time to start taking advantage of the easiest way to add informative…
Salesforce Resume Review
Salesforce is a well-known company and leader in the cloud computing space so we would say it would be an asset on a resume. Thinking…
Salesforce Visualforce and Force.com Development Tutorial || Beginner
Learn to set up a web page using force.com and create forms for users to input information into Salesforce. For more Salesforce tips and tricks…