Qt Metrics 2 Backlog

This is the backlog for Qt Metrics 2 site that is currently under development.

The priority **** items are the core functionality and would be the target prior to launch or wider use.

The priority *** items are considered content/functionality for basic use as requested by the key stateholders.

In case of proposals or improvement ideas please contact Juha Sippola (report builder, database) or Tony Sarajärvi (parser).

Data reliability and completeness (database and parser)

Status	Priority	Item
DONE	****	Show the actual testset parent (not the Qt5 where it was run) (Code Review)
in progress	****	Change build_number (int) to build_key (string) for the new-CI (Code Review); UPDATE: type changed to 64bit int, BIGINT in MySQL
idle	***	Get testfunctions from xml
idle	***	Get testrows from xml
DONE	***	Change testset_run.testcases_xxx to total_xxx (terminology change) (Code Review)
in progress	***	Database indexing and query optimization (for performance)
idle	*	Database normalisation: result fields in the *_run tables should have a separate table instead of the enums (could also make the naming more flexible)
idle	*	Database normalisation: db_status table does not have a primary key (table holds just one row with the latest data)
idle	*	Database normalisation: conf.features is not perfect design, instead a separate feature table should be used (how this information will be used in the end)

Pages and views

Status	Priority	Item
in progress	****	Home page modifications (implemented as part of the Overview, Project, Platform and Testset page changes)
in progress	****	Overview page (Code Review)
in progress	****	Project page (Code Review)
idle	***	Project page: Link to log file
idle	**	Project page: Way to expand the range of builds, include dates to listed builds
in progress	****	Platform page (Code Review)
idle	***	Platform page: Link to log file
idle	**	Platform page: Configuration flag identification
idle	*	Platform page: Identification of configurations where insignificant or force success could be removed
idle	*	Platform page: Filtering mechanism
in progress	***	Configuration page (Code Review)
idle	*	Branch page
DONE	****	Top failing testsets page (Code Review / UI, Code Review / parser)
DONE	****	Top flaky testsets page (see Code Review links for Top failing testsets page)
in progress	****	Testset page (Code Review)
idle	***	Testset page: Link to log file
in progress	***	Testset page: Testset flag identification (Code Review)
idle	**	Testset page: Testset run times
idle	*	Testset page: Filtering mechanism
idle	*	Testset page: Identification of testsets where insignificant could be removed
idle	***	Testfunction page/information
idle	***	Testfunction page/information: Testfunction flag identification
idle	**	Testfunction page/information: Identification of testfunctions where blacklisting could be removed
idle	**	Testfunction page/information: Link to xml file
idle	*	Testfunction page/information: Find skipped testfunctions
idle	***	Testrow page/information
idle	**	Top failed testfunctions page

Graphs

Status	Priority	Item
idle	**	Summary graph of current CI status
idle	**	Build phases by configuration (like on the old metrics page)
idle	*	Build phases by configuration: Tick box to select if idle times are included or not in the Build phases graph
idle	*	Build phases by configuration: Configuration result to the Build phases graph (e.g. to conf title)
idle	*	Build phases by configuration: Add tooltips into Build phases graph (e.g phase name and value)
idle	*	Visualize CI performance via testset execution time (to visualize sequential and parallel runs)
idle	*	Visualize CI performance via the trend of phase duration (one, or several if feasible) across the last 20 builds in selected Project Configuration
idle	*	Improvement progress trend graphs, e.g. on build success rates, build execution times, Configuration and Autotest force success and insignificant flag removals.

Other features

Status	Priority	Item
in progress	****	Web security (Code Review)
in progress	***	Performance and user experience originally planned utilising Ajax but no viable solution found for it, concentrated instead on the database indexing and performance in general (database query change: Code Review; HTML compression: Code Review; HTML minification: Code Review)
in progress	***	Take template engine into use (Code Review)
in progress	**	Indication on content loading (Code Review)
idle	**	API to remove old data from the database (timescale fixed or selectable) keeping the referential integrity in mind
idle	**	Branch archiving (default solution to delete from the db (API?), but could mark branches archived or something)
idle	*	Progress bar when loading page or data
idle	*	Link(s) to other related Qt Metrics
idle	*	Associate gerrit change ids with builds
idle	*	Include the bug id’s for test cases. This requires first a database or other solution where to get the data.
idle	*	Log file parsing helper (a way to find things in the last n logs)
idle	*	Register to receive error reports to a certain module (plus unregister)
idle	*	Report generator to create a detailed text & graph report from a view. This would be applicable for such data that takes long time to extract and format.
idle	*	Data export to excel/pdf from a view
idle	*	Identify which CI build machines failed most often and which CI builds take the longest time to execute
idle	*	Add Google Analytics to get information on the portal usage
idle	*	Support for https

Documentation

Status	Priority	Item
idle	***	Implementation solution description
in progress	***	Database design
in progress	**	Class documentation