How can I find the topics that changed status within a date range?

Symptom

You cannot find a way to search for all topics that were moved from one status to another within a certain date range. For example, from Authoring:done to Authoring:work.

Problem

This index is not defined in the default configuration and must be added manually.

Solution

In the TEXTML Administration perspective, perform the following:

1. Edit the Index Definition file to add the following index. For example, to find all the topics that were moved from Authoring:done to Authoring:work within a certain date range you would define the index as follows:

   <index NAME="DonetoWork" CUSTOMPROPERTY="True" SYNC="False">   
   	<dateindex KEEPEXTRACTEDVALUES="True"> 
   		<dateindexproperties>     
   			<datevalidation VALUE="YearMonthDay"/>   
   				<formats>     
   					<format NAME="ISO 8601"/>   
   				</formats>    
   		</dateindexproperties>    
   		<elements>     
   			<element XPATH="//systemComment[contains( text(), 'Authoring:done to Authoring:work')]/@date" DEPTH="INFINITE"/>    
   		</elements>                 
   	</dateindex>
   </index> 

2. Edit the system/conf/advancedSearchIndexes.xml file.
3. In the <dates> section, add the new index.

   <date display="Done to Work" name="DonetoWork" type="index" views="ALL"/>

4. Right-click on your Content Store. Click Rebuild All Indexes.
5. When the index has finished indexing, restart your IXIASOFT CCMS Desktop.