Issue with Solr query

[Juan López]

Hello everyone,

Hope you're doing well,

I'm having a little problem extracting the views and downloads from my items with solr. It seems that my solr is not taking any of the date that I throw at it, it prints the same if I do something like [2020-01-10 +TO + 2020-12-31] or [* + TO + *]

Heres the exact query's that I'm using: 

1. with a date range:

http://localhost:8080/solr/statistics/select?indent=on&rows=0&q=type:2+id:3c940477-1803-4b4e-a0a5-c69701b8c049&fq=-isBot:true&fq=-(bundleName:[2020-01-01+TO+2020-01-01]-bundleName:ORIGINAL)&fq=-(statistics_type:[2020-01-01+TO+2020-01-01]+-statistics_type:view)&wt=xml

2. without a date range:

http://localhost:8080/solr/statistics/select?indent=on&rows=0&q=type:2+id:9673dfde-1ef1-4129-a3c0-088e8745f1a3&fq=-isBot:true&fq=-(bundleName:[*+TO+*]-bundleName:ORIGINAL)&fq=-(statistics_type:[*+TO+*]+-statistics_type:view)&wt=xml

In both cases, solr shows the same amount of views for my item.

Am I missing something?

Best regards,

Juan

[Mark H. Wood]

Filtering 'statistics_type' or 'bundleName' with a date range will not
work, since these fields doesn't contain dates. Try applying that
filter to the 'time' field instead:

http://localhost:8080/solr/statistics/select?indent=on&rows=0&q=type:2+id:3c940477-1803-4b4e-a0a5-c69701b8c049&fq=time:[2020-01-01+TO+2020-01-01]&fq=-isBot:true&fq=bundleName:ORIGINAL&fq=statistics_type:view&wt=xml

That may not be precisely the query that you intended, but it should
serve as a model.

--
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu

[Juan López]

Hi Mark,

Thanks for your response!

I've been trying to work with your example and got something like this:

http://localhost:8080/solr/statistics/select?indent=on&rows=0&q=type:2+id:3c940477-1803-4b4e-a0a5-c69701b8c049&fq=(time:%5B2021-01-01T00:00:00Z+TO+2020-01-31T00:00:00Z%5D)&fq=-isBot:true&fq=(bundleName:ORIGINAL)&fq=(statistics_type:view)&wt=xml

However, solr is showing "0" in the view count :

As you can see, my solr didn't throw any error this time.

Could this issue be related with a missconfiguration or something similar?

Best regards,

Juan López

[Juan López]

Hi! 

I just found out that we have a splitted solr:

How can I make a query to any of these splitted solr?

Best regards,

Juan

[Juan López]

Ok so to make my querys work all I had to do was change "statistics" for "statistics-xxxx" with "xxxx" being the year that I wanted to use for my query!

Thanks for your time and help Mark!