# ElasticSearch Query containing equal and not equal

**URL:** <https://discuss.elastic.co/t/elasticsearch-query-containing-equal-and-not-equal/311713>\
**Category:** Elasticsearch\
**Created:** [August 9, 2022, 10:53am UTC](https://discuss.elastic.co/t/elasticsearch-query-containing-equal-and-not-equal/311713 "2022-08-09T10:53:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![usman1](https://avatars.discourse-cdn.com/v4/letter/u/c67d28/32.png) [@usman1](https://discuss.elastic.co/u/usman1)\
**Post date:** [August 9, 2022, 10:53am UTC](https://discuss.elastic.co/t/elasticsearch-query-containing-equal-and-not-equal/311713/1 "2022-08-09T10:53:17Z")

</div>

Hi,

Is there a way to use equal and not equal in a query for Elasticsearch? My data looks something like this:

```auto
ID = 2
FLAG = ""Start"
Date = 2022-08-08
Data = <>

```

```auto
ID = 2
FLAG = "End"
Date = 2022-08-08
Data = <>

```

```auto
ID = 4
FLAG = ""Start"
Date = 2022-08-08
Data = <>

```

There is no "End" transaction for ID 4 and I want to fetch only such batches (batch with ID 4 only) for which I have only Start transaction.

---

<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:** [September 6, 2022, 10:53am UTC](https://discuss.elastic.co/t/elasticsearch-query-containing-equal-and-not-equal/311713/2 "2022-09-06T10:53:19Z")

</div>

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