Task #6432: Create a Solr query to retrieve upload data - MetacatUI - Ecoinformatics Redmine

Actions

Task #6432

closed

Feature #5975: Implement 'Statistics' view

Create a Solr query to retrieve upload data

Added by Lauren Walker almost 11 years ago. Updated almost 11 years ago.

Status:

Resolved

Priority:

Normal

Assignee:

Target version:

Start date:

02/27/2014

Due date:

% Done:

0%

Estimated time:

Description

I will need to get number of objects uploaded by a specific user (rightsHolder) grouped into ranges of one month

Actions

#1

Updated by Lauren Walker almost 11 years ago

Status changed from New to Resolved
translation missing: en.field_remaining_hours set to 0.0

We will retrieve all metadata and data objects, even obsoleted ones, and break up facet counts into chunks of one year. Example query is:

https://knb.ecoinformatics.org/knb/d1/mn/v1/query/solr/q=*:*+%28formatType:METADATA%20OR%20formatType:DATA%29&wt=json&rows=0&facet=true&facet.mincount=1&facet.limit=-1&facet.field=formatType&facet.query=dateUploaded:[NOW-13YEARS%20TO%20NOW-12YEARS]&facet.query=dateUploaded:[NOW-12YEARS%20TO%20NOW-11YEARS]&facet.query=dateUploaded:[NOW-11YEARS%20TO%20NOW-10YEARS]&facet.query=dateUploaded:[NOW-10YEARS%20TO%20NOW-9YEARS]&facet.query=dateUploaded:[NOW-9YEARS%20TO%20NOW-8YEARS]&facet.query=dateUploaded:[NOW-8YEARS%20TO%20NOW-7YEARS]&facet.query=dateUploaded:[NOW-7YEARS%20TO%20NOW-6YEARS]&facet.query=dateUploaded:[NOW-6YEARS%20TO%20NOW-5YEARS]&facet.query=dateUploaded:[NOW-5YEARS%20TO%20NOW-4YEARS]&facet.query=dateUploaded:[NOW-4YEARS%20TO%20NOW-3YEARS]&facet.query=dateUploaded:[NOW-3YEARS%20TO%20NOW-2YEARS]&facet.query=dateUploaded:[NOW-2YEARS%20TO%20NOW-1YEARS]&facet.query=dateUploaded:[NOW-1YEARS%20TO%20NOW]

Actions

Also available in: Atom PDF