Case When syntax on querybuilder

Questions and answers regarding general SQL and backend databases

Case When syntax on querybuilder

Postby logicimpresa » Fri Jun 17, 2016 12:21 pm

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

Code: Select all
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
Gianluca Zanini
Logic Impresa - Italy
SAN Partner
Best BAP development 2014
Eager Beaver 2013
Servoy Valued Professional 2012
User avatar
logicimpresa
 
Posts: 65
Joined: Sun May 01, 2011 3:58 pm
Location: Bernate Ticino (MI) - Italy

Re: Case When syntax on querybuilder

Postby pbakker » Fri Jun 17, 2016 2:11 pm

case/when was added in Servoy 8

Paul
pbakker
 
Posts: 2821
Joined: Wed Oct 01, 2003 8:12 pm
Location: Amsterdam, the Netherlands

Re: Case When syntax on querybuilder

Postby logicimpresa » Fri Jun 17, 2016 8:45 pm

Thanks Paul: i didn't notice that. ;)
Gianluca Zanini
Logic Impresa - Italy
SAN Partner
Best BAP development 2014
Eager Beaver 2013
Servoy Valued Professional 2012
User avatar
logicimpresa
 
Posts: 65
Joined: Sun May 01, 2011 3:58 pm
Location: Bernate Ticino (MI) - Italy

Re: Case When syntax on querybuilder

Postby logicimpresa » Fri Jun 17, 2016 8:57 pm

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
Gianluca Zanini
Logic Impresa - Italy
SAN Partner
Best BAP development 2014
Eager Beaver 2013
Servoy Valued Professional 2012
User avatar
logicimpresa
 
Posts: 65
Joined: Sun May 01, 2011 3:58 pm
Location: Bernate Ticino (MI) - Italy

Re: Case When syntax on querybuilder

Postby pbakker » Sat Jun 18, 2016 10:54 am

Seems like it hasn't made it in yet, although it seems scheduled for 8.1: https://support.servoy.com/browse/SVY-3358
pbakker
 
Posts: 2821
Joined: Wed Oct 01, 2003 8:12 pm
Location: Amsterdam, the Netherlands

Re: Case When syntax on querybuilder

Postby logicimpresa » Sun Jun 19, 2016 3:44 pm

Ok: thanks a lot Paul
Gianluca Zanini
Logic Impresa - Italy
SAN Partner
Best BAP development 2014
Eager Beaver 2013
Servoy Valued Professional 2012
User avatar
logicimpresa
 
Posts: 65
Joined: Sun May 01, 2011 3:58 pm
Location: Bernate Ticino (MI) - Italy


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 3 guests