Following are the steps to implement Custom SQL

Following are the steps to implement Custom SQL

1. Create Simple Liferay MVC Portlet
2. Define entity in service.xml
3. Run the Service Builder
4. Create SQL queries configuration XML file (Custom SQL XML file)
5. Write Native SQL in Custom SQL xml file
6. Create Finder Implementation class
7. Run the Service Builder
8. Implement Required Custom SQL Method in Finder Implementation Java Class
9. Run the Service Builder
10. Write Custom Service Method in respective Local Service Implementation Class
11. Run the Service Builder
12. Use Respective Local Service Util class to call service method