# Elasticsearch : Filter does not work with wildcard query

**URL:** <https://discuss.elastic.co/t/elasticsearch-filter-does-not-work-with-wildcard-query/42528>\
**Category:** Elasticsearch\
**Created:** [February 23, 2016, 8:13pm UTC](https://discuss.elastic.co/t/elasticsearch-filter-does-not-work-with-wildcard-query/42528 "2016-02-23T20:13:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![apt275](https://avatars.discourse-cdn.com/v4/letter/a/9e8a1a/32.png) [@apt275](https://discuss.elastic.co/u/apt275)\
**Post date:** [February 23, 2016, 8:13pm UTC](https://discuss.elastic.co/t/elasticsearch-filter-does-not-work-with-wildcard-query/42528/1 "2016-02-23T20:13:30Z")

</div>

Here is my query

```
POST indexName/test/_search
{
  "fields" : ["Col1"],
  "query":{
	    				"filtered":{
	    				  
	    				"query":{
	    				  
	    				
	    				"wildcard": {
	    				  
	    					"Col1": {
	    					  
	    				          "value": "*zxc*"
	    				       }
	    				    }
	    				  
	    				  },
	    				"filter":
	            {
	  	          "term": { 
	  	            
	  	            "Col2": "val" 
	  	            
	  	          }
	            }
	    			}
	    				    
	    	}
}

```

so i want to do a wildcard on `Col1` for the value `*zxc*` and i want only those values where `Col2` is `val` this returns 0 hits. is there anything wrong with my syntax?

The wildcard query works independently if i remove the filter.

**Edit**

this works

```
POST indexName/test/_search
{
  "fields" : ["Col1"],
  "query":{
	    				"filtered":{
	    				  
	    				
	    				"filter":
	            {
	  	          "term": { 
	  	            
	  	            "Col2": "val" 
	  	            
	  	          }
	            }
	    			}
	    				    
	    	}
}

```

sample document returned

```
{
        "_index": "indexName",
        "_type": "test",
        "_id": "oainfubgvwurebetrnjt",
        "_score": 1,
        "fields": {
          "Col1": [
            "uyiwebvybg iuowenbgubnrwev uirbgvuire3bv vuirbg"
          ]
        }
      }

```

and so does this

```
POST indexName/test/_search
{
  "fields" : ["Col1"],
  "query":{
	    				"wildcard": {
	    				  
	    					"Col1": {
	    					  
	    				          "value": "*zxc*"
	    				       }
	    				    }
	    				    
	    	}
}

```

sample document returned

```
{
        "_index": "indexName",
        "_type": "test",
        "_id": "aofnhuiwegbnweu",
        "_score": 1,
        "fields": {
          "Col1": [
            "idasihid huwbgbuiwb iuohfuweb zxc oifjhwgbu"
          ]
        }
      }

```

so both of these queries work independently. How do i combine them?

---

<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:14pm UTC](https://discuss.elastic.co/t/elasticsearch-filter-does-not-work-with-wildcard-query/42528/2 "2017-07-05T23:14:05Z")

</div>