The timeline chart dataset tables now have localized header titles and numbers in the table are localized with Globalize. (Redmine issue: #4321)

(Redmine issue: #4321)

(Redmine issue: #3387)

Implemented prototype of collapsible dataset view and downloadable dataset option for timeline charts.

All timeline charts in reporting dashboard and timeline module now support displaying of chart datasets in tables within collabsible sidebar. Additionaly the chart dataset can now be downloaded as CSV file for easy import into table processor software like LibreOffice. (Redmine issue: #4321)

This was done to avoid duplication of titles in case there are more charts providing view to the same data. (Redmine issue: #4321)

(Redmine issue: #4321)

(Redmine issue: #4321)

Previously the JS code for charts was generated from Jinja2 templates. New approach uses chart factory functions in separate JS file and much more simple Jinja2 templates. (Redmine issue: #4321)

Unnecessary optimalization. (Redmine issue: #4321,#3443)

(Redmine issue: #3387)

(Redmine issue: #3361)

Radko Krkoš authored 6 years ago and Jan Mach committed 6 years ago

Added lessons learned from DB optimization on mentat-alt and mentat-dev. (Redmine issue: #4301)

Updated the DB schema representation. (Redmine issue: #4363)

(Redmine issue: #4321)

(Redmine issue: #3443)

When searching reports by time, the report createtime attribute is now used instead of report time window information. I think, that the moment the event is being reported is more usefull to the user that the time window for which it was generated. (Redmine issue: #4321)

(Redmine issue: #4321)

(Redmine issue: #3387)

(Redmine issue: #4321)

Enabled the 'classes' and 'severities' pie charts for event and report dashboards and report detail. (Redmine issue: #4321)

The IDEA event dashboard and timeline calculations are taking too long. I have attempted to optimize the performance as much as possible without bigger design changes. (Redmine issue: #4321)

Improved the calculations of time step size for timeline charts. Improved the format of rendered time stamp for chart time scale. (Redmine issue: #4321)

(Redmine issue: #3361,#3443)

(Redmine issue: #4321)

(Redmine issue: #1017)

(Redmine issue: #4321)

Each of the sub-statistics like number of events per category, abuse etc. is not rendered in separate timeline chart. (Redmine issue: #4321)

(Redmine issue: #4321)

Because the other pats of code use timezone unaware timestamps implicitly in UTC. (Redmine issue: #4321)

When fetching data from database, the 'event' column is not retrieved, because it is not necessary for instantinating the IdeaGhost event class. (Redmine issue: #4321)

When the time interval is not explicitly set, the minimal detection time value is retrieved from database and used as chart beginning. The current time is used as chart end. This approach enabled us to retrieve the dataset from the database unsorted and it might produce performance boost. (Redmine issue: #4321)

Removed files, that were accidentally copied when creating the pluggable timeline module.

All renderable views now have the ability to create time marks to enable tracing the most expensive operations. First view using this feature is the new timeline search view, because we need the right place to focus our performance optimization. (Redmine issue: #4321)

The improvement is not fetching all table columns for simple row counting operation.

This module attempts to display the events on a timeline to show event distribution over the period of time. This commit contains initial work, which still needs a lot of improvement before production release. It is nevertheless working. (Redmine issue: #4321)

After lots of research I have discovered, that the problem was in flask_principal not getting information about identity change. This was not discovered during testing, because for some reason API token authentication works after previous login/logout of the user. Problem only occurs when accessing the API using curl or similar tool, or without prior user authentication within the browser. I have found a solution in this thread:

https://github.com/mattupstate/flask-principal/issues/22#issuecomment-145897838

This commit should resolve the issue. (Redmine issue: #4463)

(Redmine issue: #3387)

(Redmine issue: #3387)