question Re: Solr query question in Archives of Support Questions (Read Only)

Solr query question

wlo — Tue, 13 Sep 2016 00:16:18 GMT

Hi,

Let's say I only have 2 fields in a document: "animal" and "born_date"

A few examples of document:

{animal:"cat", born_date:"1/1/2015" },{animal:"dog", born_date:"1/1/2015" },{animal:"snake", born_date:"1/3/2015" },...........

Is it possible to write a facet query to generate the following result?

{ 

"cat": [

	"1/1/2015", 123,

	"1/2/2015",423,

	"1/3/2015",32,

	....

	"12/31/2015",32],

"dog": [

	"1/1/2015", 23,

	"1/2/2015",43,

	"1/3/2015",88,

	....

	"12/31/2015",4],

"snake": [

	"1/1/2015", 23,

	"1/2/2015",67,

	"1/3/2015",2,

	....

	"12/31/2015",6]

}

-Wing

Re: Solr query question

matt_andruff — Tue, 13 Sep 2016 01:36:18 GMT

What do you want to do with the results?

Are you going to summarize the results?

You may want to look at pivoting a facet for summarizing the result.
If you just want to group them. Don't forget to set a limit so a reasonable result is returned.

let me know if this is what you where looking for.

Re: Solr query question

wlo — Tue, 13 Sep 2016 21:55:24 GMT

Thanks for the suggestions and I'll look them up. Basically I want to visualize the data on a line chart. Each line represent one type of animal and I don't know how many types of animal in the solr collection.

Can I use facet range with group? then I can show the count on each day within the group?

Re: Solr query question

matt_andruff — Wed, 14 Sep 2016 01:22:53 GMT

From what you have told me sounds like you should use a facet pivot and specifically checkout "Combining Facet Queries And Facet Ranges With Pivot Facets" it has an example that fits right into what you want to do.

Re: Solr query question

wlo — Wed, 14 Sep 2016 04:21:56 GMT

The facet pivot is exactly what I need! Thank you so much, Matt!

Re: Solr query question

pminovic — Wed, 14 Sep 2016 04:37:00 GMT

Hi @Wing Lo If facet pivot is exactly what you need how about accepting and upvoting Matt's answer? Thanks!