# Is it possible to join queries

**URL:** <https://discuss.elastic.co/t/is-it-possible-to-join-queries/37008>\
**Category:** Elasticsearch\
**Created:** [December 11, 2015, 6:35pm UTC](https://discuss.elastic.co/t/is-it-possible-to-join-queries/37008 "2015-12-11T18:35:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![revathiP](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@revathiP](https://discuss.elastic.co/u/revathiP)\
**Post date:** [December 11, 2015, 6:35pm UTC](https://discuss.elastic.co/t/is-it-possible-to-join-queries/37008/1 "2015-12-11T18:35:15Z")

</div>

I am new to Kibana.  
Is it possible to write relationship query using another node value.  
So far I have seen relationship query using hard coded values.  
Example: Query document where the userid belongs to another document where the applicationname is test

---

<div class="post-metadata">

**Author:** ![Eliran\_Moyal](https://avatars.discourse-cdn.com/v4/letter/e/f6c823/32.png) [@Eliran\_Moyal](https://discuss.elastic.co/u/Eliran_Moyal)\
**Post date:** [December 11, 2015, 10:01pm UTC](https://discuss.elastic.co/t/is-it-possible-to-join-queries/37008/2 "2015-12-11T22:01:35Z")

</div>

Hey , this is feature is not possible in elasticsearch  
If your only usage is kibana  
there is a project named kibi which contains filter-join implementation like you mentioned

> **[Siren.io](https://siren.io/)**
>
> Siren is a data intelligence platform. For difficult industry problems in which traditional BI is useful, but not enough.

  
If you need joins on your elasticsearch queries (not only for kibana)  
you can check my plugin - elasticsearch-sql  
which contains some limited join support  

> **[NLPchina/elasticsearch-sql](https://github.com/NLPchina/elasticsearch-sql)**
>
> elasticsearch-sql - Use SQL to query Elasticsearch

  
or the siren soultions filter-join plugin  

> **[sirensolutions/siren-join](https://github.com/sirensolutions/siren-join)**
>
> siren-join - \[This is the old, single node version for Elasticsearch 2.x, see the latest "Siren Federate" plugin for distributed Elasticsearch 5.x and 6.x capabilities\]

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 11:31pm UTC](https://discuss.elastic.co/t/is-it-possible-to-join-queries/37008/3 "2017-07-05T23:31:39Z")

</div>


