Field comparision

Elastic Stack Elasticsearch
1

Hi all,

Is there any way to achieve field comparison.

If I index a type
{
manager : ,
teamMember :
}

how to write a query when a manager is also a teamMember ?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/92ac7c28-3810-4b94-820c-0005c086f176%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

Hi,

You can use script filter(Script query | Elasticsearch Guide [8.11] | Elastic).
Checking doc['manager'].value == doc['teamMember'].value should work.

Alternatively, you can precompute it and add managerIsAlsoTeamMember field to documents.

Masaru

On March 17, 2015 at 22:12:42, Pavan Kumar (pavan.bnv@gmail.com) wrote:

Hi all,

Is there any way to achieve field comparison.

If I index a type
{
manager : ,
teamMember :
}

how to write a query when a manager is also a teamMember ?

--
You received this message because you are subscribed to the Google Groups "elasticsearch"
group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/92ac7c28-3810-4b94-820c-0005c086f176%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/etPan.550b7d38.6b8b4567.166%40citra-2.local.
For more options, visit https://groups.google.com/d/optout.