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.
Continue Reading...

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:-
Continue Reading...

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:-

Continue Reading...

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.
Continue Reading...

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.
Continue Reading...

Total Pageviews

Number Of Unique Visitor

Free counters!