Case When syntax on querybuilder

Classic Servoy
1

Hi to all,
It’s possible to use this SQL syntax with query builder?

sum(case when class_xxx = 'XXX' and rif_xxx is null then 1 else 0 end) as tot_xxx

I use Servoy version 6.1.4: shortly migrate to Servoy version 8.0.4

Thanks

2

case/when was added in Servoy 8

Paul

3

Thanks Paul: i didn’t notice that. ;)

4

Sorry Paul: i didn’t find on wiki how to use case/when. I see https://wiki.servoy.com/display/public/DOCS/QBResult but i couldn’t find anything about it. Where can i find the relative documentations?
Thanks a lot

5

Seems like it hasn’t made it in yet, although it seems scheduled for 8.1: https://support.servoy.com/browse/SVY-3358

6

Ok: thanks a lot Paul