I want to leverage the data model. I have an SQL statement that I want to use to provide data to a pie chart. The statement like this... select status, count(*) from concepts order by status One way is to create a view and drag that onto the model. Is there another way?
If you are using Model Driven Development, you can specify a JPQL query when you create a new query - not exactly a SQL, but does most of the work. Alternatively, you can always generate the Java assembler and modify the generated code to introduce your own query.