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
