Any suggestions?
Regards,
Anuj
On Tue, 10 Dec 2019 at 20:52, Anuj Bhargava <anujb...@gmail.com> wrote:
> I am trying to index where the *sector field* has the values 27 and/or
> 2701 and/or 2702 using the following -
>
> <entity name="country" pk="ID"
> query="SELECT * FROM country WHERE sector = 27 OR sector = 2701 OR
> sector = 2702"
> deltaImportQuery="SELECT * FROM country
> WHERE posting_id = '${dataimporter.delta.posting_id}' AND sector = 27
> OR sector = 2701 OR sector = 2702"
> deltaQuery="SELECT posting_id FROM country
> WHERE last_modified > '${dataimporter.last_index_time}' AND sector =
> 27 OR sector = 2701 OR sector = 2702">
> </entity>
>
> The sector field has comma separated multiple values like -
> 27,19,527
> 38,27,62701
> 2701,49
> 55,2702,327
>
> The issue is when I run the above, it indexes the fields containing data
> 27,19,527 and 2701,49 and ignores the other data. It indexes if the data in
> the sector fields starts with either 27 or 2701 or 2702. It doesn't index
> if the values 27 or 2701 or 2702 are placed 2nd or 3rd in the sector data
> field
>
