Today we will discuss about Joins in Dynamic Query . Before reading this blog it is highly recommended to read my previous blog on introduction of dynamic query , how to use AND/OR in dynamic query and Projection in dynamic query. In this blog i am using my own custom tables states and countries. The primary key of countries ie countryId is used as foreign key in states table.
Saturday, February 27, 2016
Joins using Dynamic Query in Liferay
Today we will discuss about Joins in Dynamic Query . Before reading this blog it is highly recommended to read my previous blog on introduction of dynamic query , how to use AND/OR in dynamic query and Projection in dynamic query. In this blog i am using my own custom tables states and countries. The primary key of countries ie countryId is used as foreign key in states table.
Conjunction(AND) vs Disjunction(OR) Clause using Dynamic Query in Liferay
Today we will discuss about Conjunction ie AND and Disjunction ie OR Clause in Dynamic Query . Before reading this blog it is highly recommended to read my previous blog on introduction of dynamic query.
For each operation we have two ways. So lets start with the example:-
Order By Clause using Dynamic Query in Liferay
Today we will discuss about Order By Clause in Dynamic Query . Before reading this blog it is highly recommended to read my previous blog on introduction of dynamic query.
Lets start with example:-
Friday, February 26, 2016
Projection in Dynamic Query
Today we will discuss about Projection in Dynamic Query .Before reading this blog it is highly recommended to read my previous blog on introduction of dynamic query. We know how to fetch a complete object but what if we want only one column like only userId of User for this we use Projections.
Dynamic Query in Liferay
Today we will discuss about Dynamic Query in Liferay. As we already know Liferay Service Builder provide basic CRUD methods but sometimes we need specific methods with different conditions . For this we have two approaches:-
1)Custom Sql in Liferay.
2)Dynamic Query
The problem with custom query is that we need to build services again and again. But in case of dynamic queries no need to build services.
Subscribe to:
Posts (Atom)
Number Of Unique Visitor
