Let me check that quickly. We are using Java classes to generate these queries. I need to check more on HQL query. Give me some time and will get back to you.