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

2019-02-02 Thread Erick Erickson
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

2019-02-01 Thread Margaret Owens
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

2019-02-01 Thread Scott Stults
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

2019-02-01 Thread swap
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