-
Is there any way to create the dynamic query on the custom setting. How?
Hi all,
Is there any way to create the dynamic query on the custom setting. How?
Please give suggestion
-
1 Reply
-
Yes you can create dynamic query on custom setting .
`public List getCustomSettingList(String customSettingName,List
FieldList){
if(FieldList.size()==0)
return null;
String soqlQuery = 'SELECT ';
for(String field:FieldList){
soqlQuery+=field;
}
soqlQuery+' FROM '+customSettingName;
return Database.query(soqlQuery);
}`
Log In to reply.
Popular Salesforce Blogs
Introducing the New Salesforce Nonprofit Cloud
In collaboration with community users and partners, Salesforce is introducing a new Nonprofit Cloud! Currently, nonprofit organizations install a variety of nonprofit-related applications on top…
How to Create Profile and Manage Permissions on It | Salesforce Developer Guide
Introduction A profile in Salesforce is a group/collection of settings and permissions that define what a user can do in Salesforce. You can manage various…
What is the Flow Builder In Salesforce in 2023?
With the help of lightning flows, you may automate challenging business processes and time-consuming data entry (also known as flows). Using flows lets you work…
Popular Salesforce Videos
How to Use Salesforce for Project Management
When you think of CRM software, "Salesforce" is probably one of the first words that comes to mind. But Salesforce can do so much more…
Driving Sales Productivity and Motivations from Your Salesforce Data
Meet OneUp Sales, the revolutionary sales motivation platform built for modern sales teams. By leveraging data extracted from systems you already use, OneUp powers lively…
Send WhatsApp Messages from Salesforce Marketing Cloud
One of the longest-anticipated integrations was recently revealed by Salesforce: WhatsApp as a platform to send messages using the marketing cloud. Brands today have many…
