Hi, i have a hibernate implementation of my searchDao, before this dao was implemented using Ibatis SQLMap. My problem is that the searchByKeywords method of searchDao receive a string separated by ";". Each token in this string is a value for the where clause. I dont know how many token contain the string and i need to filter my search with this values. With Ibatis i use this on the mapping file:
<select id="searchClienteList" resultMap="result">
select * from devweb_cliente_byagr(-1,#usuarioId#)
<dynamic prepend="where">
<iterate property="keywordList" open="(" close=")" conjunction="OR">
upper(nombre_comercial) like #keywordList[]#
</iterate>
</dynamic>
order by cliente
</select>
Some hints?.
Thank in advanced
Danny
|