How to retrieve attribute from custom query

Submitted by Kawmar on Thu, 10/27/2022 - 14:51

I created a custom query in BDM queries, it selects the last item in the Param table:

SELECT MAX(p) FROM Param p
ORDER BY p.persistenceId DESC

I'm trying to use this query in a process variable to retrieve the attribute Price, I tried two ways:

parametreDAO.findLastSeuil().price

parametreDAO.findLastSeuil().getPrice()

But I got this error:

org.hibernate.exception.SQLGrammarException: could not extract ResultSet Any idea how to do that?

1 answer

Submitted by Kawmar on Thu, 10/27/2022 - 15:23

It worked using the find query like this:

parametreDAO.find(parametreDAO.countForFind()-1, 1).get(0).price