Changelog

ART 3.5 (22 April 2018)

  • Add field to indicate use of groovy instead of sql in report source
  • Added pivotTableJs, c3 and plotly as report formats for tabular reports
  • Updated chinese translation
  • Fix for mongodb reports showing blank
  • Fix for dygraph database reports not working
  • Fix for test dashboard report not using updated source
  • Allow dynamic change of chart type for C3.js reports
  • Added date range parameter type
  • Added Plotly.js report type
  • Fix for jobs select/deselect all in access rights config updating report groups

ART 3.4 (12 April 2018)

  • Allow jobs to specify the time zone in which the schedule will run
  • Include template file in report export/import
  • Provide a REST API for dealing with users. This is experimental and subject to change.
  • Allow users to save parameter selections
  • Allow use of GroovyRowResult data with “usesGroovy” queries
  • Updated French translation (thanks to Pierre Blanchou)
  • Have job next run date consider holidays
  • Allow specifying of parameter default values for users and user groups
  • Allow parameters to use fixed values
  • Fix for secondary charts not being used
  • Allow testing of report in edit report page
  • Updated univocity-parsers, spring

ART 3.3 (11 March 2018)

  • Allow sending of email if there is an error with a particular job
  • Added ReportEngine report types
  • Fix for double values only showing one decimal value by default
  • Allow dynamic recipient query to specify file open or modify password
  • Added password encryptor
  • Fix for multiple c3.js, pivottable.js, reactpivot, dygraphs, datatables, chart.js, datamaps, leaflet, openlayers, orgchart reports within a dashboad not displaying correctly. Leaflet and OpenLayers template files will require replacing the ‘map’ element id with the variable mapId.
  • Allow import/export of repository artefacts
  • Fix for inability to enter chained depends values more than 2 characters

ART 3.2 (09 January 2018)

  • Added Velocity report type
  • Added OrgChart report types
  • Allow individual jobs to use different smtp servers
  • Fix for jpivot reports not working
  • Save settings in the art database. Settings will need to be re-entered.
  • Fix for job parameter value being blank on edit
  • Preserve column order in JSON output (thanks to Tin Blaskovic)
  • Changed default connection pool library to hikaricp
  • Allow job email addresses to be separated by ,
  • Allow application logs to be written to a database
  • Added context path variable for freemarker and thymleaf output
  • Added useLowerCaseProperties option for template reports
  • Allow for testing of ftp, sftp, network share connections
  • Allow for email notification on application errors
  • Allow for specifying of password policy for internal authentication passwords
  • Allow jxls reports to use open and modify passwords
  • Enable generation of Jasper reports from MongoDB datasources (thanks to Tin Blaskovic)
  • Fix for reports within dashboards not using parameter values
  • Updated mariadb driver, poi, jxls, jclouds

ART 3.1 (2017-12-07)

  • Allow dynamic lov to use a dynamic datasource when the lov is a chained parameter
  • Fix for error with thymleaf email inline jobs
  • Allow localization of report name, short description, description
  • Allow localization of report output column names
  • Added csv zip report format
  • Allow outputting of fixed width reports as txt or zip file
  • Allow use of dynamic recipient details in email subject
  • Added CSV report type
  • Allow setting of password for xlsx, docx, ods, odt, pdf output
  • Fix for group column not being saved
  • Added ability to encrypt files in AES Crypt or OpenPGP format
  • Allow job fixed file name, email subject, email body to have date expressions
  • Allow parameter values to have groovy expressions
  • Allow jobs to have multiple schedules
  • Allow jobs to have holidays
  • Allow jobs to use shared schedules and shared holidays
  • Allow for clone reports, which use the source of another report
  • Allow reports to belong to multiple report groups
  • Allow publish job files to be copied to network shares, Amazon S3 storage, Microsoft Azure Blob storage or WebDAV servers
  • Allow display of images from database columns
  • Allow xdocreport to use queries defined in the template
  • Fix for oracle error when upgrading or adding records
  • Updated sqlite driver, jxls, univocity-parsers

ART 3.0.1 (2017-10-24)

  • Removed column autosizing for xls and xlsx output. Was causing greatly increased execution times for xlsx output.
  • Always use report datasource for dynamic lovs
  • For cached result job, don’t stop if create table process has an error
  • Don’t sort DataTable report format on initialization
  • Use select column filter for report group in reports page
  • When editing a job, update from email if owner email has changed
  • Don’t use email input type for user email field
  • Enable use of default report group
  • Added SFTP option
  • Fix for ftp not closing properly
  • Fix for fixed file name being deleted
  • Allow use of a single from email address for all jobs
  • Fix for error with ods output with null number values
  • Added option to omit title row for xls, xlsx, ods, slk output

