nested facets search

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

darionis

Hi forum,

I wanted to check few stats of my repo, and I wanted to use facets to extract informartion about 'region' and 'type' of my documents. Both properties, 'type' and 'region' are part of document model.

Apparently, that would be possible with pivot facets. I tried various approcahes, form code and from solr web console but all i get is result for the first level (number of documents by region). I would also like to see count of each type in every region. Shortened response of my best try is this query:

http://localhost:8983/solr/alfresco/select?facet.pivot=ns:region,ns:type&facet=true&indent=on&q=TYPE:ns\:caseFile&rows=0&start=0&wt=json

which produces this result:

  ....

"_pivot_mappings_": {
"ns:region,ns:type": "text@s__lt@{http://xxx.eu/model/1.0}region,text@s__lt@{http://xxx.eu/model/1.0}type"
},

"facet.pivot": "ns:region,ns:type",
...

  "facet_counts": {
    "facet_intervals": {},
    "facet_pivot": {
      "ns:region,ns:type": [
        {
          "field": "ns:region",
          "count": 479,
          "value": "{en}hk"
        },
        {
          "field": "ns:region",
          "count": 120,
          "value": "{en}gk"
        },
        {
          "field": "ns:region",
          "count": 5,
          "value": "{en}oc"
        },
        {
          "field": "ns:region",
          "count": 2,
          "value": "{en}dep"
        },
      ]
    },
    "facet_queries": {},
    "facet_fields": {},
    "facet_heatmaps": {},
    "facet_ranges": {}
  },

So, no data for the type.

In this example, facets are nested, as I expect them to be, but I am not able to get  such result. Am i doing something wrong?

Please give some hints. Thank you.

Dario

darionis

In order for it to work, fileds must be decalred as facetable in the content model.

<property name="ns:region">
  <description>...</description>
  <type>d:text</type>
  <mandatory enforced="true">true</mandatory>
  <index enabled="true">
    <facetable>true</facetable>
  </index>
</property>