I have Two index: accounts and customerException
indexschema are as follows:
Here the primary key is the combination of AccountID and customerID
AccountID priorityvalue1 priorityvalue2 customerID
1 p1 p2 c101
2 p3 p4 c102
I want to search priorityvalue1 and priorityvalu2 for given
AccountName and customerID.for that i have required to get accountID
from Accounts index for corresponding accountName,then using this
accountID and customerID i have to retrieve priority value1 and
prorityvalue2 from customerException index.
As i have explored Elastic i found to search the data in a single
field. but here i have to check the condition in two fields. Here I am
not getting that how i will apply the query to get the desired result.