-
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
Top 10 Forecasted CRM Trends In 2021 | Salesforce
Times are changing, which means implementing innovations and new ways of interacting with this simple business tool for CRM software users. What’s going to be…
Top 10 Salesforce Winter ’21 Features for Reimagining your Experience Cloud Journey
As is the norm with all feature update releases, Salesforce’s Winter ’21 release is packed with features that add fluidity to workflows and help businesses achieve…
Driving Sales Efficiency with Salesforce CPQ Services: A Complete Guide for Modern Businesses
In the age of digital selling, speed, accuracy, and personalization define the success of every sales team. Traditional quoting methods, manual spreadsheets, disconnected pricing lists,…
Popular Salesforce Videos
How to Create a Free Developer Account in Salesforce?
There are many ways of creating a Salesforce account without investing a single rupee or a dollar with the developer’s edition and working on the…
Escalation Rule in Salesforce
In this video, Shrey is not only teaching but also demonstrating Escalation Rule in Salesforce. 1. What are Escalation Rules in Salesforce? 2. What is…
What is Validation Rule in Salesforce?
Validation rules verify that the data a user enters in a record meets the standards you specify before the user can save the record. A…
