Creating custom SQL queries
If you're a keen observer, you'll have noticed that the subject of custom SQL queries has popped up in a couple of areas. SQL is an option for specifying the source used in document template fragments, charts, and custom queries. While the subject of SQL is well outside the scope of this book, for those advanced users who are familiar with SQL, we wanted to make you aware of the capability and provide you with some of the resources you'll need to work with it in Sparx.
In a nutshell, a custom SQL query allows us to provide the data expected for charts and template fragments by executing a SQL SELECT statement against the internal tables of the Sparx repository. The SQL statement must return each of the fields expected by the template fragment or chart. This is ideal for situations where the data we're looking for is not neatly contained within a single package or element type. You can learn more about using custom SQL queries in a...
