Hi Deepthi, Is dictionary static? Can value for some id change? If static, and if query performance matters to you, the best and also the simplest solution is to denormalise data and store dictionary values with docs.
Alternative is to use join query parser: https://lucene.apache.org/solr/guide/6_6/other-parsers.html#OtherParsers-JoiningAcrossCollections <https://lucene.apache.org/solr/guide/6_6/other-parsers.html#OtherParsers-JoiningAcrossCollections> HTH, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > On 8 Feb 2018, at 07:21, Deepthi P <vldpu...@gmail.com> wrote: > > I have a dictionary of 20000 ID's and their description which is in a > collection. There is another solr collection in which each document have 10 > or more ID's(multi valued field). I would like to text search in the > dictionary and bring back the matched ID's and search these ID's in solr > collection. For example if I search for 'fox' in the dictionary collection > and it returns 40 ID's, I would like to sent these 40 ID's to solr > collection and bring back documents that have these ID's.Please suggest the > best way to implement this.
