How can I have the Last Mod By column show the last user to modify an object with a change status operation?

You can add some new indexes to show this operation.

Description

When a user changes the status of an object without making any edits, the action is not displayed in the Last Mod By column. For example, if user1 edits and releases a topic and moves it to Authoring:done and then user2 moves it back to Authoring:work, the Last Mod By column shows user1 instead of user2.

Solution

In the TEXTML Administration perspective, perform the following:

Edit the Index Definition file.
CAUTION: Be careful when editing the Index Definition document. Changes can significantly affect the indexing process, and any errors in the document can lead to data corruption or other errors. Consult with IXIASOFT Customer Support before making changes if you are unsure.

Add the following three indexes. The third one may already exist.

<index NAME="system_comment_timestamp" CUSTOMPROPERTY="True" SYNC="False">
   <dateindex KEEPEXTRACTEDVALUES="True">
      <dateindexproperties>
         <datevalidation VALUE="TimeStamp"/>
         <formats>
            <format NAME="ISO 8601"/>
         </formats>
      </dateindexproperties>
      <elements>
         <element DEPTH="0" XPATH="distinct-values(/customproperties/systemComment/@date)"/>
      </elements>
   </dateindex>
</index>

<index NAME="system_comment_action" CUSTOMPROPERTY="True" SYNC="False">
   <stringindex KEEPEXTRACTEDVALUES="True">
      <elements>
         <element DEPTH="0" XPATH="distinct-values(/customproperties/systemComment/@actionName)"/>
      </elements>
   </stringindex>
</index>

<index NAME="lastmodtime" CUSTOMPROPERTY="True" SYNC="True">
   <dateindex KEEPEXTRACTEDVALUES="True" KEEPSORTBYUNITINFO="False">
      <dateindexproperties>
         <datevalidation VALUE="TimeStamp"/>
         <formats>
            <format NAME="ISO 8601"/>
         </formats>
      </dateindexproperties>
      <elements>
         <element DEPTH="INFINITE" XPATH="//lastmodtime"/>
      </elements>
   </dateindex>
</index>

At the bottom of the Index Definition file, add the following to the summaries:
```
<field NAME="lastmodtime" TYPE="Index" VALUE="All"/>
```

To add the index to the display columns, edit the system/conf/display.xml file and add the following:

<key halign="LEFT" label="CCMS Metadata Mod Time" name="lastmodtime" sortOrder="ASC" sortType="NUMERIC" type="Index" visibility="255" width="30"/>

To add to the Advanced Search in the Search view, edit the advancedsearchindexes.xml file and add the following to the <indexes> section:
```
<index attr="true" display="SystemCommentAction" listable="true" name="system_comment_action" type="index" views="ALL"/>
```

In the advancedsearchindexes.xml file, add the following to the <dates> section:

<date display="SystemCommentTimestamp" name="system_comment_timestamp" timeindex="system_comment_timestamp" type="index" views="ALL"/>

When the index has finished indexing, restart your IXIA CCMS Desktop and add the CCMS Metadata Mod Time column to your views.
Note: The Advanced Search can be used as follows: