<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Observable query based dropdown list - Feature Requests - Redash Discourse</title>
<meta name="description" content="I would like to see query-based dropdown list with additional parameter: observable parameter name.
Modification of observable parameter should refresh query of this element to show relative choises.
For example: first&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/observable-query-based-dropdown-list/3229" />
<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 'Observable query based dropdown list'" href="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229.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/original/1X/e1838a8a0c506503a22e0c60e2334374b2895c87.png" />
<meta property="og:image" content="https://global.discourse-cdn.com/standard17/uploads/redash1/original/1X/e1838a8a0c506503a22e0c60e2334374b2895c87.png" />
<meta property="og:url" content="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229" />
<meta name="twitter:url" content="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229" />
<meta property="og:title" content="Observable query based dropdown list" />
<meta name="twitter:title" content="Observable query based dropdown list" />
<meta property="og:description" content="I would like to see query-based dropdown list with additional parameter: observable parameter name. Modification of observable parameter should refresh query of this element to show relative choises. For example: first parameter {{ test_name }} defines by dropdownlist or text field. Second parameter {{ test_group }} observe first to provide list of test groups relative to selected test" />
<meta name="twitter:description" content="I would like to see query-based dropdown list with additional parameter: observable parameter name. Modification of observable parameter should refresh query of this element to show relative choises. For example: first parameter {{ test_name }} defines by dropdownlist or text field. Second parameter {{ test_group }} observe first to provide list of test groups relative to selected test" />
<meta property="og:article:section" content="Feature Requests" />
<meta property="og:article:section:color" content="3AB54A" />
<meta name="twitter:label1" value="Reading time" />
<meta name="twitter:data1" value="1 mins đź•‘" />
<meta name="twitter:label2" value="Likes" />
<meta name="twitter:data2" value="2 ❤" />
<meta property="article:published_time" content="2019-02-15T09:19:51+00:00" />
<meta property="og:ignore_canonical" content="true" />
</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/observable-query-based-dropdown-list/3229">Observable query based dropdown list</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/feature-requests/5" class="badge-wrapper bullet" itemprop="item">
<span class='badge-category-bg' style='background-color: #3AB54A'></span>
<span class='badge-category clear-badge'>
<span class='category-name' itemprop='name'>Feature Requests</span>
</span>
</a>
<meta itemprop="position" content="1" />
</span>
</div>
</div>
<div itemscope itemtype='http://schema.org/DiscussionForumPosting'>
<meta itemprop='headline' content='Observable query based dropdown list'>
<meta itemprop='articleSection' content='Feature Requests'>
<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/banyrule'><span itemprop='name'>banyrule</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2019-02-15T09:19:51Z' class='post-time'>
February 15, 2019, 9:19am
</time>
<meta itemprop='dateModified' content='2019-02-15T09:19:51Z'>
<span itemprop='position'>1</span>
</span>
</div>
<div class='post' itemprop='articleBody'>
<p>I would like to see query-based dropdown list with additional parameter: observable parameter name.<br>
Modification of observable parameter should refresh query of this element to show relative choises.</p>
<p>For example: first parameter <code>{{ test_name }}</code> defines by dropdownlist or text field. Second parameter <code>{{ test_group }}</code> observe first to provide list of test groups relative to selected test</p>
</div>
<div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter">
<meta itemprop="interactionType" content="http://schema.org/LikeAction"/>
<meta itemprop="userInteractionCount" content="2" />
<span class='post-likes'>2 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 class='crawler-linkback-list' itemscope itemtype='http://schema.org/ItemList'>
<div itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'>
<a itemprop='url' href="http://discuss.redash.io/t/filter-query-based-dropdown-based-on-another-query-based-dropdown/4971/2">Filter query based dropdown based on another query based dropdown</a>
<meta itemprop='position' content='1'>
</div>
<div itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'>
<a itemprop='url' href="http://discuss.redash.io/t/sub-filtering-filters-based-upon-filters/7657/2">Sub-filtering, filters based upon filters</a>
<meta itemprop='position' content='2'>
</div>
<div itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'>
<a itemprop='url' href="http://discuss.redash.io/t/nested-query-parameter/8880/2">Nested query parameter</a>
<meta itemprop='position' content='3'>
</div>
</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/AlexDataDesign'><span itemprop='name'>AlexDataDesign</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2019-02-22T16:53:25Z' class='post-time'>
February 22, 2019, 4:53pm
</time>
<meta itemprop='dateModified' content='2019-02-22T16:53:25Z'>
<span itemprop='position'>2</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>+1 this is so much needed.</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_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/jesse'><span itemprop='name'>jesse</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2019-03-01T12:15:58Z' class='post-time'>
March 1, 2019, 12:15pm
</time>
<meta itemprop='dateModified' content='2019-03-01T12:15:58Z'>
<span itemprop='position'>3</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>I agree this would be valuable. To work properly, the queries backing the <em>Query Based Dropdown List</em> would need to accept an extra <code>WHERE</code> clause that would be injected by the dashboard at runtime. I can imagine this interface would get pretty complicated.</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/ashishchoksi'><span itemprop='name'>ashishchoksi</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-02-14T05:38:29Z' class='post-time'>
February 14, 2021, 5:38am
</time>
<meta itemprop='dateModified' content='2021-02-14T05:38:29Z'>
<span itemprop='position'>4</span>
</span>
</div>
<div class='post' itemprop='text'>
<p><strong>It’s almost 2 years since this feature request is pending.</strong><br>
I just want to know is there any workaround?<br>
or anyone has another solution(s) to achieve the same?</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_5' 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/k4s1m'><span itemprop='name'>k4s1m</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-02-15T18:05:09Z' class='post-time'>
February 15, 2021, 6:05pm
</time>
<meta itemprop='dateModified' content='2021-02-15T18:05:09Z'>
<span itemprop='position'>5</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>I don’t know any workaround for this. You probably need a different tool for 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="0" />
</div>
<div class='crawler-linkback-list' itemscope itemtype='http://schema.org/ItemList'>
<div itemprop='itemListElement' itemscope itemtype='http://schema.org/ListItem'>
<a itemprop='url' href="http://discuss.redash.io/t/passing-query-paramters-into-a-interal-query-from-parent-query/8036/2">Passing query paramters into a interal query from parent query</a>
<meta itemprop='position' content='1'>
</div>
</div>
</div>
<div id='post_6' 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/ben-emax-1992'><span itemprop='name'>ben-emax-1992</span></a>
</span>
<link itemprop="mainEntityOfPage" href="https://discuss.redash.io/t/observable-query-based-dropdown-list/3229">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-11-25T10:07:24Z' class='post-time'>
November 25, 2021, 10:07am
</time>
<meta itemprop='dateModified' content='2021-11-25T10:07:24Z'>
<span itemprop='position'>6</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>Are there any news? This would make our lives so much easier?</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_7' 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/observable-query-based-dropdown-list/3229">
<span class="crawler-post-infos">
<time itemprop='datePublished' datetime='2021-11-25T18:35:01Z' class='post-time'>
November 25, 2021, 6:35pm
</time>
<meta itemprop='dateModified' content='2021-11-25T18:35:01Z'>
<span itemprop='position'>7</span>
</span>
</div>
<div class='post' itemprop='text'>
<p>Nobody has contributed this behaviour yet. We are happy to review a PR implementing it though.</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>