You can create a report definition or use one of the six definition files delivered with IBM® Enterprise Records and stored in a file plan object store.
The report title is the title of the report that IBM Enterprise Records displays.
<setting key="title" localizationKey="server.report_title.n">report title</setting>The description is text that IBM Enterprise Records displays, briefly describing the purpose of the report. For example, This report shows only the actions that were completed after you enabled auditing on a record category, folder, volume, or record.
<setting key="desc" localizationKey="server.report_desc.n">description</setting>The entry help is text that IBM Enterprise Records displays in the help entry of the report. For example, "The generated report lists only the actions that were completed after you enabled auditing."
<setting key="entryhelp" localizationKey="server.entryhelp.n">entry help</setting>The table name is a database table name that the IBM Enterprise Records report engine uses to retrieve the results from the IBM Enterprise Records repository. This name is also used to produce the results in an intermediary database table that the report applications can use. For example, ActionPerformed.
<setting key="db_table_name">table name</setting>The report name is the name of the report template created in a reports application.
<setting key="reportName" localizationKey="server.report_name.n">report name</setting><object key="property"> <setting key="symbolicname">symbolic name</setting>
<setting key="required">1</setting> </object>
where symbolic
name is new criteria you created or any of the following
setting keys:<object key="property">
<setting key="symbolicname">entity_type</setting>
<setting key="required">1</setting>
Add <list
key="values"> where you enter the entity types that a user
can select to include in the report. For example: <list key="values">
<object key="value">
<setting key="id">EntityType</setting>
<setting key="value" localizationKey=serve.report_n.EntityType">Entity</setting>
</object>
where:<object key="property">
<setting key="symbolicName">rm_entity_type</setting>
<setting key="required">1</setting>
<list key="values'>
<object key="value">
<setting key="id">RecordCategory</setting>
<setting key="value" localization Key="server.report_1.RecordCategory">Record Category</setting>
</object>
<object key="value">
<setting key="id">RecordFolder</setting>
<setting key="value" localization Key="server.report_1.RecordFolder">Record Folder</setting>
</object>
</list>
</object>
<list key="report queries">
<object key="query">
<setting key="sql">SELECT EV.LastModifier, EV.DateCreated, EV.ClassDescription, EV.AuditActionType,RC.RecordCategoryName AS EntityName, RMF.PathName, RC.Aggregation FROM (Event EV INNER JOIN RecordCategory RC ON EV.SourceObjectID = RC.ID)INNER JOIN RMFOLDER RMF on RC.parent=RMF.This WHERE EV.DateCreated >= {?start_date} AND EV.DateCreated <= {?end_date} AND EV.LastModifier = '{?user_name}' AND RC.this INSUBFOLDER '/{?fileplan_name}'</setting>
<setting key="my_entity_type">RecordCatagory</setting>
</object>
<object key="query">
<setting key="sql">SELECT EV.LastModifier, EV.DateCreated, EV.ClassDescription, EV.AuditActionType,RF.RecordFolderName AS EntityName,RMF.PathName, RF.Aggregation FROM (Event EV INNER JOIN RecordFolder RF ON EV.SourceObjectID = RF.ID)INNER JOIN RMFOLDER RMF on RF.parent=RMF.This WHERE EV.DateCreated >= {?start_date} AND EV.DateCreated <= {?end_date} AND EV.LastModifier = '{?user_name}' AND RF.this INSUBFOLDER '/{?fileplan_name}'</setting>
<setting key="my_entity_type">RecordFolder</setting>
</object>
<list>