# Question regarding filtering on field values

**URL:** https://discuss.elastic.co/t/question-regarding-filtering-on-field-values/50141
**Category:** Elasticsearch
**Created:** [May 16, 2016, 5:09pm UTC](https://discuss.elastic.co/t/question-regarding-filtering-on-field-values/50141 "2016-05-16T17:09:56Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![sridhark](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sridhark](https://discuss.elastic.co/u/sridhark)
#### Post date: [May 16, 2016, 5:09pm UTC](https://discuss.elastic.co/t/question-regarding-filtering-on-field-values/50141/1 "2016-05-16T17:09:57Z")

</div>

I would like to query filtering on "fieldname" through POST method.

For example:  
field "activity\_name" values are below  
a) Satisfaction Data\_sample  
b) Airline Satisfaction Survey\_test  
c) Airline Satisfaction Survey  
d) Satisfaction Data

The below should retrieve documents which has "activity\_name" field value contains "Satis" for specified time range. Please suggest me how can we specify it?

```
{
    "fields": [
        "message",
        "activity_name"
        ],  
    query: {
        "query_string": {
            "query": "type:\"sample\" AND activity_name:\"*Satis*\""
            }
    },
    filter : {
         "range": {
                "@timestamp": {
                    "from": 1463410411109,    
                    "to": 1463414011108
                }
            }
    }
}

```

I'm expecting to retrieve all 4 documents but the above code didn't return anything.  
but I am able to retrieve documents filtered on particular word (eg: _Satisfaction_) which returns all 4, but not with in between text.

---

<div class="post-metadata">

### Author: ![mikemccand](https://avatars.discourse-cdn.com/v4/letter/m/f04885/32.png) [@mikemccand](https://discuss.elastic.co/u/mikemccand)
#### Post date: [May 17, 2016, 3:17pm UTC](https://discuss.elastic.co/t/question-regarding-filtering-on-field-values/50141/2 "2016-05-17T15:17:06Z")

</div>

Can you simplify the query to narrow it down to which part is failing to match? I.e., is it the `*Satis*` wildcard, or the range on `@timestamp`?

Mike McCandless

---

<div class="post-metadata">

### Author: ![sridhark](https://avatars.discourse-cdn.com/v4/letter/s/c57346/32.png) [@sridhark](https://discuss.elastic.co/u/sridhark)
#### Post date: [May 17, 2016, 4:01pm UTC](https://discuss.elastic.co/t/question-regarding-filtering-on-field-values/50141/3 "2016-05-17T16:01:33Z")

</div>

No problem with @timestamp. The wild card `*Satis*` didn't give any result with the below code. But when i use `*Satisfaction*` returns all 4 (a,b,c,d) values listed above. I expected to return those 4 values with `*Satis*` also. How do i specify in query?

```
                                    {
                                        "fields": [
                                            "message",
                                            "activity_name"
                                            ],  
                                        query: {
                                            "query_string": {
                                                "query": "type:\"sample\" AND activity_name:\"*Satis*\""
                                                }
                                        }
                                    }
```

---

<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, 10:50pm UTC](https://discuss.elastic.co/t/question-regarding-filtering-on-field-values/50141/4 "2017-07-05T22:50:57Z")

</div>


