How to resolve activobject table name to make an sql query containing MAX function via findWithSql

[Ayoub Bhija]

I am working on a jira plugin and i have a problem.

I am trying to make an sql query with MAX(FIELD) and SUM() but the problem is that i tried to use them with find method which takes Query Object but the sql functions are ignored. So I tried with findWithSql but the problem is that i don't understand how i can resolve the activeObject Table name at runtime. Because the activeObjects prefixes are generated automatically.

Example :

Select NAME, SUM(TOTAL) as TOTAL order by NAME;