Service Builder / How to define queries

[Michel Wicky, modificado 13 Anos atrás.]

I'm developping a little application which has to select many data but only perist/merge only one. I would like to know if it is a way to declare entities that are queries (read only) instead of declaring all tables as entities.

Thank You

[Mika Koivisto, modificado 13 Anos atrás.]

ServiceBuilder does not really support views but you could declare an entity without any columns and then make your queries from the service impl.

[Michel Wicky, modificado 13 Anos atrás.]

Thank you Mika for answering. Do you know any tutorials or examples to achieve this ?

[Mika Koivisto, modificado 13 Anos atrás.]

I'm pretty sure there was a blog post about it by Raymond Auge but I can't find it now.

[Michel Wicky, modificado 13 Anos atrás.]

Found some old article about custom-sql but none using service.xml as a base to build read only data services. Didn't found anything in Liferay in Action too. There are some services that are read only but not defined like so at the peristance level.