# EXIST in DQL

**URL:** <https://discuss.elastic.co/t/exist-in-dql/310271>\
**Category:** Kibana\
**Created:** [July 21, 2022, 10:36am UTC](https://discuss.elastic.co/t/exist-in-dql/310271 "2022-07-21T10:36:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alice\_Ionescu](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@Alice\_Ionescu](https://discuss.elastic.co/u/Alice_Ionescu)\
**Post date:** [July 21, 2022, 10:36am UTC](https://discuss.elastic.co/t/exist-in-dql/310271/1 "2022-07-21T10:36:51Z")

</div>

Hello,  
I am trying to create a TSVB visualization (Table) and I want to a add a filter to it so it returns all the records with one specific fields not empty.  
How can I do that?  
I added in filter so that asgnStatus si valid, userName not iamadmin (Works ok) and **businessRuleName I want to add that this field has a value**  
**strong text**

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/5/25657c9dc2e82a1a1fa1e69b7b0873fa8043b67a.png)

Thanks a lot!

Thanks!

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [July 21, 2022, 1:35pm UTC](https://discuss.elastic.co/t/exist-in-dql/310271/2 "2022-07-21T13:35:42Z")

</div>

Seems like you are using opensearch dashboards, not Kibana. This forum is about the Elastic stack (Elasticsearch/Kibana)

---

<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 21, 2022, 1:35pm UTC](https://discuss.elastic.co/t/exist-in-dql/310271/3 "2022-07-21T13:35:42Z")

</div>

OpenSearch/OpenDistro are AWS run products and differ from the original Elasticsearch and Kibana products that Elastic builds and maintains. You may need to contact them directly for further assistance.

(This is an automated response from your friendly Elastic bot. Please report this post if you have any suggestions or concerns :elasticheart: )

---

<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:** [August 18, 2022, 1:35pm UTC](https://discuss.elastic.co/t/exist-in-dql/310271/4 "2022-08-18T13:35:45Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.