-
How can I dynamically append the fieldtype in SOQL query in Salesforce?
Hi All,
How can I dynamically append the fieldtype in SOQL query in Salesforce?
Thanks
-
1 Reply
-
Hi Pranav,
You can give the dynamic fieldtype in SOQL in this way:-
String type ='fieldtype';
String test = String.valueof(testvalue); // the value on which you want to perform search action.
sObject obj = Database.query('SELECT Id,name FROM sObject WHERE ' + type + ' like \'%' + test + '%\' limit 1');
System.debug('@@@'+obj);I hope you get your answer
Log In to reply.
Popular Salesforce Blogs
Salesforce CPQ Implementation - Best Practices
Many organizations often struggle to generate accurate quotes quickly. Since product information is stored across disparate systems, salespeople have to spend a lot of time…
Should You Find a Salesforce Partner Checklist 2024
Salesforce Partners offer specialized services like consulting and customization for better customer relationships and efficient business processes. But is it always necessary to find a…
How Salesforce Customization Services Can Help Your Business
Salesforce is known to have thousands of features used by businesses, along with customization options. Off-the-shelf Salesforce solutions might initially help a business but, moving…
Popular Salesforce Videos
Salesforce Flow to Create Feedback form on Case | How to use Slider, Radio button on Screen Flow
Use Case: In this video, we are creating a screen flow to get feedback from the users when the case is closed. Learnings: 1. How…
Lightning Data Service: An Easy Way to Build Lightning Components Without Code
Lightning Data Service is a centralized data caching framework which is used to load, save, create and delete a record without server-side apex code. It…
Apex Programming Tutorial for beginners : Data Types, Variables and Constants in Salesforce
Apex Programming Tutorial for beginners: Data Types, Variables and Constants in Salesforce.
