$CASE or $SELECT Analog in Cache´SQL

Question

Question

Evgeny Shvarov · Sep 30, 2017

Hi, folks!

Is there any way to use $CASE or $SELECT functionality in SQL SELECT query?

E.g. something like this:

SELECT product, $CASE(status,"New":field1,"Payed":field2) as data from sales

To see either in data column either field1 or field2 values in regard of status value.

Discussion (3)1

Log in or sign up to continue

Robert Cemper · Sep 30, 2017

Evgeny,

in SQL you have a CASE ... END block for selection

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

CASE 
  WHEN search_condition THEN value_expression
  [ WHEN search_condition THEN value_expression ... ]
  [ ELSE value_expression ]
END

CASE value_expression
  WHEN value_expression THEN value_expression
  [ WHEN value_expression THEN value_expression ... ]
  [ ELSE value_expression ]
END

2 0

score 1 · Answer 1 · 2017-09-30T05:44:53-04:00

Lukas Dolezal · Sep 30, 2017

SELECT
CASE
  WHEN Field1 = 1 THEN 'ONE'
  WHEN Field1 = 2 THEN 'TWO'
  ELSE NULL
END
FROM MyTable

1 0

score 0 · Answer 2 · 2017-09-30T05:53:41-04:00

Evgeny Shvarov · Sep 30, 2017

Thanks Robert, Lukas, that is what I'm looking for.

0 0