Re: [Dspace-tech] Solr stats queries - limiting by date
Gary, If it is helpful, I have several SOLR stats queries in the following code: https://github.com/Georgetown-University-Libraries/batch-tools/blob/master/web/stats/solrFacets.php I ran into some challenges knowing when to encode and when not to encode special characters. Terry On Wed, Jul 1, 2015 at 11:10 PM, Gary Browne gary.bro...@sydney.edu.au wrote: Hi all, I'm trying to figure out how to limit solr queries by date. I found this snippet online: http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL it fails in my browser (yes, other solr searches work). I'm trying to come up, for starters, with a solr search query for top X items visited in the last X months. Can anyone point me in the right direction here, even to some documentation (I've done a lot of googling but nothing I've found so far helps with this question). THanks, Gary -- *Gary Browne* | Development Programmer University of Sydney Library THE UNIVERSITY OF SYDNEY Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006 *T* +61 2 9351 5946 | *M* +61 405 647 868 *E* gary.bro...@sydney.edu.au -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology https://www.library.georgetown.edu/lit/code 425-298-5498 (Seattle, WA) -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Solr stats queries - limiting by date
Thanks Monika,
I can see what this particular query is doing, however I'm wondering if you
know of any resources for someone like me who is just starting out with solr
queries - especially with reference to DSpace. I know the wiki has some
examples but I thought there'd be some comprehensive documentation...somewhere?
For example, how do you know what the allowable values are for facet.field (and
where can these be configured, and how do you configure them)? The same with
type etc. And how do you know what the parameter names actually are (isBot,
owningComm etc)?
Any clues would be very much appreciated.
Thanks again,
Gary
Gary Browne | Technical Manager Developments
University of Sydney Library
THE UNIVERSITY OF SYDNEY
Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006
T +61 2 9351 5946 | M +61 405 647 868
E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au
On 03/07/15 00:14, Monika C. Mevenkamp wrote:
use the fq parameter to restrict to a time range
eg fq=time:[2015-01-01T00%3A00%3A00.000Z+TO+NOW]
the query below looks at ORIGINAL bitstreams in a give collection downloaded
at least once
excluding bot queries as well as query from the given ips and downloads from
users that were logged in
http://localhost:18082/solr/statistics/select?wt=jsonindent=truerows=0facet=truefacet.mincount=1facet.field=idfq=time:[2015-01-01T00%3A00%3A00.000Z+TO+NOW]q=NOT+epersonid%3A%5B%22%22+TO+*%5D+isBot:false+owningComm:67+type:0+bundleName:ORIGINAL+-ip:%2810.6.61.26+OR+128.112.66.66%29
the response header
responseHeader:{
status:0,
QTime:1857,
params:{
facet:true,
facet.mincount:1,
indent:true,
q:NOT epersonid:[\\ TO *] isBot:false owningComm:67 type:0
bundleName:ORIGINAL -ip:(10.6.61.26 OR 128.112.66.66),
facet.field:id,
wt:json,
fq:time:[2015-01-01T00:00:00.000Z TO NOW],
rows:0}},
response:{numFound:205152,start:0,docs:[]
},
I wrote a jruby script to do stats for a particular community - if you are
interested see https://github.com/akinom/dscriptor/tree/master/statistics
Monika
—
Monika Mevenkamp
Digital Repository Infrastructure Developer
Phone: 609-258-4161
333C 701 Carnegie, Princeton University, Princeton, NJ 08544
On Jul 2, 2015, at 2:10 AM, Gary Browne
gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au wrote:
Hi all,
I'm trying to figure out how to limit solr queries by date. I found this
snippet online:
http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL
it fails in my browser (yes, other solr searches work).
I'm trying to come up, for starters, with a solr search query for top X items
visited in the last X months.
Can anyone point me in the right direction here, even to some documentation
(I've done a lot of googling but nothing I've found so far helps with this
question).
THanks,
Gary
--
Gary Browne | Development Programmer
University of Sydney Library
THE UNIVERSITY OF SYDNEY
Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006
T +61 2 9351 5946 | M +61 405 647 868
E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au
--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.netmailto:DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Solr stats queries - limiting by date
Thanks a lot Terry, I'll check it out. Gary Browne | Technical Manager Developments University of Sydney Library THE UNIVERSITY OF SYDNEY Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006 T +61 2 9351 5946 | M +61 405 647 868 E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au On 14/07/15 05:04, Terry Brady wrote: Gary, If it is helpful, I have several SOLR stats queries in the following code: https://github.com/Georgetown-University-Libraries/batch-tools/blob/master/web/stats/solrFacets.php I ran into some challenges knowing when to encode and when not to encode special characters. Terry On Wed, Jul 1, 2015 at 11:10 PM, Gary Browne gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au wrote: Hi all, I'm trying to figure out how to limit solr queries by date. I found this snippet online: http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL it fails in my browser (yes, other solr searches work). I'm trying to come up, for starters, with a solr search query for top X items visited in the last X months. Can anyone point me in the right direction here, even to some documentation (I've done a lot of googling but nothing I've found so far helps with this question). THanks, Gary -- Gary Browne | Development Programmer University of Sydney Library THE UNIVERSITY OF SYDNEY Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006 T +61 2 9351 5946tel:%2B61%202%209351%205946 | M +61 405 647 868tel:%2B61%20405%20647%20868 E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.netmailto:DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology https://www.library.georgetown.edu/lit/code 425-298-5498 (Seattle, WA) -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Solr stats queries - limiting by date
Have a look at the differences between q and fq queries in solr. Monika suggest using the addition of fq and this can boost performance as it uses solr caches with no scoring and the q query uses a complex scoring mechanism to determine the relevance of a result so ordering of the result set may be different. The performance gains may be significant with fq and a combination of both of these can give the best performance and ordering that is required. Alastair From: Gary Browne [mailto:gary.bro...@sydney.edu.au] Sent: 03 July 2015 00:06 To: Duncan, Alastair (STFC,RAL,SC); dspace-tech@lists.sourceforge.net Subject: RE: Solr stats queries - limiting by date Thanks a lot Alastair, I'll try that. Cheers, Gary From: alastair.dun...@stfc.ac.ukmailto:alastair.dun...@stfc.ac.uk [alastair.dun...@stfc.ac.uk] Sent: Thursday, 2 July 2015 6:32 PM To: Gary Browne; dspace-tech@lists.sourceforge.netmailto:dspace-tech@lists.sourceforge.net Subject: RE: Solr stats queries - limiting by date Hi Gary, I'm not familiar with solr within DSpace but I've done some implementations with solr so the type of query you are looking to do will be something like this: time:[NOW-6MONTH/MONTH TO NOW] AND bundleName:ORIGINAL If you look at the schema fields the only one which is a date field is time so I'm guessing that this is the timestamp of the stats event and this gives me results that look about right. http://localhost/solr/statistics/select?q=time%3A%5BNOW-6MONTH%2FMONTH+TO+NOW%5D+AND+bundleName%3AORIGINAL I've no idea what field bundleName stores ;-) Alastair From: Gary Browne [mailto:gary.bro...@sydney.edu.au] Sent: 02 July 2015 07:11 To: dspace-tech@lists.sourceforge.netmailto:dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] Solr stats queries - limiting by date Hi all, I'm trying to figure out how to limit solr queries by date. I found this snippet online: http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL it fails in my browser (yes, other solr searches work). I'm trying to come up, for starters, with a solr search query for top X items visited in the last X months. Can anyone point me in the right direction here, even to some documentation (I've done a lot of googling but nothing I've found so far helps with this question). THanks, Gary -- Gary Browne | Development Programmer University of Sydney Library THE UNIVERSITY OF SYDNEY Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006 T +61 2 9351 5946 | M +61 405 647 868 E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Solr stats queries - limiting by date
Hi all, I'm trying to figure out how to limit solr queries by date. I found this snippet online: http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL it fails in my browser (yes, other solr searches work). I'm trying to come up, for starters, with a solr search query for top X items visited in the last X months. Can anyone point me in the right direction here, even to some documentation (I've done a lot of googling but nothing I've found so far helps with this question). THanks, Gary -- Gary Browne | Development Programmer University of Sydney Library THE UNIVERSITY OF SYDNEY Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006 T +61 2 9351 5946 | M +61 405 647 868 E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Solr stats queries - limiting by date
Hi Gary, I'm not familiar with solr within DSpace but I've done some implementations with solr so the type of query you are looking to do will be something like this: time:[NOW-6MONTH/MONTH TO NOW] AND bundleName:ORIGINAL If you look at the schema fields the only one which is a date field is time so I'm guessing that this is the timestamp of the stats event and this gives me results that look about right. http://localhost/solr/statistics/select?q=time%3A%5BNOW-6MONTH%2FMONTH+TO+NOW%5D+AND+bundleName%3AORIGINAL I've no idea what field bundleName stores ;-) Alastair From: Gary Browne [mailto:gary.bro...@sydney.edu.au] Sent: 02 July 2015 07:11 To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] Solr stats queries - limiting by date Hi all, I'm trying to figure out how to limit solr queries by date. I found this snippet online: http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL it fails in my browser (yes, other solr searches work). I'm trying to come up, for starters, with a solr search query for top X items visited in the last X months. Can anyone point me in the right direction here, even to some documentation (I've done a lot of googling but nothing I've found so far helps with this question). THanks, Gary -- Gary Browne | Development Programmer University of Sydney Library THE UNIVERSITY OF SYDNEY Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006 T +61 2 9351 5946 | M +61 405 647 868 E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Solr stats queries - limiting by date
use the fq parameter to restrict to a time range
eg fq=time:[2015-01-01T00%3A00%3A00.000Z+TO+NOW]
the query below looks at ORIGINAL bitstreams in a give collection downloaded
at least once
excluding bot queries as well as query from the given ips and downloads from
users that were logged in
http://localhost:18082/solr/statistics/select?wt=jsonindent=truerows=0facet=truefacet.mincount=1facet.field=idfq=time:[2015-01-01T00%3A00%3A00.000Z+TO+NOW]q=NOT+epersonid%3A%5B%22%22+TO+*%5D+isBot:false+owningComm:67+type:0+bundleName:ORIGINAL+-ip:%2810.6.61.26+OR+128.112.66.66%29
the response header
responseHeader:{
status:0,
QTime:1857,
params:{
facet:true,
facet.mincount:1,
indent:true,
q:NOT epersonid:[\\ TO *] isBot:false owningComm:67 type:0
bundleName:ORIGINAL -ip:(10.6.61.26 OR 128.112.66.66),
facet.field:id,
wt:json,
fq:time:[2015-01-01T00:00:00.000Z TO NOW],
rows:0}},
response:{numFound:205152,start:0,docs:[]
},
I wrote a jruby script to do stats for a particular community - if you are
interested see https://github.com/akinom/dscriptor/tree/master/statistics
Monika
—
Monika Mevenkamp
Digital Repository Infrastructure Developer
Phone: 609-258-4161
333C 701 Carnegie, Princeton University, Princeton, NJ 08544
On Jul 2, 2015, at 2:10 AM, Gary Browne
gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au wrote:
Hi all,
I'm trying to figure out how to limit solr queries by date. I found this
snippet online:
http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL
it fails in my browser (yes, other solr searches work).
I'm trying to come up, for starters, with a solr search query for top X items
visited in the last X months.
Can anyone point me in the right direction here, even to some documentation
(I've done a lot of googling but nothing I've found so far helps with this
question).
THanks,
Gary
--
Gary Browne | Development Programmer
University of Sydney Library
THE UNIVERSITY OF SYDNEY
Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006
T +61 2 9351 5946 | M +61 405 647 868
E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au
--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Solr stats queries - limiting by date
Thanks very much Monika,
I'll give that a go. Thanks also for the link to your script, very useful.
Cheers,
Gary
From: Monika C. Mevenkamp [moni...@princeton.edu]
Sent: Friday, 3 July 2015 12:14 AM
To: Gary Browne
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Solr stats queries - limiting by date
use the fq parameter to restrict to a time range
eg fq=time:[2015-01-01T00%3A00%3A00.000Z+TO+NOW]
the query below looks at ORIGINAL bitstreams in a give collection downloaded
at least once
excluding bot queries as well as query from the given ips and downloads from
users that were logged in
http://localhost:18082/solr/statistics/select?wt=jsonindent=truerows=0facet=truefacet.mincount=1facet.field=idfq=time:[2015-01-01T00%3A00%3A00.000Z+TO+NOW]q=NOT+epersonid%3A%5B%22%22+TO+*%5D+isBot:false+owningComm:67+type:0+bundleName:ORIGINAL+-ip:%2810.6.61.26+OR+128.112.66.66%29
the response header
responseHeader:{
status:0,
QTime:1857,
params:{
facet:true,
facet.mincount:1,
indent:true,
q:NOT epersonid:[\\ TO *] isBot:false owningComm:67 type:0
bundleName:ORIGINAL -ip:(10.6.61.26 OR 128.112.66.66),
facet.field:id,
wt:json,
fq:time:[2015-01-01T00:00:00.000Z TO NOW],
rows:0}},
response:{numFound:205152,start:0,docs:[]
},
I wrote a jruby script to do stats for a particular community - if you are
interested see https://github.com/akinom/dscriptor/tree/master/statistics
Monika
—
Monika Mevenkamp
Digital Repository Infrastructure Developer
Phone: 609-258-4161
333C 701 Carnegie, Princeton University, Princeton, NJ 08544
On Jul 2, 2015, at 2:10 AM, Gary Browne
gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au wrote:
Hi all,
I'm trying to figure out how to limit solr queries by date. I found this
snippet online:
http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL
it fails in my browser (yes, other solr searches work).
I'm trying to come up, for starters, with a solr search query for top X items
visited in the last X months.
Can anyone point me in the right direction here, even to some documentation
(I've done a lot of googling but nothing I've found so far helps with this
question).
THanks,
Gary
--
Gary Browne | Development Programmer
University of Sydney Library
THE UNIVERSITY OF SYDNEY
Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006
T +61 2 9351 5946 | M +61 405 647 868
E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au
--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Solr stats queries - limiting by date
Thanks a lot Alastair, I'll try that. Cheers, Gary From: alastair.dun...@stfc.ac.uk [alastair.dun...@stfc.ac.uk] Sent: Thursday, 2 July 2015 6:32 PM To: Gary Browne; dspace-tech@lists.sourceforge.net Subject: RE: Solr stats queries - limiting by date Hi Gary, I’m not familiar with solr within DSpace but I’ve done some implementations with solr so the type of query you are looking to do will be something like this: time:[NOW-6MONTH/MONTH TO NOW] AND bundleName:ORIGINAL If you look at the schema fields the only one which is a date field is time so I’m guessing that this is the timestamp of the stats event and this gives me results that look about right. http://localhost/solr/statistics/select?q=time%3A%5BNOW-6MONTH%2FMONTH+TO+NOW%5D+AND+bundleName%3AORIGINAL I’ve no idea what field bundleName stores ;-) Alastair From: Gary Browne [mailto:gary.bro...@sydney.edu.au] Sent: 02 July 2015 07:11 To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] Solr stats queries - limiting by date Hi all, I'm trying to figure out how to limit solr queries by date. I found this snippet online: http://mydspace.org/solr/statistics/select?bundleName:ORIGINALfacet.date.start=NOW/MONTH/DAY-6MONTHSfacet.date.end=NOWfacet.date.gap=1MONTH+AND+type:0+bundleName:ORIGINAL it fails in my browser (yes, other solr searches work). I'm trying to come up, for starters, with a solr search query for top X items visited in the last X months. Can anyone point me in the right direction here, even to some documentation (I've done a lot of googling but nothing I've found so far helps with this question). THanks, Gary -- Gary Browne | Development Programmer University of Sydney Library THE UNIVERSITY OF SYDNEY Level 1, Fisher Library F03 | The University of Sydney | NSW | 2006 T +61 2 9351 5946 | M +61 405 647 868 E gary.bro...@sydney.edu.aumailto:gary.bro...@sydney.edu.au -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
