forena 7.x-4.0-beta4

Beta 4 Release

This release contains bug fixes and a couple of significant user interface changes most notably:

• Complete help documentation rewrite
• SVG Graphing engine supports pivoting tables (crosstab)
• Performance fixes for sites that use internationalized menus
• Frx Grouping enhancements
• #2347311: Multiple Line Graph, hide null or zero values
• #2324549: Could not give access to non-admin
• #2285287: Call to undefined method DatabaseStatementBase::xpath()
• #2324549: Could not give access to non-admin
• #2278895: Double breaks in reports

7.x-4.0 Release Notes

7.x-4.0 contains significant api changes. Although reports written in 7.x-3.x versions should work the same in 7.x-4.0, changes to the security model have been made.

The report editing user interface has been completely redesigned

Note that the fields tab has been replaced by clicking on the gear icons next to the first occurrence of each field. Also note that you can now use the template editors to make changes to each block. You can add and remove data sections to your report as well. Feedback would be appreciated via the issue queue. Also, The edit and translate tabs have been changed to iconic links that will keep report parameter context to simplify the editing process.

New Features

• Forena query builder now supports SQL auto-completion
• Report editing user interface has been completely redesigend
• Module provided reports are no longer copied to the files directory.
• Caching may now be enabled on a per report bases.
• Accessing data from a data source now requires an "access mysource data" privilege
• ACCESS= comments are now optional in data blocks
• Various UI improvements to the report editing experience
• The forena cache now uses standard drupal caching, no more clearing of the forena cache.
• New FrxCrosstab renderer for making cross tab displays of data
• Support for crosstab generation prior to graphing

Upgrade Instructions

After installing this release you will want to "Revert all Delivered Reports" to original using the same method that you used to copy Forena's reports to begin with. Either visit Structure->Forena Reports , check the box to "Revert Delivered Reports to original" and press the Revert button. Or using drush , execute the drush frxrevert (was called frxcp). This will remove any forena delivered reports from your sites/.../files/reports folder.

Also, please visit revisit your forena permissions as a new permission has been created for each defined database connection.

Finally make sure that if you are using the php SVGGraph library that you have upgraded to at least version 2.11.