-
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
How to Boost Your Business with a Salesforce Partner Company?
Are you looking to take your business to the next level? If so, consider leveraging the power of Salesforce, one of the world's leading customer…
Top Salesforce Winter '22 Nonprofit Release Features
Nonprofits have unique requirements, and Salesforce is familiar with them. There's nothing your Nonprofit can't accomplish with its effective resources. With one-of-a-kind Salesforce solutions, they…
Salesforce Integration API | API and Integration | Salesforce Integration API Limits
Salesforce Integration API allows the integration of Salesforce with other third-party applications and systems. This article overviews Salesforce API, its features, benefits, and use cases.…
Popular Salesforce Videos
Everything New in Salesforce Developer Tools
Your productivity starts and ends with the tools you use. Learn how Salesforce Developer Tooling can help you collaborate more effectively with your whole team.…
Skills for Salesforce Field Service | Optimize Customer Service for Businesses | Salesforce Webinar
One way to optimize customer service operations is by having the right technician for the right job. How? Skills for Salesforce Field Service is the…
The Rise of Salesforce
Salesforce is a cloud computing service as a software (SaaS) company that specializes in customer relationship management (CRM). Salesforce's services allow businesses to use cloud…
