Hi All,

I have below requirement for my business:

select?fl=*&fq=MODIFY_TS:[2020-06-23T18:30:00Z TO *]&fq=PHY_KEY2: "HQ010699" OR 
PHY_KEY2: "HQ010377" OR PHY_KEY2: "HQ010396" OR PHY_KEY2: "HQ010399" OR 
PHY_KEY2: "HQ010404" OR PHY_KEY2: "HQ010419" OR PHY_KEY2: "HQ010426" OR 
PHY_KEY2: "HQ010452" OR PHY_KEY2: "HQ010463" OR PHY_KEY2: "HQ010466" OR 
PHY_KEY2: "HQ010469" OR PHY_KEY2: "HQ010476" OR PHY_KEY2: "HQ010480" OR 
PHY_KEY2: "HQ010481" OR PHY_KEY2: "HQ010496" OR PHY_KEY2: "HQ010500" OR 
PHY_KEY2: "HQ010501" OR PHY_KEY2: "HQ010502" OR PHY_KEY2: "HQ010503" OR 
PHY_KEY2: "HQ010504"

Above query lists all the changes mentioned for 20 documents.

If I add below to query:

group=true&group.field=PHY_KEY2&group.ngroups=true

Below is the response:

"grouped":{
    "PHY_KEY2":{
      "matches":23,
      "ngroups":4,
      "groups":[{
          "groupValue":"HQ010500",
          "doclist":{"numFound":3,"start":0,"docs":[
              {
                "PHY_KEY2":"HQ010500"}]
          }},
        {
          "groupValue":"HQ010399",
          "doclist":{"numFound":4,"start":0,"docs":[
              {
                "PHY_KEY2":"HQ010399"}]
          }},
        {
          "groupValue":"HQ010377",
          "doclist":{"numFound":8,"start":0,"docs":[
              {
                "PHY_KEY2":"HQ010377"}]
          }},
        {
          "groupValue":"HQ010699",
          "doclist":{"numFound":8,"start":0,"docs":[
              {
                "PHY_KEY2":"HQ010699"}]
          }}]}}}

Take the case of last entry, HQ010699. It says numFound=8 (8 docs). But all of 
these 8 documents have the same value for field called TRACK_ID.  So can I 
group again on the TRACK_ID to get the count as 1.


Thanks and Regards,
Srinivas Kashyap

________________________________
DISCLAIMER:
E-mails and attachments from Bamboo Rose, LLC are confidential.
If you are not the intended recipient, please notify the sender immediately by 
replying to the e-mail, and then delete it without making copies or using it in 
any way.
No representation is made that this email or any attachments are free of 
viruses. Virus scanning is recommended and is the responsibility of the 
recipient.

Disclaimer

The information contained in this communication from the sender is 
confidential. It is intended solely for use by the recipient and others 
authorized to receive it. If you are not the recipient, you are hereby notified 
that any disclosure, copying, distribution or taking action in relation of the 
contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been 
automatically archived by Mimecast Ltd, an innovator in Software as a Service 
(SaaS) for business. Providing a safer and more useful place for your human 
generated data. Specializing in; Security, archiving and compliance. To find 
out more visit the Mimecast website.

Reply via email to