Enhancement to Enable Database Visibility and CBQL Query Capabilities for Supporting Data Operations in the Reports Module

Description:

Currently, Codebeamer does not provide access to the database schema, which limits advanced data exploration and reporting capabilities. In addition, administrators have limited visibility into background jobs and report executions initiated by users.

Problem Statement:

• No direct visibility of database structure restricts advanced querying needs.
• Reports page does not allow flexible querying using CBQL.
• Administrators lack visibility into:
  • Who initiated a report or query
  • Current job execution status
  • History of executed jobs
• This creates challenges in monitoring system usage, troubleshooting failures, and ensuring governance.

Proposed Enhancement:

Introduce the following capabilities, especially for admin users:

1. CBQL Query Execution in Reports Page

   • Enable running CBQL queries directly from the Reports interface.
   • Allow advanced filtering and data retrieval without DB access.

2. Admin Job Monitoring Dashboard

   • Provide a dashboard where admins can:
     • View all running and completed jobs
     • Identify which user initiated each job
     • Track job status (Running, Completed, Failed)
     • View execution time and logs

3. Audit & Traceability

   • Maintain history of queries/reports executed
   • Enable traceability for system usage and performance analysis

Expected Benefits:

• Improved administrative control and transparency
• Better system monitoring and troubleshooting
• Enhanced data accessibility without database dependency
• Stronger governance and audit capabilities
• Faster root-cause analysis for failures or performance issues