# Custom\_filters\_score and percolator

**URL:** <https://discuss.elastic.co/t/custom-filters-score-and-percolator/9521>\
**Category:** Elasticsearch\
**Created:** [November 1, 2012, 4:29pm UTC](https://discuss.elastic.co/t/custom-filters-score-and-percolator/9521 "2012-11-01T16:29:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![samuel\_merlet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samuel_merlet/32/2656_2.png) [@samuel\_merlet](https://discuss.elastic.co/u/samuel_merlet)\
**Post date:** [November 1, 2012, 4:29pm UTC](https://discuss.elastic.co/t/custom-filters-score-and-percolator/9521/1 "2012-11-01T16:29:24Z")

</div>

Hi,

Im doing a custom\_filters\_score query , i registered it as a percolator .  
Then when i add or update a document that is supposed to match the query it  
doesn't .  
Is it because i use a custom\_filters\_score query ?

here is my query :

{  
"query":{  
"custom\_filters\_score":{  
"query":{  
"filtered":{  
"query":{  
"match\_all":{}  
},  
"filter":{  
"nested":{  
"path":"profile\_type.profile\_roles",  
"query":{  
"term":{  
"profile\_type.profile\_roles.role\_id":"11"  
}  
}  
}  
}  
}  
},  
"filters":[  
{  
"filter":{  
"nested":{  
"path":"profile\_type.profile\_roles",  
"query":{  
"filtered":{  
"query":{  
"match\_all":{}  
},  
"filter":{  
"and":[  
{  
"term":{  
"profile\_type.profile\_roles.role\_id":"11"  
}  
},  
{  
"terms":{

"profile\_type.profile\_roles.skills.skill\_id":["8", "29"]  
}  
},  
{  
"terms":{  
"profile\_type.profile\_roles.terms.term\_id":["1",  
"1", "2"]  
}  
}  
]  
}  
}  
}  
}  
},  
"boost":10  
},  
{  
"filter":{  
"nested":{  
"path":"profile\_type.profile\_roles",  
"query":{  
"filtered":{  
"query":{  
"match\_all":{}  
},  
"filter":{  
"and":[  
{  
"term":{  
"profile\_type.profile\_roles.role\_id":"11"  
}  
},  
{  
"terms":{

"profile\_type.profile\_roles.skills.skill\_id":["8", "29"]  
}  
}  
]  
}  
}  
}  
}  
},  
"boost":8  
},  
{  
"filter":{  
"nested":{  
"path":"profile\_type.profile\_roles",  
"query":{  
"filtered":{  
"query":{  
"match\_all":{}  
},  
"filter":{  
"and":[  
{  
"term":{  
"profile\_type.profile\_roles.role\_id":"11"  
}  
},  
{  
"terms":{  
"profile\_type.profile\_roles.terms.term\_id":["1",  
"1", "2"]  
}  
}  
]  
}  
}  
}  
}  
},  
"boost":5  
}  
],  
"score\_mode":"total"  
}  
}  
}

Any help will be really appreciated thanks

--

---

<div class="post-metadata">

**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\
**Post date:** [November 1, 2012, 8:33pm UTC](https://discuss.elastic.co/t/custom-filters-score-and-percolator/9521/2 "2012-11-01T20:33:32Z")

</div>

Percolator fails because of "nested" queries. It cannot work with nested  
documents yet.

On Thursday, November 1, 2012 12:29:24 PM UTC-4, samuel merlet wrote:

> Hi,
> 
> Im doing a custom\_filters\_score query , i registered it as a percolator .  
> Then when i add or update a document that is supposed to match the query it  
> doesn't .  
> Is it because i use a custom\_filters\_score query ?
> 
> here is my query :
> 
> {  
> "query":{  
> "custom\_filters\_score":{  
> "query":{  
> "filtered":{  
> "query":{  
> "match\_all":{}  
> },  
> "filter":{  
> "nested":{  
> "path":"profile\_type.profile\_roles",  
> "query":{  
> "term":{  
> "profile\_type.profile\_roles.role\_id":"11"  
> }  
> }  
> }  
> }  
> }  
> },  
> "filters":[  
> {  
> "filter":{  
> "nested":{  
> "path":"profile\_type.profile\_roles",  
> "query":{  
> "filtered":{  
> "query":{  
> "match\_all":{}  
> },  
> "filter":{  
> "and":[  
> {  
> "term":{  
> "profile\_type.profile\_roles.role\_id":"11"  
> }  
> },  
> {  
> "terms":{
> 
> "profile\_type.profile\_roles.skills.skill\_id":["8", "29"]  
> }  
> },  
> {  
> "terms":{  
> "profile\_type.profile\_roles.terms.term\_id":["1",  
> "1", "2"]  
> }  
> }  
> ]  
> }  
> }  
> }  
> }  
> },  
> "boost":10  
> },  
> {  
> "filter":{  
> "nested":{  
> "path":"profile\_type.profile\_roles",  
> "query":{  
> "filtered":{  
> "query":{  
> "match\_all":{}  
> },  
> "filter":{  
> "and":[  
> {  
> "term":{  
> "profile\_type.profile\_roles.role\_id":"11"  
> }  
> },  
> {  
> "terms":{
> 
> "profile\_type.profile\_roles.skills.skill\_id":["8", "29"]  
> }  
> }  
> ]  
> }  
> }  
> }  
> }  
> },  
> "boost":8  
> },  
> {  
> "filter":{  
> "nested":{  
> "path":"profile\_type.profile\_roles",  
> "query":{  
> "filtered":{  
> "query":{  
> "match\_all":{}  
> },  
> "filter":{  
> "and":[  
> {  
> "term":{  
> "profile\_type.profile\_roles.role\_id":"11"  
> }  
> },  
> {  
> "terms":{  
> "profile\_type.profile\_roles.terms.term\_id":["1",  
> "1", "2"]  
> }  
> }  
> ]  
> }  
> }  
> }  
> }  
> },  
> "boost":5  
> }  
> ],  
> "score\_mode":"total"  
> }  
> }  
> }
> 
> Any help will be really appreciated thanks

--

---

<div class="post-metadata">

**Author:** ![samuel\_merlet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samuel_merlet/32/2656_2.png) [@samuel\_merlet](https://discuss.elastic.co/u/samuel_merlet)\
**Post date:** [November 1, 2012, 9:57pm UTC](https://discuss.elastic.co/t/custom-filters-score-and-percolator/9521/3 "2012-11-01T21:57:34Z")

</div>

OK i see , do you know if this will be supported somedays ? Is there any  
work around ?

thanks

On Thursday, November 1, 2012 9:33:32 PM UTC+1, Igor Motov wrote:

> Percolator fails because of "nested" queries. It cannot work with nested  
> documents yet.
> 
> On Thursday, November 1, 2012 12:29:24 PM UTC-4, samuel merlet wrote:
> 
> > Hi,
> > 
> > Im doing a custom\_filters\_score query , i registered it as a percolator .  
> > Then when i add or update a document that is supposed to match the query it  
> > doesn't .  
> > Is it because i use a custom\_filters\_score query ?
> > 
> > here is my query :
> > 
> > {  
> > "query":{  
> > "custom\_filters\_score":{  
> > "query":{  
> > "filtered":{  
> > "query":{  
> > "match\_all":{}  
> > },  
> > "filter":{  
> > "nested":{  
> > "path":"profile\_type.profile\_roles",  
> > "query":{  
> > "term":{  
> > "profile\_type.profile\_roles.role\_id":"11"  
> > }  
> > }  
> > }  
> > }  
> > }  
> > },  
> > "filters":[  
> > {  
> > "filter":{  
> > "nested":{  
> > "path":"profile\_type.profile\_roles",  
> > "query":{  
> > "filtered":{  
> > "query":{  
> > "match\_all":{}  
> > },  
> > "filter":{  
> > "and":[  
> > {  
> > "term":{  
> > "profile\_type.profile\_roles.role\_id":"11"  
> > }  
> > },  
> > {  
> > "terms":{
> > 
> > "profile\_type.profile\_roles.skills.skill\_id":["8", "29"]  
> > }  
> > },  
> > {  
> > "terms":{
> > 
> > "profile\_type.profile\_roles.terms.term\_id":["1", "1", "2"]  
> > }  
> > }  
> > ]  
> > }  
> > }  
> > }  
> > }  
> > },  
> > "boost":10  
> > },  
> > {  
> > "filter":{  
> > "nested":{  
> > "path":"profile\_type.profile\_roles",  
> > "query":{  
> > "filtered":{  
> > "query":{  
> > "match\_all":{}  
> > },  
> > "filter":{  
> > "and":[  
> > {  
> > "term":{  
> > "profile\_type.profile\_roles.role\_id":"11"  
> > }  
> > },  
> > {  
> > "terms":{
> > 
> > "profile\_type.profile\_roles.skills.skill\_id":["8", "29"]  
> > }  
> > }  
> > ]  
> > }  
> > }  
> > }  
> > }  
> > },  
> > "boost":8  
> > },  
> > {  
> > "filter":{  
> > "nested":{  
> > "path":"profile\_type.profile\_roles",  
> > "query":{  
> > "filtered":{  
> > "query":{  
> > "match\_all":{}  
> > },  
> > "filter":{  
> > "and":[  
> > {  
> > "term":{  
> > "profile\_type.profile\_roles.role\_id":"11"  
> > }  
> > },  
> > {  
> > "terms":{
> > 
> > "profile\_type.profile\_roles.terms.term\_id":["1", "1", "2"]  
> > }  
> > }  
> > ]  
> > }  
> > }  
> > }  
> > }  
> > },  
> > "boost":5  
> > }  
> > ],  
> > "score\_mode":"total"  
> > }  
> > }  
> > }
> > 
> > Any help will be really appreciated thanks

--

---

<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 6, 2017, 3:06am UTC](https://discuss.elastic.co/t/custom-filters-score-and-percolator/9521/4 "2017-07-06T03:06:30Z")

</div>