Comprae values between to strings

Elastic Stack Kibana
1

Hi,
Please consider the following case.
I have an index named : FRAUD
I would like to display all the documents that field A is equal to field B
fields A and B are of string data type.

in sqlplus its looks like that

select a,b,c
from    FRAUD
where a=b;

Please advise
Thanks
Yoav

2

The most efficient way to do this is at ingestion time with an ingest node processor.

If this data is already indexed, you'll want to create a scripted field. The scripted field would output true or false, and then you'd query on that field.

e.g. script that creates a fieldd = (a == b) and a query d: true

3

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