Apache Solr视图中自定义日期字段的排序与格式适配问题咨询

Let's break down and solve your two problems step by step:

1. Resolving "cannot sort on multivalued field" Error #

The root cause here is that your Solr field dm_field_last_archived_date is configured as a multivalued field, and Solr doesn't allow sorting on fields that can hold multiple values. Here's how to fix it:

• First, check your Solr schema (either schema.xml for older versions or managed-schema for newer setups) — look for the definition of dm_field_last_archived_date and confirm if multiValued="true" is set. If yes, update it to multiValued="false".
• Head back to your Drupal site: Navigate to the Solr index configuration for your content type, and ensure the field_last_archived_date is set to single-value (date fields almost never need to store multiple entries, so this should be the default if you configured the field correctly).
• After adjusting these settings, re-index all your content to refresh the Solr index with the corrected field configuration. Once re-indexing finishes, the sort functionality should work without errors.

2. Correct Date Format for Exposed Date Range Filter #

Solr uses ISO 8601 date formats by default, but you have user-friendly options depending on your setup:

• Direct Solr-compatible input: If you're typing dates manually into the filter, use the full ISO format like 2011-10-01T00:00:00Z (UTC time) or even just the date component 2011-10-01 — Solr will automatically handle the time portion for range queries.
• Human-readable format (no technical syntax required): Instead of forcing users to input T/Z suffixes, tweak your view's exposed filter settings:
  • Edit the exposed date range filter linked to field_last_archived_date.
  • Under the "Filter format" section, pick a locale-friendly format like MM/DD/YYYY or DD/MM/YYYY.
  • Drupal's Solr integration will automatically convert this user-friendly input into the ISO format Solr expects, so you don't need to handle the technical syntax manually.
• Double-check that the filter is set to date range type and mapped to the correct Solr field dm_field_last_archived_date in the view configuration.

内容的提问来源于stack exchange，提问作者Pratip Ghosh