Re: Need to perfom search and group the record on basis of domain,subject,from address and display the count of label i.e inbox,spam
1> please don't hijack threads, start a new topic 2> Please follow the instructions here: http://lucene.apache.org/solr/community.html#mailing-lists-irc. You must use the _exact_ same e-mail as you used to subscribe. If the initial try doesn't work and following the suggestions at the "problems" link doesn't work for you, let us know. But note you need to show us the _entire_ return header to allow anyone to diagnose the problem. Best, Erick On Fri, Feb 1, 2019 at 2:05 PM Margaret Owens wrote: > > Please remove me from this list. > > -Original Message- > From: Scott Stults > Sent: February 1, 2019 2:03 PM > To: solr-user@lucene.apache.org > Subject: Re: Need to perfom search and group the record on basis of > domain,subject,from address and display the count of label i.e inbox,spam > > Hi Swapnil, > > There wasn't a a question in your post, so I'm guessing you're having trouble > getting started. Take a look at the JSON Facet API. That should get you most > of the way there. > > https://lucene.apache.org/solr/guide/7_5/json-facet-api.html > > k/r, > Scott > > On Fri, Feb 1, 2019 at 7:36 AM swap wrote: > > > Need to perfom search and group the record on basis of > > domain,subject,from address and display the count of label i.e inbox,spam > > and label status i.e read and unread with it.The label and label > > status should be displayed as percentage. > > > > Scenorio 1 > > Document structure is as mentioned below indexed in solr. message_id > > is unique field in solr > > { > > "email_date_time": 1548922689, > > "subject": "abcdef", > > "created": 1548932108, > > "domain": ".com", > > "message_id": "123456789ui", > > "label": "inbox", > > "from_address": xxxbc.com", > > "email": "g...@gmail.com", > > "label_status": "unread" > > } > > > > { > > "email_date_time": 1548922689, > > "subject": "abcdef", > > "created": 1548932108, > > "domain": ".com", > > "message_id": "zxiu22", > > "label": "inbox", > > "from_address": xxxbc.com", > > "email": "g...@gmail.com", > > "label_status": "unread" > > } > > > > { > > "email_date_time": 1548922689, > > "subject": "defg", > > "created": 1548932108, > > "domain": ".com", > > "message_id": "ftyuiooo899", > > "label": "inbox", > > "from_address": xxxbc.com", > > "email": "f...@gmail.com", > > "label_status": "unread" > > } > > > > I have below mentioned point to be implemented > > > > 1. Need to perfom search and group the record on basis of > > domain,subject,from address and display the count of label i.e inbox,spam > > and label status i.e read and unread with it.The label and label > > status should be displayed as percentage. > > > > > > 2. Need to paginate the record along with the implementation 1 > > > > > > Display will be as mentioned below > > > > > > 1. domain name : @ subject:hello from addredd: abcd@i > > > > inbox percentage : 20% spam percentage : 80% read percentage : 30% > > unread percentage : 70% > > > > 2. domain name : @ subject:hi from addredd: abcd@i > > > > inbox percentage : 20% spam percentage : 80% read percentage : 30% > > unread percentage : 70% > > > > > > 3. domain name : @ subject:where from addredd: abcd@i > > > > inbox percentage : 20% spam percentage : 80% read percentage : 30% > > unread percentage : 70% > > > > > > > > -- > > Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html > > > > > -- > Scott Stults | Founder & Solutions Architect | OpenSource Connections, LLC > | 434.409.2780 > http://www.opensourceconnections.com
RE: Need to perfom search and group the record on basis of domain,subject,from address and display the count of label i.e inbox,spam
Please remove me from this list. -Original Message- From: Scott Stults Sent: February 1, 2019 2:03 PM To: solr-user@lucene.apache.org Subject: Re: Need to perfom search and group the record on basis of domain,subject,from address and display the count of label i.e inbox,spam Hi Swapnil, There wasn't a a question in your post, so I'm guessing you're having trouble getting started. Take a look at the JSON Facet API. That should get you most of the way there. https://lucene.apache.org/solr/guide/7_5/json-facet-api.html k/r, Scott On Fri, Feb 1, 2019 at 7:36 AM swap wrote: > Need to perfom search and group the record on basis of > domain,subject,from address and display the count of label i.e inbox,spam > and label status i.e read and unread with it.The label and label > status should be displayed as percentage. > > Scenorio 1 > Document structure is as mentioned below indexed in solr. message_id > is unique field in solr > { > "email_date_time": 1548922689, > "subject": "abcdef", > "created": 1548932108, > "domain": ".com", > "message_id": "123456789ui", > "label": "inbox", > "from_address": xxxbc.com", > "email": "g...@gmail.com", > "label_status": "unread" > } > > { > "email_date_time": 1548922689, > "subject": "abcdef", > "created": 1548932108, > "domain": ".com", > "message_id": "zxiu22", > "label": "inbox", > "from_address": xxxbc.com", > "email": "g...@gmail.com", > "label_status": "unread" > } > > { > "email_date_time": 1548922689, > "subject": "defg", > "created": 1548932108, > "domain": ".com", > "message_id": "ftyuiooo899", > "label": "inbox", > "from_address": xxxbc.com", > "email": "f...@gmail.com", > "label_status": "unread" > } > > I have below mentioned point to be implemented > > 1. Need to perfom search and group the record on basis of > domain,subject,from address and display the count of label i.e inbox,spam > and label status i.e read and unread with it.The label and label > status should be displayed as percentage. > > > 2. Need to paginate the record along with the implementation 1 > > > Display will be as mentioned below > > > 1. domain name : @ subject:hello from addredd: abcd@i > > inbox percentage : 20% spam percentage : 80% read percentage : 30% > unread percentage : 70% > > 2. domain name : @ subject:hi from addredd: abcd@i > > inbox percentage : 20% spam percentage : 80% read percentage : 30% > unread percentage : 70% > > > 3. domain name : @ subject:where from addredd: abcd@i > > inbox percentage : 20% spam percentage : 80% read percentage : 30% > unread percentage : 70% > > > > -- > Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html > -- Scott Stults | Founder & Solutions Architect | OpenSource Connections, LLC | 434.409.2780 http://www.opensourceconnections.com
Re: Need to perfom search and group the record on basis of domain,subject,from address and display the count of label i.e inbox,spam
Hi Swapnil, There wasn't a a question in your post, so I'm guessing you're having trouble getting started. Take a look at the JSON Facet API. That should get you most of the way there. https://lucene.apache.org/solr/guide/7_5/json-facet-api.html k/r, Scott On Fri, Feb 1, 2019 at 7:36 AM swap wrote: > Need to perfom search and group the record on basis of domain,subject,from > address and display the count of label i.e inbox,spam > and label status i.e read and unread with it.The label and label status > should be displayed as percentage. > > Scenorio 1 > Document structure is as mentioned below indexed in solr. message_id is > unique field in solr > { > "email_date_time": 1548922689, > "subject": "abcdef", > "created": 1548932108, > "domain": ".com", > "message_id": "123456789ui", > "label": "inbox", > "from_address": xxxbc.com", > "email": "g...@gmail.com", > "label_status": "unread" > } > > { > "email_date_time": 1548922689, > "subject": "abcdef", > "created": 1548932108, > "domain": ".com", > "message_id": "zxiu22", > "label": "inbox", > "from_address": xxxbc.com", > "email": "g...@gmail.com", > "label_status": "unread" > } > > { > "email_date_time": 1548922689, > "subject": "defg", > "created": 1548932108, > "domain": ".com", > "message_id": "ftyuiooo899", > "label": "inbox", > "from_address": xxxbc.com", > "email": "f...@gmail.com", > "label_status": "unread" > } > > I have below mentioned point to be implemented > > 1. Need to perfom search and group the record on basis of > domain,subject,from address and display the count of label i.e inbox,spam > and label status i.e read and unread with it.The label and label status > should be displayed as percentage. > > > 2. Need to paginate the record along with the implementation 1 > > > Display will be as mentioned below > > > 1. domain name : @ subject:hello from addredd: abcd@i > > inbox percentage : 20% spam percentage : 80% > read percentage : 30% unread percentage : 70% > > 2. domain name : @ subject:hi from addredd: abcd@i > > inbox percentage : 20% spam percentage : 80% > read percentage : 30% unread percentage : 70% > > > 3. domain name : @ subject:where from addredd: abcd@i > > inbox percentage : 20% spam percentage : 80% > read percentage : 30% unread percentage : 70% > > > > -- > Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html > -- Scott Stults | Founder & Solutions Architect | OpenSource Connections, LLC | 434.409.2780 http://www.opensourceconnections.com
Need to perfom search and group the record on basis of domain,subject,from address and display the count of label i.e inbox,spam
Need to perfom search and group the record on basis of domain,subject,from address and display the count of label i.e inbox,spam and label status i.e read and unread with it.The label and label status should be displayed as percentage. Scenorio 1 Document structure is as mentioned below indexed in solr. message_id is unique field in solr { "email_date_time": 1548922689, "subject": "abcdef", "created": 1548932108, "domain": ".com", "message_id": "123456789ui", "label": "inbox", "from_address": xxxbc.com", "email": "g...@gmail.com", "label_status": "unread" } { "email_date_time": 1548922689, "subject": "abcdef", "created": 1548932108, "domain": ".com", "message_id": "zxiu22", "label": "inbox", "from_address": xxxbc.com", "email": "g...@gmail.com", "label_status": "unread" } { "email_date_time": 1548922689, "subject": "defg", "created": 1548932108, "domain": ".com", "message_id": "ftyuiooo899", "label": "inbox", "from_address": xxxbc.com", "email": "f...@gmail.com", "label_status": "unread" } I have below mentioned point to be implemented 1. Need to perfom search and group the record on basis of domain,subject,from address and display the count of label i.e inbox,spam and label status i.e read and unread with it.The label and label status should be displayed as percentage. 2. Need to paginate the record along with the implementation 1 Display will be as mentioned below 1. domain name : @ subject:hello from addredd: abcd@i inbox percentage : 20% spam percentage : 80% read percentage : 30% unread percentage : 70% 2. domain name : @ subject:hi from addredd: abcd@i inbox percentage : 20% spam percentage : 80% read percentage : 30% unread percentage : 70% 3. domain name : @ subject:where from addredd: abcd@i inbox percentage : 20% spam percentage : 80% read percentage : 30% unread percentage : 70% -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html