Hi helix, I've tried several times to reindex (index-discovery -b) but I still have zero values when doing solr query for breakdown of submitted items per month. I am very sure that I have the dc.date.accessioned metadata field in all of my items. I'm wondering why I have the correct values when doing it in my local instance. In my local instance, I restored the pgdump of our production server and then reindex. Then I tested the solr query and it's working. I also tried restoring (in my local instance) by using the command dspace packager -r -a -f -t AIP and after it finished reindexing, the solr query also worked. So my question now is, what should I do in our production server to make the solr query work? I'm worried that restoring the entire site using packager -r -a -f -t is a little bit extreme just to make this work? Or is it safe to drop the dspace database and then restore it using the backup pgdump? Will it mess up other data in my solr core?
Thanks, euler On Tuesday, August 14, 2018 at 7:43:05 PM UTC+8, helix84 wrote: > > It seems that you're using the schema from DSpace unmodified, the only > change being the default query operator from OR to AND. This schema > creates the *_dt indexes for you from date fields. If, for some > reason, they are not created, try a full reindex. Otherwise the reason > will be that you simply don't have the dc.date.accessioned metadata > field filled in in any of your items. Those should be filled in > automatically by DSpace if you're creating items via input forms, CSV > import or other standard DSpace methods. They may be missing if you're > using some custom import methods. > > Your solution is either to start filling out this field for new > records or to facet by another date field that you're using > (dc.date.issued). > > > Regards, > ~~helix84 > > Compulsory reading: DSpace Mailing List Etiquette > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > > > > On Tue, Aug 14, 2018 at 1:27 PM euler <[email protected] <javascript:>> > wrote: > > > > Hi helix, > > > > Below is an example record from [1]. Attached is the schema.xml [2]. > Thank you so much for your time and attention to this. > > > > Best regards, > > euler > > > > <doc> > > <arr name="dc.contributor.editor_stored"> > > <str> > > Juario, Jesus V. ||| 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| null ||| > 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| > > </str> > > <str> > > Ferraris, R. P. ||| cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| null ||| > cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| > > </str> > > <str> > > Benitez, L. V. ||| f3e5c684-9c35-443b-8864-be239a5944fe ||| null ||| > f3e5c684-9c35-443b-8864-be239a5944fe ||| > > </str> > > </arr> > > <arr name="author"> > > <str>Fortes, Romeo D.</str> > > <str>97876fc9-2d1b-453c-9f75-a4e7965f8b34</str> > > </arr> > > <str name="dc.contributor.author_sort">Fortes, Romeo D.</str> > > <arr name="dc.citation.spage"> > > <str>107</str> > > </arr> > > <arr name="dc.subject_mlt"> > > <str>Chanos chanos</str> > > <str>Philippines</str> > > </arr> > > <arr name="dc.publisher.en"> > > <str> > > Published by Island Pub. House in association with the Aquaculture > Dept., Southeast Asian Fisheries Development Center and the International > Development Research Centre > > </str> > > </arr> > > <date name="dc.date.issued_dt">1984-01-01T00:00:00Z</date> > > <arr name="editor_keyword"> > > <str>Juario, Jesus V.</str> > > <str>25d39231-ff36-4279-a9d7-77c595acd0d9</str> > > <str> > > > 25d39231-ff36-4279-a9d7-77c595acd0d9###25d39231-ff36-4279-a9d7-77c595acd0d9 > > </str> > > <str>Ferraris, R. P.</str> > > <str>cf922f2a-122b-4d83-b01a-79c6ab702d0a</str> > > <str> > > > cf922f2a-122b-4d83-b01a-79c6ab702d0a###cf922f2a-122b-4d83-b01a-79c6ab702d0a > > </str> > > <str>Benitez, L. V.</str> > > <str>f3e5c684-9c35-443b-8864-be239a5944fe</str> > > <str> > > > f3e5c684-9c35-443b-8864-be239a5944fe###f3e5c684-9c35-443b-8864-be239a5944fe > > </str> > > </arr> > > <arr name="dc.language.iso"> > > <str>en</str> > > </arr> > > <str name="handle">10862/170</str> > > <str name="search.uniqueid">2-154</str> > > <arr name="subject"> > > <str>Chanos chanos</str> > > <str>Chanos chanos</str> > > <str>Philippines</str> > > <str>Philippines</str> > > <str>Aquaculture techniques</str> > > <str>Aquaculture techniques</str> > > <str>Brackishwater aquaculture</str> > > <str>Brackishwater aquaculture</str> > > <str>Fish culture</str> > > <str>Fish culture</str> > > <str>Pond culture</str> > > <str>Pond culture</str> > > </arr> > > <arr name="subject_keyword"> > > <str>Chanos chanos</str> > > <str>Chanos chanos</str> > > <str>Chanos chanos###39259</str> > > <str>Chanos chanos</str> > > <str>Philippines</str> > > <str>Philippines</str> > > <str>Philippines###5783</str> > > <str>Philippines</str> > > <str>Aquaculture techniques</str> > > <str>Aquaculture techniques</str> > > <str>Aquaculture techniques###Aquaculture techniques</str> > > <str>Aquaculture techniques</str> > > <str>Brackishwater aquaculture</str> > > <str>Brackishwater aquaculture</str> > > <str> > > Brackishwater aquaculture###Brackishwater aquaculture > > </str> > > <str>Brackishwater aquaculture</str> > > <str>Fish culture</str> > > <str>Fish culture</str> > > <str>Fish culture###Fish culture</str> > > <str>Fish culture</str> > > <str>Pond culture</str> > > <str>Pond culture</str> > > <str>Pond culture###Pond culture</str> > > <str>Pond culture</str> > > </arr> > > <int name="search.resourceid">154</int> > > <arr name="bi_2_dis_partial"> > > <str>97876fc9-2d1b-453c-9f75-a4e7965f8b34</str> > > <str>Fortes, Romeo D.</str> > > </arr> > > <arr name="dc.type.en"> > > <str>Conference paper</str> > > </arr> > > <int name="search.resourcetype">2</int> > > <arr name="editor_ac"> > > <str>juario, jesus v. ||| Juario, Jesus V.</str> > > <str> > > 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| > 25d39231-ff36-4279-a9d7-77c595acd0d9 > > </str> > > <str>ferraris, r. p. ||| Ferraris, R. P.</str> > > <str> > > cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| > cf922f2a-122b-4d83-b01a-79c6ab702d0a > > </str> > > <str>benitez, l. v. ||| Benitez, L. V.</str> > > <str> > > f3e5c684-9c35-443b-8864-be239a5944fe ||| > f3e5c684-9c35-443b-8864-be239a5944fe > > </str> > > </arr> > > <arr name="dc.date.available"> > > <str>2011-06-08T09:47:49Z</str> > > </arr> > > <arr name="dc.subject"> > > <str>Chanos chanos</str> > > <str>Philippines</str> > > </arr> > > <arr name="type"> > > <str>Conference paper</str> > > </arr> > > <arr name="dc.date.issued_stored"> > > <str>1984-01-01 ||| null ||| null ||| null ||| </str> > > </arr> > > <arr name="location.coll"> > > <str>14</str> > > </arr> > > <str name="dateIssued.year_sort">1984</str> > > <arr name="title_keyword"> > > <str> > > Milkfish culture techniques generated and developed by the Brackishwater > Aquaculture Center > > </str> > > </arr> > > <arr name="subject_acid"> > > <str>chanos chanos ||| Chanos chanos###39259</str> > > <str>philippines ||| Philippines###5783</str> > > <str> > > aquaculture techniques ||| Aquaculture techniques###Aquaculture > techniques > > </str> > > <str> > > brackishwater aquaculture ||| Brackishwater aquaculture###Brackishwater > aquaculture > > </str> > > <str>fish culture ||| Fish culture###Fish culture</str> > > <str>pond culture ||| Pond culture###Pond culture</str> > > </arr> > > <arr name="bi_4_dis_filter"> > > <str> > > brackishwater aquaculture ||| Brackishwater aquaculture###Brackishwater > aquaculture > > </str> > > <str>philippines ||| Philippines###5783</str> > > <str>chanos chanos ||| Chanos chanos###39259</str> > > <str> > > aquaculture techniques ||| Aquaculture techniques###Aquaculture > techniques > > </str> > > <str>fish culture ||| Fish culture###Fish culture</str> > > <str>pond culture ||| Pond culture###Pond culture</str> > > </arr> > > <arr name="bi_2_dis_authority_filter"> > > <str>97876fc9-2d1b-453c-9f75-a4e7965f8b34</str> > > </arr> > > <arr name="dateIssued"> > > <str>1984-01-01</str> > > </arr> > > <arr name="dc.title_hl"> > > <str> > > Milkfish culture techniques generated and developed by the Brackishwater > Aquaculture Center > > </str> > > </arr> > > <date name="SolrIndexer.lastIndexed">2018-08-14T08:52:40Z</date> > > <arr name="dc.citation.epage"> > > <str>119</str> > > </arr> > > <arr name="editor_filter"> > > <str> > > 25d39231-ff36-4279-a9d7-77c595acd0d9 ||| > 25d39231-ff36-4279-a9d7-77c595acd0d9###25d39231-ff36-4279-a9d7-77c595acd0d9 > > </str> > > <str> > > cf922f2a-122b-4d83-b01a-79c6ab702d0a ||| > cf922f2a-122b-4d83-b01a-79c6ab702d0a###cf922f2a-122b-4d83-b01a-79c6ab702d0a > > </str> > > <str> > > f3e5c684-9c35-443b-8864-be239a5944fe ||| > f3e5c684-9c35-443b-8864-be239a5944fe###f3e5c684-9c35-443b-8864-be239a5944fe > > </str> > > </arr> > > <arr name="location.comm"> > > <str>8</str> > > <str>4</str> > > <str>1</str> > > </arr> > > <str name="bi_sort_2_sort">1984</str> > > <arr name="dc.contributor.editor"> > > <str>Juario, Jesus V.</str> > > <str>Ferraris, R. P.</str> > > <str>Benitez, L. V.</str> > > </arr> > > <arr name="dateIssued.year"> > > <int>1984</int> > > </arr> > > <arr name="dc.title"> > > <str> > > Milkfish culture techniques generated and developed by the Brackishwater > Aquaculture Center > > </str> > > </arr> > > <arr name="dc.contributor.author_stored"> > > <str> > > Fortes, Romeo D. ||| 97876fc9-2d1b-453c-9f75-a4e7965f8b34 ||| null ||| > 97876fc9-2d1b-453c-9f75-a4e7965f8b34 ||| > > </str> > > </arr> > -- 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 [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.
