<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Text field filter always expecting default value "None" - Usage Support - Redash Discourse</title>
<meta name="description" content="Hi Redash,
If we have filter field as normal text box, it is always expecting default value “None” to work, so everytime if we want to clear this filter we need to manually type “None” instead of empty field in the tex&hellip;">
<meta name="generator" content="Discourse 3.2.0.beta2-dev - https://github.com/discourse/discourse version 83621ccbe797223b48b624b00ef04f24672e1f03">
<link rel="icon" type="image/png" href="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/1X/01e20869afc0877e3e5aee0f94419b9e9bffa961_2_32x32.ico">
<link rel="apple-touch-icon" type="image/png" href="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/1X/e1838a8a0c506503a22e0c60e2334374b2895c87_2_180x180.png">
<meta name="theme-color" media="all" content="#ffffff">
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, user-scalable=yes, viewport-fit=cover">
<link rel="canonical" href="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349" />
<link rel="search" type="application/opensearchdescription+xml" href="https://discuss.redash.io/opensearch.xml" title="Redash Discourse Search">
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/color_definitions_base__2_8fd59ae1f286f43b3ff17996df07ea951685249d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" class="light-scheme"/>
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/desktop_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="desktop" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/checklist_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="checklist" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-adplugin_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-adplugin" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-akismet_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-akismet" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-cakeday_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-cakeday" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-chat-integration_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-chat-integration" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-details_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-details" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-footnote_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-footnote" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-lazy-videos_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-lazy-videos" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-local-dates_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-local-dates" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-narrative-bot_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-narrative-bot" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-presence_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-presence" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-solved_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-solved" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/discourse-spoiler-alert_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="discourse-spoiler-alert" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/hosted-site_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="hosted-site" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/poll_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="poll" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/poll_desktop_d86c892d7cd5311243d31a8f11787f4b0342874d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="poll_desktop" />
<link href="https://sjc6.discourse-cdn.com/standard17/stylesheets/desktop_theme_2_be4cb2b86ec06123c5e974acd20fd933d14b129d.css?__ws=discuss.redash.io" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="2" data-theme-name="default"/>
<meta id="data-ga-universal-analytics" data-tracking-code="UA-47088186-6" data-json="{"cookieDomain":"auto"}" data-auto-link-domains="">
<link rel="preload" href="https://global.discourse-cdn.com/standard17/assets/google-universal-analytics-v3-08add7ec997ab472fcd9f821d32ff7caf4b8b9a5de2ec18ca723a040be07a098.gz.js" as="script">
<script defer src="https://global.discourse-cdn.com/standard17/assets/google-universal-analytics-v3-08add7ec997ab472fcd9f821d32ff7caf4b8b9a5de2ec18ca723a040be07a098.gz.js"></script>
<link rel="alternate nofollow" type="application/rss+xml" title="RSS feed of 'Text field filter always expecting default value "None"'" href="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349.rss" />
<meta property="og:site_name" content="Redash Discourse" />
<meta property="og:type" content="website" />
<meta name="twitter:card" content="summary" />
<meta name="twitter:image" content="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/1/134c3cc603febafa237f4d40833149f9b43282e7_2_1024x135.png" />
<meta property="og:image" content="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/1/134c3cc603febafa237f4d40833149f9b43282e7_2_1024x135.png" />
<meta property="og:url" content="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349" />
<meta name="twitter:url" content="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349" />
<meta property="og:title" content="Text field filter always expecting default value "None"" />
<meta name="twitter:title" content="Text field filter always expecting default value "None"" />
<meta property="og:description" content="Hi Redash, If we have filter field as normal text box, it is always expecting default value “None” to work, so everytime if we want to clear this filter we need to manually type “None” instead of empty field in the textbox ,otherwise it will throw the error. Is there any way to fix this issue. Please find the screenshot for more details. Thanks." />
<meta name="twitter:description" content="Hi Redash, If we have filter field as normal text box, it is always expecting default value “None” to work, so everytime if we want to clear this filter we need to manually type “None” instead of empty field in the textbox ,otherwise it will throw the error. Is there any way to fix this issue. Please find the screenshot for more details. Thanks." />
<meta property="og:article:section" content="Support" />
<meta property="og:article:section:color" content="BF1E2E" />
<meta property="og:article:section" content="Usage Support" />
<meta property="og:article:section:color" content="AB9364" />
<meta property="article:published_time" content="2021-10-27T13:16:03+00:00" />
<meta property="og:ignore_canonical" content="true" />
<script type="application/ld+json">{"@context":"http://schema.org","@type":"QAPage","name":"Text field filter always expecting default value \"None\"","mainEntity":{"@type":"Question","name":"Text field filter always expecting default value \"None\"","text":"Hi Redash,\n\nIf we have filter field as normal text box, it is always expecting default value “None” to work, so everytime if we want to clear this filter we need to manually type “None” instead of empty field in the textbox ,otherwise it will throw the error. Is there any way to fix this issue.\n\nPl…","upvoteCount":0,"answerCount":0,"dateCreated":"2021-10-27T13:16:02.991Z","author":{"@type":"Person","name":"Mohan"}}}</script>
</head>
<body class="crawler ">
<header>
<a href="/">
Redash Discourse
</a>
</header>
<div id="main-outlet" class="wrap" role="main">
<div id="topic-title">
<h1>
<a href="/t/text-field-filter-always-expecting-default-value-none/9349">Text field filter always expecting default value "None"</a>
</h1>
<div class="topic-category" itemscope itemtype="http://schema.org/BreadcrumbList">
<span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem">
<a href="https://discuss.redash.io/c/support/6" class="badge-wrapper bullet" itemprop="item">
<span class='badge-category-bg' style='background-color: #BF1E2E'></span>
<span class='badge-category clear-badge'>
<span class='category-name' itemprop='name'>Support</span>
</span>
</a>
<meta itemprop="position" content="1" />
</span>
<span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem">
<a href="https://discuss.redash.io/c/support/support-usage/10" class="badge-wrapper bullet" itemprop="item">
<span class='badge-category-bg' style='background-color: #AB9364'></span>
<span class='badge-category clear-badge'>
<span class='category-name' itemprop='name'>Usage Support</span>
</span>
</a>
<meta itemprop="position" content="2" />
</span>
</div>
</div>
<div itemscope itemtype='http://schema.org/DiscussionForumPosting'>
<meta itemprop='headline' content='Text field filter always expecting default value "None"'>
<meta itemprop='articleSection' content='Usage Support'>
<meta itemprop='keywords' content=''>
<div itemprop='publisher' itemscope itemtype="http://schema.org/Organization">
<meta itemprop='name' content='Redash Discourse'>
<div itemprop='logo' itemscope itemtype="http://schema.org/ImageObject">
<meta itemprop='url' content='https://global.discourse-cdn.com/standard17/uploads/redash1/original/1X/c07bc573841e1e4a0013ea3b6fe088a1534228a3.png'>
</div>
</div>
<div id='post_1' class='topic-body crawler-post'>
<div class='crawler-post-meta'>
<span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person">
<a itemprop="url" href='https://discuss.redash.io/u/MohanKumar'><span itemprop='name'>MohanKumar</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349">
<link itemprop="image" href="https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/1/134c3cc603febafa237f4d40833149f9b43282e7.png">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-10-27T13:16:03Z' class='post-time'>
October 27, 2021, 1:16pm
</time>
<meta itemprop='dateModified' content='2021-10-27T13:16:03Z'>
<span itemprop='position'>1</span>
</span>
</div>
<div class='post' itemprop='articleBody'>
<p>Hi Redash,<br>
If we have filter field as normal text box, it is always expecting default value “None” to work, so everytime if we want to clear this filter we need to manually type “None” instead of empty field in the textbox ,otherwise it will throw the error. Is there any way to fix this issue.<br>
Please find the screenshot for more details.<br>
Thanks.<br>
<div class="lightbox-wrapper"><a class="lightbox" href="https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/1/134c3cc603febafa237f4d40833149f9b43282e7.png" data-download-href="/uploads/short-url/2KIppiwB2RaGKauUzeXhM7weQ3J.png?dl=1" title="image" rel="noopener nofollow ugc"><img src="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/1/134c3cc603febafa237f4d40833149f9b43282e7_2_690x91.png" alt="image" data-base62-sha1="2KIppiwB2RaGKauUzeXhM7weQ3J" width="690" height="91" srcset="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/1/134c3cc603febafa237f4d40833149f9b43282e7_2_690x91.png, https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/1/134c3cc603febafa237f4d40833149f9b43282e7_2_1035x136.png 1.5x, https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/1/134c3cc603febafa237f4d40833149f9b43282e7.png 2x" data-small-upload="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/1/134c3cc603febafa237f4d40833149f9b43282e7_2_10x10.png"><div class="meta">
<svg class="fa d-icon d-icon-far-image svg-icon" aria-hidden="true"><use href="#far-image"></use></svg><span class="filename">image</span><span class="informations">1235×163 11.6 KB</span><svg class="fa d-icon d-icon-discourse-expand svg-icon" aria-hidden="true"><use href="#discourse-expand"></use></svg>
</div></a></div><br>
<div class="lightbox-wrapper"><a class="lightbox" href="https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/d/da9daea8ce749ac406b354e8a52ebe04c9ab34f6.png" data-download-href="/uploads/short-url/vbXV7hppbu58pkly1HZ85DrkYLQ.png?dl=1" title="image" rel="noopener nofollow ugc"><img src="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/d/da9daea8ce749ac406b354e8a52ebe04c9ab34f6_2_689x104.png" alt="image" data-base62-sha1="vbXV7hppbu58pkly1HZ85DrkYLQ" width="689" height="104" srcset="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/d/da9daea8ce749ac406b354e8a52ebe04c9ab34f6_2_689x104.png, https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/d/da9daea8ce749ac406b354e8a52ebe04c9ab34f6_2_1033x156.png 1.5x, https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/d/da9daea8ce749ac406b354e8a52ebe04c9ab34f6.png 2x" data-small-upload="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/d/da9daea8ce749ac406b354e8a52ebe04c9ab34f6_2_10x10.png"><div class="meta">
<svg class="fa d-icon d-icon-far-image svg-icon" aria-hidden="true"><use href="#far-image"></use></svg><span class="filename">image</span><span class="informations">1240×188 13.2 KB</span><svg class="fa d-icon d-icon-discourse-expand svg-icon" aria-hidden="true"><use href="#discourse-expand"></use></svg>
</div></a></div><br>
<div class="lightbox-wrapper"><a class="lightbox" href="https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/0/006fd962a2f13ee03b09f48799d93bf7362e6a26.png" data-download-href="/uploads/short-url/3RDpIzSam5q5utIP9dLiXtD5Ay.png?dl=1" title="image" rel="noopener nofollow ugc"><img src="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/0/006fd962a2f13ee03b09f48799d93bf7362e6a26_2_690x155.png" alt="image" data-base62-sha1="3RDpIzSam5q5utIP9dLiXtD5Ay" width="690" height="155" srcset="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/0/006fd962a2f13ee03b09f48799d93bf7362e6a26_2_690x155.png, https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/0/006fd962a2f13ee03b09f48799d93bf7362e6a26_2_1035x232.png 1.5x, https://global.discourse-cdn.com/standard17/uploads/redash1/original/2X/0/006fd962a2f13ee03b09f48799d93bf7362e6a26.png 2x" data-small-upload="https://global.discourse-cdn.com/standard17/uploads/redash1/optimized/2X/0/006fd962a2f13ee03b09f48799d93bf7362e6a26_2_10x10.png"><div class="meta">
<svg class="fa d-icon d-icon-far-image svg-icon" aria-hidden="true"><use href="#far-image"></use></svg><span class="filename">image</span><span class="informations">1246×281 15.7 KB</span><svg class="fa d-icon d-icon-discourse-expand svg-icon" aria-hidden="true"><use href="#discourse-expand"></use></svg>
</div></a></div></p>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/LikeAction"/>
<meta itemprop="userInteractionCount" content="0" />
<span class='post-likes'></span>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/CommentAction"/>
<meta itemprop="userInteractionCount" content="0" />
</div>
</div>
<div id='post_2' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'>
<div class='crawler-post-meta'>
<span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person">
<a itemprop="url" href='https://discuss.redash.io/u/jesse'><span itemprop='name'>jesse</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-10-27T14:11:52Z' class='post-time'>
October 27, 2021, 2:11pm
</time>
<meta itemprop='dateModified' content='2021-10-27T14:11:52Z'>
<span itemprop='position'>2</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>Currently (V10) this is expected behaviour.</p>
<p>Interested to see what the community thinks about making a “blank default” option for text params. Where a default value is injected into the query if the user doesn’t enter anything.</p>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/LikeAction"/>
<meta itemprop="userInteractionCount" content="0" />
<span class='post-likes'></span>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/CommentAction"/>
<meta itemprop="userInteractionCount" content="0" />
</div>
</div>
<div id='post_3' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'>
<div class='crawler-post-meta'>
<span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person">
<a itemprop="url" href='https://discuss.redash.io/u/MohanKumar'><span itemprop='name'>MohanKumar</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-10-28T06:43:58Z' class='post-time'>
October 28, 2021, 6:43am
</time>
<meta itemprop='dateModified' content='2021-10-28T06:43:58Z'>
<span itemprop='position'>3</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>For now Is there any workaround to fix this ??</p>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/LikeAction"/>
<meta itemprop="userInteractionCount" content="0" />
<span class='post-likes'></span>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/CommentAction"/>
<meta itemprop="userInteractionCount" content="1" />
</div>
</div>
<div id='post_4' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'>
<div class='crawler-post-meta'>
<span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person">
<a itemprop="url" href='https://discuss.redash.io/u/jesse'><span itemprop='name'>jesse</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/text-field-filter-always-expecting-default-value-none/9349">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-10-28T10:48:47Z' class='post-time'>
October 28, 2021, 10:48am
</time>
<meta itemprop='dateModified' content='2021-10-28T11:13:26Z'>
<span itemprop='position'>4</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>Save <code>None</code> as the parameter’s default value.</p>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/LikeAction"/>
<meta itemprop="userInteractionCount" content="0" />
<span class='post-likes'></span>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/CommentAction"/>
<meta itemprop="userInteractionCount" content="0" />
</div>
</div>
</div>
</div>
<footer class="container wrap">
<nav class='crawler-nav'>
<ul>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='/' itemprop="url">Home </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='/categories' itemprop="url">Categories </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='/guidelines' itemprop="url">FAQ/Guidelines </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='http://redash.io/terms.html' itemprop="url">Terms of Service </a>
</span>
</li>
<li itemscope itemtype='http://schema.org/SiteNavigationElement'>
<span itemprop='name'>
<a href='http://redash.io/privacy.html' itemprop="url">Privacy Policy </a>
</span>
</li>
</ul>
</nav>
<p class='powered-by-link'>Powered by <a href="https://www.discourse.org">Discourse</a>, best viewed with JavaScript enabled</p>
</footer>
</body>
</html>