Not sure why it's failing but the innocuously looking "and" seems to
be the culprit. You can leave it out as "and" is the default for the
statistics core anyway[1]:

http://localhost:1234/solr/statistics/select?q=type:4+id:251&fq=statistics_type:view&fq=-isBot:true&fl=uid+score+&df=id&wt=xml&indent=true&facet=true&facet.field=id

[1] 
https://github.com/DSpace/DSpace/blob/dspace-5_x/dspace/solr/statistics/conf/schema.xml#L339


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette


On Tue, Sep 13, 2016 at 1:49 PM, Rafa Carreres <[email protected]> wrote:
> Thank you Helix,
>
> Now, I am doing some progress.
> First, I find all the items under a certain community, let's say, community
> 251.
> With this query
> http://localhost:1234/solr/search/select?q=search.resourcetype:2+and+location.comm:251&fq=discoverable:true&fq=withdrawn:false&fl=search.uniqueid+handle+location.coll&wt=csv&indent=true
>
> I get some results:
>
> search.uniqueid,handle,location.coll
> 2-19076,10045/16013,"1684,1024,545"
> 2-19074,10045/16011,1684
> 2-19077,10045/16014,1684
> 2-15382,10045/13384,1367
> 2-28824,10045/23756,731
> 2-32318,10045/26477,3395
> 2-33005,10045/26958,3395
> 2-32309,10045/26471,3395
> 2-32312,10045/26473,3395
> 2-32311,10045/26472,3395
>
> etc....
>
>
>
>
> Now, for a the same community I am trying to get the stastistics hits but I
> don't know how to.
>
> I've tried this query but with no results:
> http://localhost:1234/solr/statistics/select?q=type:4+and+id:251&fq=statistics_type:view&fq=-isBot:true&fl=uid+score+&df=id&wt=xml&indent=true&facet=true&facet.field=id
>
> Here is  the output:
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
>
> <lst name="responseHeader">
>   <int name="status">0</int>
>   <int name="QTime">3</int>
>   <lst name="params">
>     <str name="q">type:2 and id:19076</str>
>     <str name="df">id</str>
>     <str name="facet.field">id</str>
>     <str name="indent">true</str>
>     <str name="fl">uid, score </str>
>     <arr name="fq">
>       <str>statistics_type:view</str>
>       <str>-isBot:true</str>
>     </arr>
>     <str name="wt">xml</str>
>     <str name="facet">true</str>
>     <str name="_">1473766954959</str>
>   </lst>
> </lst>
> <result name="response" numFound="0" start="0" maxScore="0.0">
> </result>
> <lst name="facet_counts">
>   <lst name="facet_queries"/>
>   <lst name="facet_fields">
>     <lst name="id">
>       <int name="101142">0</int>
>       <int name="101804">0</int>
>       <int name="1024">0</int>
>       <int name="103145">0</int>
>       <int name="103259">0</int>
>       <int name="103266">0</int>
>       <int name="103303">0</int>
>       <int name="103304">0</int
>
> ................
>
>               <int name="49802">0</int>
>
>       <int name="49803">0</int>
>     </lst>
>   </lst>
>   <lst name="facet_dates"/>
>   <lst name="facet_ranges"/>
>   <lst name="facet_intervals"/>
> </lst>
> </response>
>
>
> What am I doing wrong?
>
>
> Regards,
>
>
>
> On Friday, September 9, 2016 at 3:18:20 PM UTC+2, helix84 wrote:
>>
>> You'll find general information about direct Solr queries on this wiki
>> page:
>>
>> https://wiki.duraspace.org/display/DSPACE/Solr
>>
>> Also, two of the example queries can be combined to give you almost
>> the exact answer you want. The thing is that the statistics data
>> resides in a different index (statistics) than the hierarchy data
>> (search), so either do the combining in the code running the query or
>> look into "Multicore join queries", also mentioned on that wiki page.
>>
>>
>> Regards,
>> ~~helix84
>>
>> Compulsory reading: DSpace Mailing List Etiquette
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>
>>
>>
>> On Fri, Sep 9, 2016 at 3:10 PM, Rafa Carreres <[email protected]> wrote:
>> > Hi,
>> >
>> > I need to find out by means of a SOLR direct query "Top 5 of most viewed
>> > items in a certain collection or community".
>> >
>> > It doesn't look like a complicated query but I have no idea about this.
>> > Besides, I've found it hard to get information about direct SOLR
>> > queries.
>> >
>> >  I would really appreciate some help.
>> >
>> > Regards,
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> > Groups
>> > "DSpace Technical Support" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> > an
>> > email to [email protected].
>> > To post to this group, send email to [email protected].
>> > Visit this group at https://groups.google.com/group/dspace-tech.
>> > For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Reply via email to