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?