SYSTEM AND METHOD FOR REPORTING MULTIPLE OBJECTS IN ENTERPRISE CONTENT MANAGEMENT

Systems and methods for multi-object reporting in a content management system. A report type definition may define which objects are involved and how they are related. A report execution engine may generate a multi-object query language statement to translate the report type definition into query language. A query language execution engine may break the query language statement down into separate single pieces. A cost optimization engine may determine if it is cost efficient to join the objects. An indexed access execution engine may extract unique IDs of the objects and join the unique IDs to generate an index. A Lucene based search engine may be accessed according to the index, and the response is post processed to generate a multi-object report. A case management controller may receive a case narrative for an adverse event in the storage device, and store the case narrative to the storage device.