How to create a query with attribute length > 0

ramakanthreddy_t · **Joined:** Thu Mar 05, 2009 2:50 am **Posts:** 14

I want to create a HQL Query which can take the Class Attribute Length > 0 condition. like given below how can i do it.

Query query = session.createQuery("from EmailQueue eq where eq.postingEmail.length()>0");
List list = query.list();
Iterator itr = list.iterator();
while(itr.hasNext()){
EmailQueue queue = (EmailQueue)itr.next();
System.out.println(queue.getCampaigns().getCampaignName()+":"+queue.getEmailSubject()+":"+queue.getPostingEmail());
}

nordborg · **Posted:** Thu Apr 02, 2009 2:13 am

Try this:

Code:

from EmailQueue eq where length(eq.postingEmail) > 0