ART 3.0 (2017-10-10)

  • Reorganised the code for easier maintenance and enhanced user experience
    – now using maven, spring mvc, bootstrap, among other libraries
  • Renamed “Report on Column” query types to “Group”
  • Renamed “Graph” query types to “Chart”
  • Renamed “Query” concept to “Report”
  • Renamed “View Modes” to “Report Formats”
  • Renamed “Number” parameter data type to “Double”
  • Renamed “Pivot Table” report types to “JPivot”
  • Modified application settings configuration. Settings need to be manually re-entered.
  • Modified application urls. Previously bookmarked urls may no longer work.
  • Added ability to create reports based on FreeMarker templates
  • Added ability to create reports based on Thymeleaf templates
  • Added ability to create reports based on MS Word (docx), LibreOffice Writer (odt) and MS PowerPoint (pptx) templates
  • Added docx, odt, ods report formats for tabular and jasper reports
  • Added syntax highlighting during report creation
  • Added tabbed dashboards option
  • Added Gridstack Dashboard report type
  • Added ReactPivot report type
  • Added PivotTable.js report types
  • Added Dygraphs report types
  • Added DataTables report types
  • Added C3.js report type
  • Added Chart.js report type
  • Added Datamaps report types
  • Added Leaflet report type
  • Added OpenLayers report type
  • Added Tabular Heatmap report type
  • Added ability to create csv output jobs
  • Added ability to create fixed width output jobs
  • Added ability to do OLAP analysis using saiku
  • Allow multi-value parameters with Oracle databases to have more than 1000 items
  • Added ability to output and schedule dashboard reports as pdf
  • Allow for specifying specific colours to be used for given chart series
  • Allow for localization of parameter labels and help text
  • Enable use of barcode4j barcodes in jasperreports
  • Allow to report from MongoDB databases
  • Enable use of groovy in sql source
  • Fix for context is readonly error on application startup
  • Requires Internet Explorer 8+, or recent versions of other browsers
  • Requires Java 7
  • Requires Servlet 3.0
  • Updated libraries, including jasperreports, quartz, jxls, among others
  • Changed license from GPLv2 to GPLv3

ART 2.5.4 (2016-12-29)

  • Added Lithuanian translation
  • Added Polish translation
  • Updated German translation
  • Minor css updates

ART 2.5.3 (2015-05-31)

  • Fix for incorrect handling of ” in parameter value
  • Fix for numbers not sorting correctly in Italian locale
  • Fix for error when using Conditional Email Output (Inline) jobs
  • Fix for null pointer exception when clob field (e.g. varchar(max)) is null
  • Fix for error when running a job that uses a jXLS spreadsheet query
  • Fix for IllegalArgumentException when using Tomcat 7.0.57+ or 8.0.15+
  • Included German translation (thanks to Carsten Pohle)

ART 2.5.2 (2013-05-31)

  • Fix for error when drill down column has a null value
  • Updated French translation (thanks to Eric Lemesre)
  • Minor html tag corrections (thanks to Eric Lemesre)
  • Left align text in htmlDataTable and htmlPlain view modes
  • Added DataTable translations for Spanish and Portuguese
  • Allow display of 0 for numbers when value is null
  • Allow chained parameter lov to use dynamic datasource filter
  • Left align first column text in crosstab queries

ART 2.5.1 (2013-04-07)

  • Added Portuguese translation (thanks to Edson Richter)
  • Added Spanish translation (thanks to Carlos Narvaez)
  • Updated French translation (thanks to Eric Lemesre)
  • Allow custom path for export files (thanks to ckb)
  • Enable display of blank space instead of “null” for null fields (thanks to ckb)
  • Fix for query name truncated to 25 characters
  • Fix for start query not displaying
  • Fix for invalid drill down queries link
  • Fix for not being able to define email jobs in Italian and Portuguese locales
  • Added some 2D charts
  • Allow use of jndi datasources
  • Allow rename and move of queries from the query management console
  • Allow xy chart to have multiple series
  • Have show results inline as an application setting
  • Enable show/hide of parameters box
  • Allow specification of random start time for jobs
  • Made graph x-axis label rotate and remove options configurable per query
  • Automatically compile all subreports in a jasper report
  • Added separate field for uploading subreports used by a jasper report
  • Updated jasperreports to 5.0.1

ART 2.5 (2013-01-18)

  • Fix for invalid publish job link on linux when reminder email specified
  • Support for running DDL/DML statements before query’s select statement
  • Support for displaying a query in the start page
  • Fix for non-ascii values not being saved properly in some admin pages (thanks to Edson Richter)
  • Renamed “Objects” to “Queries” and “Object Groups” to “Query Groups”
  • Support for case sensitive operators for dynamic queries
  • Allow use of decimals when specifying y axis range
  • Support for archiving publish job results
  • Removed published files retention period setting
  • Allow scheduling of heat maps
  • Allow use of default parameter values without specifying parameters in the url
  • Allow dashboards to use multi parameters
  • Moved some application settings from the web.xml file to the settings page