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.

Lets start with example:-

1)Select query for One column
Here we write a query that will return only userId:-





2)Select query for Two columns
Here we write a query that will return only userId and firstname:-

3)Select query for Aggregate functions
Projection is also used for aggregate function like SUM, MAX, COUNT, AVG etc. Aggregate function always return single value.



Hope this will Help....

Related Post:-

Joins using Dynamic Query in Liferay

AND/OR Clause using Dynamic Query in Liferay

Order By Clause using Dynamic Query in Liferay

Introduction to Dynamic Query

Creating Services using Maven

Liferay Message Customization

Jasper Report with Eclipse

Validation in Liferay