-
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
Why Salesforce Nonprofit Partners Are Essential for Your Organization’s Success
Salesforce offers a wide range of tools for sales, marketing, customer service, and analytics in one integrated system. Nonprofits use this powerful and customizable platform…
How Salesforce Can Benefit Real Estate Business?
As a real estate agent, your primary goal is to close deals quickly while providing outstanding customer service. However, with a never-ending stream of leads…
Send Salesforce Data for E-sign with Webmerge to Docusign
Hello All, here’s another Blog that helps Salesforce Users to send their data in the form of a document for Electronic Signature. So my blog describes…
Popular Salesforce Videos
Salesforce Health Cloud
Salesforce Health Cloud is a health IT CRM system that incorporates doctor-patient relationship and record management services. Through Private Communities, patients can view care plans,…
Salesforce Pay Expectations $$$ US and UK
Do you agree or disagree with these numbers? How do you think Mason Frank could have surveyed differently? In this video, Brad discusses just how…
Salesforce Object Search Language: What is SOSL and when to use SOSL?
When to Use SOSL? Use SOSL when you don’t know which object or field the data resides in, and you want to: Retrieve data for…
