Lewin Is this not a job for a database like MySQL? Solr is a search engine, which can be used as a DB with some effort. Choose the right tool for the job . Cheers -- Rick
On January 2, 2018 4:35:47 PM EST, "Lewin Joy (TMNA)" <lewin....@toyota.com> wrote: >** PROTECTED 関係者外秘 >Hi, > >I am using Solr 6.1 and am facing an issue with a complex scenario. >Could you help figure out how this can be achieved in Solr? > >We have items: A, B, C . There will be multiple record entries for >each items. >For our understanding, let’s say the fields for these records are: >primary_key,item_name,status. > >I need to retrieve all records with status= ‘N’ and filter out items >which has any of it’s record matching status: ‘Y’ > >For record set below, the query should only return me records 1 and 2. >Primary_key > >Item_Name > >status > >1 > >A > >N > >2 > >A > >N > >3 > >B > >N > >4 > >B > >Y > >5 > >B > >N > >6 > >C > >Y > >7 > >C > >N > > > >Currently, I am using Streaming Query expressions to do complement() >operation. >But the number of records with status= ‘Y’ is too huge and causes >performance Problems. >And secondly, streaming query exports with Joins and complements can’t >be used properly for bringing out paginated outputs. > >Is there anyway, we can group the results and do a query on the group >to filter out such records? >Or any other approach which could give my results paginated? > >Thanks, >Lewin -- Sorry for being brief. Alternate email is rickleir at yahoo dot com