aa.. there is one thing I forgot to mention.. i try to display this query in
ftl. so i put this line on top of the ftl file:
<#assign salesLevelsList = delegator.findByLike("SalesLevel",
Static["org.ofbiz.base.util.UtilMisc"].toMap("lob","A","channelCode","1",
"incentive","Y", "salesLevelId","%LC"),
Static["org.ofbiz.base.util.UtilMisc"].toList("salesLevelId","name"))>
and it doesn't work...note: the sales level id's i want to select is AL_ELC and AL_LC nashrul wrote: > > Can we use method in GenericDelegator that does query using both 'and' and > like operator... > I have a table Sales_Level which contains fields SALES_LEVEL_ID, NAME, > DESCRIPTION, LOB, CHANNEL_CODE, and INCENTIVE. i want to select sales > level with lob=A, channelCode=1, incentive=Y, and salesLevelId like LC. > -- View this message in context: http://www.nabble.com/query-combining-and-and-like-tf4278148.html#a12177438 Sent from the OFBiz - User mailing list archive at Nabble.com.
