What is the best way to get results of an SQL statement

[Former Community Member]

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?

[Former Community Member]

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.

Anil