{"id":92945,"date":"2017-08-16T06:05:59","date_gmt":"2017-08-16T06:05:59","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=92945"},"modified":"2017-08-16T06:13:43","modified_gmt":"2017-08-16T06:13:43","slug":"execute-a-dynamically-created-query-in-apex","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/","title":{"rendered":"Execute a dynamically created query in APEX"},"content":{"rendered":"

Any Salesforce<\/strong> developer must be familiar with SOQL<\/strong> queries. SOQL as we all know is the Salesforce’s version of SQL. It’s full form translates to Salesforce Object Query Language<\/strong>. We have an idea about directly using query in APEX<\/strong> by writing the query in between ‘[‘ and ‘]’. However there is a limitation to the method i.e. queries created are a lot restricted and only available method to use variables is using them in where clause. We cannot use columns as variables, neither the conditions to be set or anything else. For this purpose we require a query which we can be generated as a string and then use it. This is what I am going to demonstrate to you how to execute a dynamic query in APEX.<\/p>\n

\n
\n

Sample code (APEX)<\/h3>\n<\/div>\n
\n
public class dynamicqblog {\r\n    list<sobject> records;\r\n    public string sobj { get; set;}\r\n    public string cols;\r\n    public string condition;\r\n    \r\n    public dynamicqblog(){\r\n        string query = '';\r\n        sobj = 'account';\r\n        system.debug(query);\r\n    }\r\n    \r\n    public list<selectoption> getSobjlist(){\r\n        list<selectoption> opt = new list<selectoption>();\r\n        opt.add(new selectoption('account','Account'));\r\n        opt.add(new selectoption('contact','Contact'));\r\n        return opt;\r\n    }\r\n    \r\n    public void dummy(){\r\n        \r\n    }\r\n    \r\n    public list<sobject> getRecords(){\r\n        cols = 'id, name';\r\n        condition = 'fax = null';\r\n        string query = 'select '+cols+' from '+sobj+' where '+condition;\r\n        records = Database.query(query);\r\n        return records;\r\n    }\r\n}<\/pre>\n
In this class we have done everything like any normal APEX class, only difference is the getRecords()<\/strong> function which has Database.query()<\/strong> function. This function executes a string query, at the cost of total number of rows we can fetch in one execution of the class. The limit is 10,000<\/strong> as compared to the 50,000<\/strong> limit of the normal static query.<\/p>\n<\/div>\n<\/div>\n
\n
\n
Sample code (Visualforce)<\/h3>\n<\/div>\n
\n
<apex:page controller=\"dynamicqblog\">\r\n<apex:form>\r\n<apex:selectList value=\"{!sobj}\" size = \"1\">\r\n<apex:selectOptions value=\"{!Sobjlist}\"\/>\r\n<\/apex:selectList>\r\n<apex:commandButton action=\"{!dummy}\" value=\"showlist\"\/>\r\n<apex:dataTable value=\"{!Records}\" var=\"rec\">\r\n<apex:column value=\"{!rec.id}\"\/>\r\n<\/apex:dataTable>\r\n<\/apex:form>\r\n<\/apex:page><\/pre>\n
In this example as you can see that we have not used the column name, however we have fetched it. That is because, for sObject the column name and value are created as a map at runtime, and hence we have to create a wrapper class to use that data. Rest everything is same.<\/p>\n<\/div>\n<\/div>\n
\n
\n
Output<\/h3>\n<\/div>\n
\n
\"\"<\/a>
\n\"\"<\/a><\/p>\n<\/div>\n<\/div>\n
\n
\n
Support<\/h3>\n<\/div>\n
\n
That\u2019s all about Executing Dynamic Queries, for any further queries feel free to add a ticket at:<\/p>\n
https:\/\/webkul.uvdesk.com\/en\/customer\/create-ticket\/<\/a><\/p>\n
Or let us know your views on how to make this code better, in comments section below.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Any Salesforce developer must be familiar with SOQL queries. SOQL as we all know is the Salesforce’s version of SQL. It’s full form translates to Salesforce Object Query Language. We have an idea about directly using query in APEX by writing the query in between ‘[‘ and ‘]’. However there is a limitation to the […]<\/a><\/p>\n","protected":false},"author":144,"featured_media":92983,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1889,1887,1888],"tags":[1884,5306,5305,1885,1933],"class_list":["post-92945","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apex","category-salesforce","category-visualforce","tag-apex","tag-database-class","tag-dynamic-query","tag-salesforce","tag-visualforce"],"yoast_head":"\nHow to execute a dynamic query in APEX with the help of Database class<\/title>\n<meta name=\"description\" content=\"How to execute a dynamic query in APEX with the help of Database class. Any Salesforce developer must be familiar with SOQL queries. SOQL as we all know...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to execute a dynamic query in APEX with the help of Database class\" \/>\n<meta property=\"og:description\" content=\"How to execute a dynamic query in APEX with the help of Database class. Any Salesforce developer must be familiar with SOQL queries. SOQL as we all know...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-16T06:05:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-16T06:13:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png\" \/>\n\t<meta property=\"og:image:width\" content=\"825\" \/>\n\t<meta property=\"og:image:height\" content=\"260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yathansh Sharma\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yathansh Sharma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/\"},\"author\":{\"name\":\"Yathansh Sharma\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/2cf74c97cc99e81430138433b2e5a342\"},\"headline\":\"Execute a dynamically created query in APEX\",\"datePublished\":\"2017-08-16T06:05:59+00:00\",\"dateModified\":\"2017-08-16T06:13:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/\"},\"wordCount\":301,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png\",\"keywords\":[\"Apex\",\"Database class\",\"Dynamic Query\",\"Salesforce\",\"Visualforce\"],\"articleSection\":[\"Apex\",\"Salesforce\",\"Visualforce\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/\",\"url\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/\",\"name\":\"How to execute a dynamic query in APEX with the help of Database class\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png\",\"datePublished\":\"2017-08-16T06:05:59+00:00\",\"dateModified\":\"2017-08-16T06:13:43+00:00\",\"description\":\"How to execute a dynamic query in APEX with the help of Database class. Any Salesforce developer must be familiar with SOQL queries. SOQL as we all know...\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png\",\"width\":825,\"height\":260},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Execute a dynamically created query in APEX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/2cf74c97cc99e81430138433b2e5a342\",\"name\":\"Yathansh Sharma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/631dfbfdb0f359990ee300274cf444e7dc7da6005653e2b711d3c9197caa4ab3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/631dfbfdb0f359990ee300274cf444e7dc7da6005653e2b711d3c9197caa4ab3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"caption\":\"Yathansh Sharma\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/yathansh-sharma081\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to execute a dynamic query in APEX with the help of Database class","description":"How to execute a dynamic query in APEX with the help of Database class. Any Salesforce developer must be familiar with SOQL queries. SOQL as we all know...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/","og_locale":"en_US","og_type":"article","og_title":"How to execute a dynamic query in APEX with the help of Database class","og_description":"How to execute a dynamic query in APEX with the help of Database class. Any Salesforce developer must be familiar with SOQL queries. SOQL as we all know...","og_url":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2017-08-16T06:05:59+00:00","article_modified_time":"2017-08-16T06:13:43+00:00","og_image":[{"width":825,"height":260,"url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png","type":"image\/png"}],"author":"Yathansh Sharma","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Yathansh Sharma","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/"},"author":{"name":"Yathansh Sharma","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/2cf74c97cc99e81430138433b2e5a342"},"headline":"Execute a dynamically created query in APEX","datePublished":"2017-08-16T06:05:59+00:00","dateModified":"2017-08-16T06:13:43+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/"},"wordCount":301,"commentCount":2,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage"},"thumbnailUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png","keywords":["Apex","Database class","Dynamic Query","Salesforce","Visualforce"],"articleSection":["Apex","Salesforce","Visualforce"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/","url":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/","name":"How to execute a dynamic query in APEX with the help of Database class","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage"},"thumbnailUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png","datePublished":"2017-08-16T06:05:59+00:00","dateModified":"2017-08-16T06:13:43+00:00","description":"How to execute a dynamic query in APEX with the help of Database class. Any Salesforce developer must be familiar with SOQL queries. SOQL as we all know...","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/08\/download-13.png","width":825,"height":260},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/execute-a-dynamically-created-query-in-apex\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Execute a dynamically created query in APEX"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/2cf74c97cc99e81430138433b2e5a342","name":"Yathansh Sharma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/631dfbfdb0f359990ee300274cf444e7dc7da6005653e2b711d3c9197caa4ab3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/631dfbfdb0f359990ee300274cf444e7dc7da6005653e2b711d3c9197caa4ab3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","caption":"Yathansh Sharma"},"url":"https:\/\/webkul.com\/blog\/author\/yathansh-sharma081\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/92945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/144"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=92945"}],"version-history":[{"count":4,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/92945\/revisions"}],"predecessor-version":[{"id":92992,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/92945\/revisions\/92992"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media\/92983"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=92945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=92945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=92945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}