Re: [dspace-tech] Number of facets in a SOLR statistics query
I found it - it can be done with facet.mincount=1 On Friday, November 9, 2018 at 10:42:45 AM UTC+2, Evgeni Dimitrov wrote: > > Thank you Terry, > > The librarians asked for numbers for each of the 500 items in the > "community". And the above query gives them. But I don't want to fix the > number for facet.limit=600 - to be possible to run the same when the > "community" gets bigger. But when I set facet.limit=-1, I get 112000 facets > - one for every item in the repository - with zeroes in the items not > belonging to this "community". I am looking for a query, which does not > depend on the size of the "community" and which returns one facet for every > item of the "community" only. > > On Thursday, November 8, 2018 at 9:51:26 PM UTC+2, Terry Brady wrote: >> >> Evgeni, >> >> When I am looking at usage statistics, I tend to facet values by time >> rather than by id. >> >> The following presentation has some recommended Solr Stats queries that >> might be useful to try: >> https://gitpitch.com/terrywbrady/TutorialSolrAdmin#/6/1 >> y >> Terry >> >> On Thu, Nov 8, 2018 at 1:30 AM Evgeni Dimitrov >> wrote: >> >>> This is in DSpace 6.2 >>> >>> I want to get the usage (view and search, workflow is not used) of all >>> items in a small "community". >>> I use the query >>> >>> q=type:2& >>> fq=owningComm:94a589a1-33a0-41e3-a83b-f7644db9a1a5& >>> fq=-isBot:true& >>> fq=time:[2018-10-01T00:00:00Z TO 2018-11-01T00:00:00Z]& >>> rows=0& >>> facet=true& >>> facet.field=id& >>> facet.limit=600& >>> indent=on >>> >>> It works, but I don't want to fix a number for facet.limit. And I set >>> >>> facet.limit=-1 (they say this means unlimited) >>> >>> It works again, but it returned 112000 facets, which seems to me a bit >>> excessive. >>> >>> Is there a better way to get the result? >>> >>> >>> -- >>> All messages to this mailing list should adhere to the DuraSpace Code of >>> Conduct: https://duraspace.org/about/policies/code-of-conduct/ >>> --- >>> 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 dspace-tech...@googlegroups.com. >>> To post to this group, send email to dspac...@googlegroups.com. >>> Visit this group at https://groups.google.com/group/dspace-tech. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> -- >> Terry Brady >> Applications Programmer Analyst >> Georgetown University Library Information Technology >> https://github.com/terrywbrady/info >> 425-298-5498 (Seattle, WA) >> > -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
Re: [dspace-tech] Number of facets in a SOLR statistics query
Thank you Terry, The librarians asked for numbers for each of the 500 items in the "community". And the above query gives them. But I don't want to fix the number for facet.limit=600 - to be possible to run the same when the "community" gets bigger. But when I set facet.limit=-1, I get 112000 facets - one for every item in the repository - with zeroes in the items not belonging to this "community". I am looking for a query, which does not depend on the size of the "community" and which returns one facet for every item of the "community" only. On Thursday, November 8, 2018 at 9:51:26 PM UTC+2, Terry Brady wrote: > > Evgeni, > > When I am looking at usage statistics, I tend to facet values by time > rather than by id. > > The following presentation has some recommended Solr Stats queries that > might be useful to try: > https://gitpitch.com/terrywbrady/TutorialSolrAdmin#/6/1 > y > Terry > > On Thu, Nov 8, 2018 at 1:30 AM Evgeni Dimitrov > wrote: > >> This is in DSpace 6.2 >> >> I want to get the usage (view and search, workflow is not used) of all >> items in a small "community". >> I use the query >> >> q=type:2& >> fq=owningComm:94a589a1-33a0-41e3-a83b-f7644db9a1a5& >> fq=-isBot:true& >> fq=time:[2018-10-01T00:00:00Z TO 2018-11-01T00:00:00Z]& >> rows=0& >> facet=true& >> facet.field=id& >> facet.limit=600& >> indent=on >> >> It works, but I don't want to fix a number for facet.limit. And I set >> >> facet.limit=-1 (they say this means unlimited) >> >> It works again, but it returned 112000 facets, which seems to me a bit >> excessive. >> >> Is there a better way to get the result? >> >> >> -- >> All messages to this mailing list should adhere to the DuraSpace Code of >> Conduct: https://duraspace.org/about/policies/code-of-conduct/ >> --- >> 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 dspace-tech...@googlegroups.com . >> To post to this group, send email to dspac...@googlegroups.com >> . >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > Terry Brady > Applications Programmer Analyst > Georgetown University Library Information Technology > https://github.com/terrywbrady/info > 425-298-5498 (Seattle, WA) > -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
Re: [dspace-tech] Number of facets in a SOLR statistics query
Evgeni, When I am looking at usage statistics, I tend to facet values by time rather than by id. The following presentation has some recommended Solr Stats queries that might be useful to try: https://gitpitch.com/terrywbrady/TutorialSolrAdmin#/6/1 Terry On Thu, Nov 8, 2018 at 1:30 AM Evgeni Dimitrov wrote: > This is in DSpace 6.2 > > I want to get the usage (view and search, workflow is not used) of all > items in a small "community". > I use the query > > q=type:2& > fq=owningComm:94a589a1-33a0-41e3-a83b-f7644db9a1a5& > fq=-isBot:true& > fq=time:[2018-10-01T00:00:00Z TO 2018-11-01T00:00:00Z]& > rows=0& > facet=true& > facet.field=id& > facet.limit=600& > indent=on > > It works, but I don't want to fix a number for facet.limit. And I set > > facet.limit=-1 (they say this means unlimited) > > It works again, but it returned 112000 facets, which seems to me a bit > excessive. > > Is there a better way to get the result? > > > -- > All messages to this mailing list should adhere to the DuraSpace Code of > Conduct: https://duraspace.org/about/policies/code-of-conduct/ > --- > 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 dspace-tech+unsubscr...@googlegroups.com. > To post to this group, send email to dspace-tech@googlegroups.com. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology https://github.com/terrywbrady/info 425-298-5498 (Seattle, WA) -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
[dspace-tech] Number of facets in a SOLR statistics query
This is in DSpace 6.2 I want to get the usage (view and search, workflow is not used) of all items in a small "community". I use the query q=type:2& fq=owningComm:94a589a1-33a0-41e3-a83b-f7644db9a1a5& fq=-isBot:true& fq=time:[2018-10-01T00:00:00Z TO 2018-11-01T00:00:00Z]& rows=0& facet=true& facet.field=id& facet.limit=600& indent=on It works, but I don't want to fix a number for facet.limit. And I set facet.limit=-1 (they say this means unlimited) It works again, but it returned 112000 facets, which seems to me a bit excessive. Is there a better way to get the result? -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.