How can I make a dynamic Grails search? -
consider domain class:
class house { integer room integer bathroom date builtdate date boughtdate string roadname string getsearch(){ return room + " " + bathroom + " " + builtdate + " " + boughtdate } }
i imagine having several fields search mechanism: search room, bathroom, builtdate, boughtdate.
the user should able search combination of these paramaters. can use one, or of them. need controller code. i'm sure cannot using hql dynamic finders i'll have use sqls statments.
any help/hint appreciated.
you want use hibernate criteria. along lines of:
if (room && bathroom && builtdate && boughtdate) { house.withcriteria { if (room) { gte 'room', room } // ... } }
look @ docs on createcriteria , withcriteria more information.
Comments
Post a Comment