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

You can create an index for those results and configure the Advanced Search view to display the values.

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.