DSL Query - Compare columns of different Index

[aj.murciah (Arnold J. Murcia Hidalgo)]

Hi,
I need to compare the information of two columns stored in different index.

For example IndexA.Column = IndexB.Column

I try with the following sentence but is wrong:

{
"query": {
"match" : {
"account_name" : "user_name"
}
}
}

Can someone help me!

Regards

[dadoonet (David Pilato)]

Same question as you already asked at

DSL Query: LIKE Condition of SQL

Hi Basically I need to perform a search similar to LIKE condition in SQL. Ex. Index.ColumnA LIKE Index.ColumnX In other words I need to verify if ColumnA contains or match with Column B. It's important mention that it is not neccesary that both columns have be equals. Regards

Don't open multiple threads about the same subject please.