Comprae values between to strings

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

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

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