I have a xaf application which is used to analyse large amounts of data over 500,000 records. My client wants to use the new dashboard module to visualise the data. I have created a series of stored procedures on the server to reduce the query times, which works fine. The issue arises when we attempt to save the dashboard. After saving the dashboard an error is thrown see attached image.
a video of the error can be seen here: http://screencast-o-matic.com/watch/cbVq2tQHab
Steps to reproduce
- Create a new dashboard and select Database as the source type
- Specify Connection credentials
- Select Stored Procedure or use Query builder
- Design Dashboard
- Save Dashboard (at this point the connection string looks to be rewritten and throws the error)