OFBiz doesn't work like this, look for example usage of the EntityCondition class in the codebase. Ultimately you'll need to be doing a "greater than month start and less than month end" type of query.
Regards Scott HotWax Media http://www.hotwaxmedia.com On 15/04/2010, at 9:29 PM, Anurag Walia wrote: > > Thanks for valuable reply > > > but unable to find is coming fromDate because it should change into > from_Date by entitymodel > delegator.findByAndCache("EmplLeave", UtilMisc.toMap("month(fromDate)", > submitmonth,"year(fromDate)",submityear), null); > > > Regards > Anurag > > -- > View this message in context: > http://n4.nabble.com/How-can-i-create-sql-query-using-delegator-tp1858040p1873104.html > Sent from the OFBiz - User mailing list archive at Nabble.com.
smime.p7s
Description: S/MIME cryptographic signature