coalesce « Data Type « JPA Q&A

1. equivalent of hql coalesce in linq-to-nhibernate    stackoverflow.com

Supposing I have the following hql:

select cast(coalesce(sum(c.Valoare), 0) as decimal)
      from Comision as c
      where c.User = :user

2. JPQL Coalesce non-scalars?    stackoverflow.com

I have a table storing application configuration parameters like so:

 setName | key        | value
----------------------------------
 dev     | FooEnabled | true
 ...

3. Help me with coalesce please!!!    forum.hibernate.org

I am doing a query with hql and i do not achieve that it works. it flaw join and coalesce. if I do the query without join, it me does not work coalesce. @NamedQuery(name = "Stock.findByClientAndReference", query = "select distinct NEW com.fcclogistica.services.legacy.sga.entities.Stock(s.id, (select r.description from Reference r where r.id = s.id), s.situation, s.status, (select sum(ss.amount) - coalesce ((select sum(al.amount) from StockCapture ...

4. coalesce    forum.hibernate.org

Thank you, burroinquieto. It's possible? SELECT Reference, Sum( JusUnv ) - coalesce(( Select Sum( E91Uni ) From StockCapture Where e91ref = jusref ), 0 ) - coalesce(( Select Sum( LalCan ) From LineDeliveryNote join HeadDeliveryNote on CalCli = LalCli and CalPed = LalPed Where LalRef = jusref and CalSit = ' ' ), 0 ) FROM Stock WHERE JUSSIT = ' ...

5. COALESCE FUNCTION    forum.hibernate.org

COALESCE((SELECT SUM(secondVO.imp) FROM secondObjVO AS secondVO WHERE secondVO.key.cod = firstVO.key.cod), 0) ]]> ...

6. NVL or COALESCE    forum.hibernate.org

7. COALESCE    forum.hibernate.org

8. Grammar/HQL coalesce question    forum.hibernate.org

9. COALESCE in Hibernate2    forum.hibernate.org