Tms Aurelius / XData / Webcore with oracle

[Araujo_Adan]

I require search Entity Product (a simple entity Id and Title), with Aurelius,
Without accent, any postition of word, case insentive, my database is oracle,

My simple query is

SELECT *
FROM Product
WHERE REGEXP_LIKE(
TRANSLATE(UPPER(Title), 'ÁÉÍÓÚÜÑáéíóúüñ', 'AEIOUUÑAEIOUUÑ'),
TRANSLATE(UPPER('agua'), 'ÁÉÍÓÚÜÑáéíóúüñ', 'AEIOUUÑAEIOUUÑ')
);

i think create Service in XData, callig from Webcore.

Do you have some sample or tips?

[wlandgraf (Wagner Landgraf)]

For such specific query in deed you will have to use a service operation and use Sql expressions to build the condition.

[Araujo_Adan]

Solved. Thank you.