[ 
https://issues.apache.org/jira/browse/SOLR-16306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thomas Schürger updated SOLR-16306:
-----------------------------------
    Description: 
Solr gives an empty list of facet values when faceting over a DateRangeField. I 
would expect Solr to return each unique combination of each range's from and to 
date as a facet value.

Here is an example response. Each document has a date range field 
"validrange_dr" ("*_dr" is mapped to a single-value DateRangeField), but 
faceting over this attribute gives an empty list of facet values. Doing this 
for normal date fields works as expected.
{code:java}
{
  "responseHeader":{
    "status":0,
    "QTime":0,
    "params":{
      "q":"*:*",
      "facet.field":"validrange_dr",
      "indent":"true",
      "fl":"validrange_dr",
      "q.op":"OR",
      "rows":"10",
      "facet":"true",
      "_":"1658503177774"}},
  "response":{"numFound":38,"start":0,"numFoundExact":true,"docs":[
      {
        "validrange_dr":"[2021-06-22T12:18:23.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-06-30T09:49:13.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-06T10:48:10.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-17T15:36:41.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-08-04T08:23:13.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-06-15T01:05:50.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-05T13:33:17.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-05-26T19:33:26.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-06-12T21:29:45.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-20T20:11:28.000Z TO 
2999-12-31T23:59:59.999Z]"}]
  },
  "facet_counts":{
    "facet_queries":{},
    "facet_fields":{
      "validrange_dr":[]},
    "facet_ranges":{},
    "facet_intervals":{},
    "facet_heatmaps":{}}} {code}

  was:
Solr gives an empty list of facet values when faceting over a DateRangeField. I 
would expect Solr to return each unique combination of each range's from and to 
date as a facet value.

Here is an example response. Each document has a date range field 
"validrange_dr" ("*_dr" is mapped to DateRangeField), but faceting over this 
attribute gives an empty list of facet values. Doing this for normal date 
fields works as expected.
{code:java}
{
  "responseHeader":{
    "status":0,
    "QTime":0,
    "params":{
      "q":"*:*",
      "facet.field":"validrange_dr",
      "indent":"true",
      "fl":"validrange_dr",
      "q.op":"OR",
      "rows":"10",
      "facet":"true",
      "_":"1658503177774"}},
  "response":{"numFound":38,"start":0,"numFoundExact":true,"docs":[
      {
        "validrange_dr":"[2021-06-22T12:18:23.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-06-30T09:49:13.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-06T10:48:10.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-17T15:36:41.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-08-04T08:23:13.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-06-15T01:05:50.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-05T13:33:17.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-05-26T19:33:26.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-06-12T21:29:45.000Z TO 
2999-12-31T23:59:59.999Z]"},
      {
        "validrange_dr":"[2021-07-20T20:11:28.000Z TO 
2999-12-31T23:59:59.999Z]"}]
  },
  "facet_counts":{
    "facet_queries":{},
    "facet_fields":{
      "validrange_dr":[]},
    "facet_ranges":{},
    "facet_intervals":{},
    "facet_heatmaps":{}}} {code}


> Faceting over a DateRangeField gives empty result
> -------------------------------------------------
>
>                 Key: SOLR-16306
>                 URL: https://issues.apache.org/jira/browse/SOLR-16306
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: faceting
>    Affects Versions: 8.11.1
>            Reporter: Thomas Schürger
>            Priority: Major
>              Labels: faceting
>
> Solr gives an empty list of facet values when faceting over a DateRangeField. 
> I would expect Solr to return each unique combination of each range's from 
> and to date as a facet value.
> Here is an example response. Each document has a date range field 
> "validrange_dr" ("*_dr" is mapped to a single-value DateRangeField), but 
> faceting over this attribute gives an empty list of facet values. Doing this 
> for normal date fields works as expected.
> {code:java}
> {
>   "responseHeader":{
>     "status":0,
>     "QTime":0,
>     "params":{
>       "q":"*:*",
>       "facet.field":"validrange_dr",
>       "indent":"true",
>       "fl":"validrange_dr",
>       "q.op":"OR",
>       "rows":"10",
>       "facet":"true",
>       "_":"1658503177774"}},
>   "response":{"numFound":38,"start":0,"numFoundExact":true,"docs":[
>       {
>         "validrange_dr":"[2021-06-22T12:18:23.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-06-30T09:49:13.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-07-06T10:48:10.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-07-17T15:36:41.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-08-04T08:23:13.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-06-15T01:05:50.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-07-05T13:33:17.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-05-26T19:33:26.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-06-12T21:29:45.000Z TO 
> 2999-12-31T23:59:59.999Z]"},
>       {
>         "validrange_dr":"[2021-07-20T20:11:28.000Z TO 
> 2999-12-31T23:59:59.999Z]"}]
>   },
>   "facet_counts":{
>     "facet_queries":{},
>     "facet_fields":{
>       "validrange_dr":[]},
>     "facet_ranges":{},
>     "facet_intervals":{},
>     "facet_heatmaps":{}}} {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to