Not equal to function

[Raj_Kumar (Raj)]

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

Thanks in advance,
Raj

[nik9000 (Nik Everett)]

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.

[Raj_Kumar (Raj)]

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

[nik9000 (Nik Everett)]

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"
    }
  }
}

[Raj_Kumar (Raj)]

thank you Nick