{"id":850,"date":"2023-10-12T06:06:14","date_gmt":"2023-10-12T06:06:14","guid":{"rendered":"https:\/\/www.devopsconsulting.in\/blog\/?p=850"},"modified":"2023-10-28T06:07:05","modified_gmt":"2023-10-28T06:07:05","slug":"how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable","status":"publish","type":"post","link":"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/","title":{"rendered":"How to Include a Column Filter Dropdown on Top of jQuery Datatable"},"content":{"rendered":"\n<p>You have the option to place the dropdown filter on the top header or bottom footer of a jquery datatable. By using columns(), the API is utilized to construct the select inputs.to iterate through the columns, use every() and then column().To obtain the data for each column individually, use the data() method.<\/p>\n\n\n\n<p>Let&#8217;s examine a dropdown filter on a certain column in the datatable, a dropdown filter on the header of the datatable, and a dropdown filter on the top of the jquery datatable.<\/p>\n\n\n\n<p><strong>HTML<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;table id=\"example\" class=\"display\" style=\"width:100%\">\n        &lt;thead>\n            &lt;tr>\n                &lt;th>Name&lt;\/th>\n                &lt;th>Position&lt;\/th>\n                &lt;th>Office&lt;\/th>\n                &lt;th>Age&lt;\/th>\n                &lt;th>Start date&lt;\/th>\n                &lt;th>Salary&lt;\/th>\n            &lt;\/tr>\n        &lt;\/thead>\n        &lt;tbody>\n            \n            &lt;tr>\n                &lt;td>Angelica Ramos&lt;\/td>\n                &lt;td>Chief Executive Officer (CEO)&lt;\/td>\n                &lt;td>London&lt;\/td>\n                &lt;td>47&lt;\/td>\n                &lt;td>2009-10-09&lt;\/td>\n                &lt;td>$1,200,000&lt;\/td>\n            &lt;\/tr>\n        &lt;\/tbody>\n        &lt;tfoot>\n            &lt;tr>\n                &lt;th>Name&lt;\/th>\n                &lt;th>Position&lt;\/th>\n                &lt;th>Office&lt;\/th>\n                &lt;th>Age&lt;\/th>\n                &lt;th>Start date&lt;\/th>\n                &lt;th>Salary&lt;\/th>\n            &lt;\/tr>\n        &lt;\/tfoot>\n    &lt;\/table><\/code><\/pre>\n\n\n\n<p><strong>JQuery<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$(document).ready(function () {\r\n    $('#example').DataTable({\r\n        initComplete: function () {\r\n            this.api()\r\n                .columns()\r\n                .every(function () {\r\n                    var column = this;\r\n                    var select = $('&lt;select>&lt;option value=\"\">&lt;\/option>&lt;\/select>')\r\n                        .appendTo($(column.header()).empty())\r\n                        .on('change', function () {\r\n                            var val = $.fn.dataTable.util.escapeRegex($(this).val());\r\n \r\n                            column.search(val ? '^' + val + '$' : '', true, false).draw();\r\n                        });\r\n \r\n                    column\r\n                        .data()\r\n                        .unique()\r\n                        .sort()\r\n                        .each(function (d, j) {\r\n                            select.append('&lt;option value=\"' + d + '\">' + d + '&lt;\/option>');\r\n                        });\r\n                   \r\n                    $(column.footer()).empty();\r\n                   \r\n                });\r\n        },\r\n    });\r\n});<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>You have the option to place the dropdown filter on the top header or bottom footer of a jquery datatable. By using columns(), the API is utilized&#8230; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86,101],"tags":[],"class_list":["post-850","post","type-post","status-publish","format-standard","hentry","category-javascript","category-jquery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Include a Column Filter Dropdown on Top of jQuery Datatable - DevOps Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Include a Column Filter Dropdown on Top of jQuery Datatable - DevOps Consulting\" \/>\n<meta property=\"og:description\" content=\"You have the option to place the dropdown filter on the top header or bottom footer of a jquery datatable. By using columns(), the API is utilized...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-12T06:06:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-28T06:07:05+00:00\" \/>\n<meta name=\"author\" content=\"Abhishek Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abhishek Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\\\/\"},\"author\":{\"name\":\"Abhishek Singh\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"headline\":\"How to Include a Column Filter Dropdown on Top of jQuery Datatable\",\"datePublished\":\"2023-10-12T06:06:14+00:00\",\"dateModified\":\"2023-10-28T06:07:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\\\/\"},\"wordCount\":101,\"commentCount\":0,\"articleSection\":[\"JavaScript\",\"jQuery\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\\\/\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\\\/\",\"name\":\"How to Include a Column Filter Dropdown on Top of jQuery Datatable - DevOps Consulting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\"},\"datePublished\":\"2023-10-12T06:06:14+00:00\",\"dateModified\":\"2023-10-28T06:07:05+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/\",\"name\":\"DevOps Consulting\",\"description\":\"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\",\"name\":\"Abhishek Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"caption\":\"Abhishek Singh\"},\"description\":\"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/author\\\/abhishek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Include a Column Filter Dropdown on Top of jQuery Datatable - DevOps Consulting","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:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/","og_locale":"en_US","og_type":"article","og_title":"How to Include a Column Filter Dropdown on Top of jQuery Datatable - DevOps Consulting","og_description":"You have the option to place the dropdown filter on the top header or bottom footer of a jquery datatable. By using columns(), the API is utilized...","og_url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/","og_site_name":"DevOps Consulting","article_published_time":"2023-10-12T06:06:14+00:00","article_modified_time":"2023-10-28T06:07:05+00:00","author":"Abhishek Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Abhishek Singh","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/#article","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/"},"author":{"name":"Abhishek Singh","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"headline":"How to Include a Column Filter Dropdown on Top of jQuery Datatable","datePublished":"2023-10-12T06:06:14+00:00","dateModified":"2023-10-28T06:07:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/"},"wordCount":101,"commentCount":0,"articleSection":["JavaScript","jQuery"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/","url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/","name":"How to Include a Column Filter Dropdown on Top of jQuery Datatable - DevOps Consulting","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#website"},"datePublished":"2023-10-12T06:06:14+00:00","dateModified":"2023-10-28T06:07:05+00:00","author":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-include-a-column-filter-dropdown-on-top-of-jquery-datatable\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.devopsconsulting.in\/blog\/#website","url":"https:\/\/www.devopsconsulting.in\/blog\/","name":"DevOps Consulting","description":"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.devopsconsulting.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f","name":"Abhishek Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","caption":"Abhishek Singh"},"description":"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.","url":"https:\/\/www.devopsconsulting.in\/blog\/author\/abhishek\/"}]}},"_links":{"self":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/comments?post=850"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/850\/revisions"}],"predecessor-version":[{"id":851,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/850\/revisions\/851"}],"wp:attachment":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/media?parent=850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/categories?post=850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/tags?post=850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}