Not equal to function

Elastic Stack Elasticsearch
1

Hi All,

I have a fields called subject.Account name and Target.account name , sometimes both have same values like

subject.Accountname : abc11
subject,Targetname : abc11

sometimes both values will be different like,

subject.Accountname : xyz34
subject.Targetname : abc12

Is it possible to right a query like Where Target Account name
Is not EQUAL to Subject Account Name , i need to have the values of that alone.

Any help much appreciated :slight_smile:

Thanks in advance,
Raj

2

You can do it with a script query but it won't be able to use the index. If need to do this quickly then you should add a flag to the documents with the same accounts at ingest time. If you don't care about how slow the query is then go for the script query.

3

thank you very much for the reply,do you have any example query for this , if possible :slight_smile:

4

I don't have an example handy but it'd look something like:

POST /test/_search
{
  "query": {
    "script": {
      "inline": "doc['Accountname'].value == doc['Targetname'].value"
    }
  }
}
1 Like
5

thank you Nick

6

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