How to show joined tables query result in search container

[Hùng Trần, modifié il y a 6 années.]

Hello everyone,

I am using LF 7 EE, I am working with a complex query that join many tables and then show result in JSP search container, I searched for it by google but I haven't seen any helpful document, please give me any suggestion.

Thank you so much!

[ANKIT SRIVASTAVA, modifié il y a 6 années.]

You can use Custom SQL to join tables and then retrieve data using Finder classes.
Use *Finder from your service layer and call that from Search container:

http://learnliferaydxp.blogspot.in/2016/12/customsql.html

Thanks,
Ankit

[Hùng Trần, modifié il y a 6 années.]

Hi Ankit,

Thank for your answer, I have already got data by custom sql, but my problem is how can I display it by search container, because as I saw in some example, it only get data from 1 table with one model object, in my case it is many table with many model object.

Regards,

[ANKIT SRIVASTAVA, modifié il y a 6 années.]

Hope this post will help:

https://web.liferay.com/community/forums/-/message_boards/message/24940204

Thanks,
Ankit