Enabling sorting on Placed On columns in Enterprise Server 9 with Solr installed

When Solr Search is integrated in Enterprise Server, the metadata properties 'Placed On' and 'Placed on Page' are not indexed by Solr. These properties can be used as columns in the Document pane in Content Station and Smart Connection, but because te properties are not indexed, the columns cannot be sorted.

To enable sorting, follow these steps:

Step 1. Open the config_solr.php file and locate the SOLR_INDEX_FIELDS definition.

define ('SOLR_INDEX_FIELDS', serialize( array(

'ID',

'Publication',

'PublicationId', //Mandatory

'IssueId', //Mandatory

'Name',

...

Step 2. Add the following fields to the list:

• PlacedOn
• PlacedOnPage

define ('SOLR_INDEX_FIELDS', serialize( array(

'ID',

'Publication',

'PublicationId', //Mandatory

'IssueId', //Mandatory

'Name',

'PlacedOn',

'PlacedOnPage',

//'C_STRING',

...

Step 3. Open the schema.xml file in your $SOLR_HOME/config folder.

Step 4. Search for the PageRange definition:

<field name="PageRange" type="string" indexed="true" stored="true"/>

Step 5. Add the new fields after the “PageRange” definition:

<field name="PlacedOnPage" type="onlySort" indexed="true" stored="true"/>

<field name="PlacedOn" type="onlySort" indexed="true" stored="true"/>

Step 6. Restart the Solr application to make it load the new schema.xml.

Note: This can be done either on the command line, in the TomCat management application or by restarting the server.

Step 7. Access the Search Server Maintenance page in Enterprise Server.

Step 8. In the Indexing section, click Clear, followed by Start.

It should now be possible to sort the columns 'Placed On' and 'Placed on Page'.