[jboss-user] [JBoss Seam] - Re: EntityQuery Restrictions

[pete.muir@jboss.org]

Try 

public class StatusList extends EntityQuery {
  | 
  | 	private static final String[] RESTRICTIONS = {"lower(status.description) like concat('%', concat(lower(#{statusList.status.description}),'%'))",};
  | ...
  | 	private Status status = new Status();
  | 
  | 	@Override
  | 	public String getEjbql() {
  | 		return "select status from Status status";
  | 	}
  | 
  |         @Override
  |         public String getOrder() {
  |                 return "status.sortOrder";
  |         }
  | ...	

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4098522#4098522

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4098522