-
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
How to Configure Salesforce Lightning Components for Custom Actions?
Custom Actions are Object-specific actions.Object-specific actions let users create records that have automatic relationships to other records, make updates to specific records, interact with records…
CRM+Marketing Automation: A Powerful Solution to Grow your Business
Customer relationship management(CRM) helps business owners track and manage their customer base. CRM software is ideal for making the most of relationship development with existing…
Benefits of Salesforce CPQ Software for Your Sales Team
Customers don't want to be burdened with details about your sales process or the intricacies of your product catalog. The automation of business operations, especially…
Popular Salesforce Videos
Salesforce Tutorial For Beginners | Introduction To Salesforce | Salesforce Training
This video on Salesforce training will help you understand the easy and best tool for CRM and Branding. You will learn how to customize the…
Live Demo of Salesforce Industries
Watch the live demo to have a better understanding of Vlocity i.e Salesforce Industries. Let's have a glance at this extract from our latest webinar!…
Top 5 Marketing Tips to Reach Millennials | Salesforce Guide
The word “millennials” has become a buzzword in recent years Millennials or members of Generation Y (also known as Gen Y) were born between 1982…
