I am implementing a SES based index. In this index I store Customer data.
Most of the customers have multiple addresses, and here my problem is situated.
When I perform a search, the different addresses get mixed up.
For example, when I have a customer with the following addresses
Address 1: street = Baker Street city = London
Address 2: street = Town Street city = Liverpool
and another customer with the following addresses
Address 1: street = Baker Street city = Liverpool
Address 2: street = Town Street city = London
I find back both customers when I search for street = Baker Street and city = London
In my indexing class, in the method GET_ATTRIBUTE_VALUES I have given each address line a different ROW_COUNTER as this parameter suggest it can relate the address data to each other.
Has anybody got an idea how I can relate my address data to each other, so my search returns accurate results?
PS: I don't want to use joined indexes for the addresses, as I already have build joined indexes with Sales Transactions where I will need to search on Sales Transaction Data combined with address data and customer master data.