Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 1

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?

0 Replies

Avatar

Level 2

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