I want to represent the following SQL query in HQL.
select time_dim_id, (select count(*) from ut_users user2 where user2.user_created_time_dim_id <= time.time_dim_id ) as TotalUsers from ut_users user1, ut_time_dim time where time.time_dim_id = user1.user_created_time_dim_id group by time_dim_id order by time_dim_id
Is this possible? I get the following error when I run the query:
Exception: net.sf.hibernate.QueryException: aggregate function expected before ( in SELECT [select time.id, (select count(*) from UTUserDim user2 where user2.userCreationTimeId = time.id) as TotalUsers from com.plumtree.usagetracker.persist.UTUser user1, com.plumtree.usagetracker.persist.UTTimeDim time where user1.userCreationTimeId = time.id group by time.id order by time.id ]
Also, if you know of any work-arounds, that would be great. I am looking to get a running total of users. My report looks like this: