1

SQL QUERY: 

SELECT SUM(IF(table.type='type1', 1, 0)) as type1,SUM(IF(table.type='type2', 1, 0)) as type2 from table;

How to write same query in criteria builder like below:

CriteriaBuilder builder = entityManager.getCriteriaBuilder();
CriteriaQuery<Object[]> criteria = builder.createQuery( Object[].class );
Root<Table> root = criteria.from( Table.class );
criteria.multiselect(builder.sum())

I am unable to place if condition in criteria builder.

Note: there is bean class for Table. Thanks in advance.

snieguu
  • 2,073
  • 2
  • 20
  • 39
Ajaykumar Manimala
  • 23
  • 1
  • 6

1 Answers1

0

Apparently hibernate criteria does not support IF. I would consider just making 2 queries with criteria or using HQL or just native SQL.

jspurim
  • 925
  • 8
  • 25