{"id":852,"date":"2023-10-10T06:09:50","date_gmt":"2023-10-10T06:09:50","guid":{"rendered":"https:\/\/www.devopsconsulting.in\/blog\/?p=852"},"modified":"2023-10-28T06:16:21","modified_gmt":"2023-10-28T06:16:21","slug":"hide-show-column-in-jquery-datatable-dependent-on-condition","status":"publish","type":"post","link":"https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/","title":{"rendered":"Hide\/Show Column in jQuery Datatable Dependent on Condition"},"content":{"rendered":"\n<p>This tutorial will demonstrate how to hide or expose a column in a jQuery datatable based on a condition. This will teach us how to dynamically display and conceal a datatable column. A datatable&#8217;s columns can be dynamically shown and hidden by using the column().visible() API method.<\/p>\n\n\n\n<p>table().Based on a criterion, the visible() function is used to reveal and hide columns in a datatable. Moreover, the visibility of a single or multiple selected columns can be obtained or changed.<\/p>\n\n\n\n<p>Let&#8217;s see, then. Datatable columns can be hidden using jQuery, shown and hidden dynamically in datatables, dynamically added columns can be shown and hidden in datatables using jQuery, and dynamically hidden and shown columns can be dynamically added to datatables using Laravel 9.<\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>var table = $('#example').DataTable();\r\n \r\nalert( 'Column index 1 is '+\r\n    (table.column( 1 ).visible() === true ? 'visible' : 'not visible')\r\n);<\/code><\/pre>\n\n\n\n<p><strong>Html:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;div>\r\n    Toggle column: &lt;a class=\"toggle-vis\" data-column=\"0\">Name&lt;\/a> - &lt;a class=\"toggle-vis\" data-column=\"1\">Position&lt;\/a> - &lt;a class=\"toggle-vis\" data-column=\"2\">Office&lt;\/a> - &lt;a class=\"toggle-vis\" data-column=\"3\">Age&lt;\/a> - &lt;a class=\"toggle-vis\" data-column=\"4\">Start date&lt;\/a> - &lt;a class=\"toggle-vis\" data-column=\"5\">Salary&lt;\/a>\r\n&lt;\/div>\r\n&lt;table id=\"example\" class=\"display\" style=\"width:100%\">\r\n        &lt;thead>\r\n            &lt;tr>\r\n                &lt;th>Name&lt;\/th>\r\n                &lt;th>Position&lt;\/th>\r\n                &lt;th>Office&lt;\/th>\r\n                &lt;th>Age&lt;\/th>\r\n                &lt;th>Start date&lt;\/th>\r\n                &lt;th>Salary&lt;\/th>\r\n            &lt;\/tr>\r\n        &lt;\/thead>\r\n        &lt;tbody>\r\n            \r\n            &lt;tr>\r\n                &lt;td>Angelica Ramos&lt;\/td>\r\n                &lt;td>Chief Executive Officer (CEO)&lt;\/td>\r\n                &lt;td>London&lt;\/td>\r\n                &lt;td>47&lt;\/td>\r\n                &lt;td>2009-10-09&lt;\/td>\r\n                &lt;td>$1,200,000&lt;\/td>\r\n            &lt;\/tr>\r\n        &lt;\/tbody>\r\n        &lt;tfoot>\r\n            &lt;tr>\r\n                &lt;th>Name&lt;\/th>\r\n                &lt;th>Position&lt;\/th>\r\n                &lt;th>Office&lt;\/th>\r\n                &lt;th>Age&lt;\/th>\r\n                &lt;th>Start date&lt;\/th>\r\n                &lt;th>Salary&lt;\/th>\r\n            &lt;\/tr>\r\n        &lt;\/tfoot>\r\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    var table = $('#example').DataTable({\r\n        scrollY: '200px',\r\n        paging: false,\r\n    });\r\n \r\n    $('a.toggle-vis').on('click', function (e) {\r\n        e.preventDefault();\r\n \r\n        \/\/ Get the column API object\r\n        var column = table.column($(this).attr('data-column'));\r\n \r\n        \/\/ Toggle the visibility\r\n        column.visible(!column.visible());\r\n    });\r\n});<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial will demonstrate how to hide or expose a column in a jQuery datatable based on a condition. This will teach us how to dynamically display&#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-852","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>Hide\/Show Column in jQuery Datatable Dependent on Condition - 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\/hide-show-column-in-jquery-datatable-dependent-on-condition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hide\/Show Column in jQuery Datatable Dependent on Condition - DevOps Consulting\" \/>\n<meta property=\"og:description\" content=\"This tutorial will demonstrate how to hide or expose a column in a jQuery datatable based on a condition. This will teach us how to dynamically display...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-10T06:09:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-28T06:16:21+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\\\/hide-show-column-in-jquery-datatable-dependent-on-condition\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/hide-show-column-in-jquery-datatable-dependent-on-condition\\\/\"},\"author\":{\"name\":\"Abhishek Singh\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"headline\":\"Hide\\\/Show Column in jQuery Datatable Dependent on Condition\",\"datePublished\":\"2023-10-10T06:09:50+00:00\",\"dateModified\":\"2023-10-28T06:16:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/hide-show-column-in-jquery-datatable-dependent-on-condition\\\/\"},\"wordCount\":137,\"commentCount\":2,\"articleSection\":[\"JavaScript\",\"jQuery\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/hide-show-column-in-jquery-datatable-dependent-on-condition\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/hide-show-column-in-jquery-datatable-dependent-on-condition\\\/\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/hide-show-column-in-jquery-datatable-dependent-on-condition\\\/\",\"name\":\"Hide\\\/Show Column in jQuery Datatable Dependent on Condition - DevOps Consulting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\"},\"datePublished\":\"2023-10-10T06:09:50+00:00\",\"dateModified\":\"2023-10-28T06:16:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/hide-show-column-in-jquery-datatable-dependent-on-condition\\\/\"]}]},{\"@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":"Hide\/Show Column in jQuery Datatable Dependent on Condition - 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\/hide-show-column-in-jquery-datatable-dependent-on-condition\/","og_locale":"en_US","og_type":"article","og_title":"Hide\/Show Column in jQuery Datatable Dependent on Condition - DevOps Consulting","og_description":"This tutorial will demonstrate how to hide or expose a column in a jQuery datatable based on a condition. This will teach us how to dynamically display...","og_url":"https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/","og_site_name":"DevOps Consulting","article_published_time":"2023-10-10T06:09:50+00:00","article_modified_time":"2023-10-28T06:16:21+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\/hide-show-column-in-jquery-datatable-dependent-on-condition\/#article","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/"},"author":{"name":"Abhishek Singh","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"headline":"Hide\/Show Column in jQuery Datatable Dependent on Condition","datePublished":"2023-10-10T06:09:50+00:00","dateModified":"2023-10-28T06:16:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/"},"wordCount":137,"commentCount":2,"articleSection":["JavaScript","jQuery"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/","url":"https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/","name":"Hide\/Show Column in jQuery Datatable Dependent on Condition - DevOps Consulting","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#website"},"datePublished":"2023-10-10T06:09:50+00:00","dateModified":"2023-10-28T06:16:21+00:00","author":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsconsulting.in\/blog\/hide-show-column-in-jquery-datatable-dependent-on-condition\/"]}]},{"@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\/852","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=852"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":853,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/852\/revisions\/853"}],"wp:attachment":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/media?parent=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/categories?post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/tags?post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}