#data

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?

I have two global variables that i want to set in my process, the only way I found to do that is with parameters but I couldn't find how to edit these data ( my admin must be able to edit them from an application page)

I looked into process variables but the data is deleted after the process instance ends

Any ideas on how i can create global variables that can be edited from the UI and doesn't get deleted ?

I have prepared a form using the process variable. Now I have to attach a file from the user, This File must be uploaded on the database and another user will download it from another form. So how to upload files to the database and call them for downloading