-
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
Salesforce Integration with LinkedIn - Here's All You Need to Know
The general approach to selling doesn’t work as effectively in today’s world. You cannot expect extraordinary results by pushing out bulk emails to every prospect…
Salesforce Loops in Apex | The Developer Guide
Introduction A loop is a programming structure that repeats a sequence of instructions again and again until a specific/desired condition is met. In a loop…
10 Distinctive Salesforce Features To Make Your Tasks Easy
Salesforce, the global CRM leader has a lot of features and functionalities to offer but there are some unique and cool features and to look…
Popular Salesforce Videos
Salesforce Trailblazer Answers Leaders on YouTube
At Salesforce we’re using the power of our Trailblazer Community with Slack Connect to scale self-help content creation. Watch this short video to learn how…
What is Audit Trail in Salesforce?
The Setup Audit Trail feature in Salesforce enables you to closely track changes made to your organization. It records all modifications concerning the administration, customization, security,…
CPQ B2B Commerce Cloud Connector | Salesforce Tutorial
In these difficult economic times, businesses are looking for ways to improve efficiency and reduce the cost of doing business. More than ever, efficiency and…
