Hi Anuj, Maybe I am missing something but this is more question for some SQL group than for Solr group. I am surprised that you get any records. You can consult your DB documentation for some more elegant solution, but a brute-force solution, if your column is string, could be: WHERE sector = 27 OR sector LIKE ’27,%’ OR sector LIKE ‘%,27,%’ OR sector LIKE ‘%,27’ OR sector = 2701…
HTH, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > On 12 Dec 2019, at 08:38, Anuj Bhargava <anujb...@gmail.com> wrote: > > 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 >>
