The CASE statement should fit where a column does in an OQL query. If your basic query looks like this:
SELECT Name
FROM ModuleName.Person
The output from this might look like:
If you replaced your selection of the Name attribute with a CASE statement, it would look like this:
SELECT CASE Name WHEN 'John' THEN 1 ELSE 0
FROM ModuleName.Person
The output from this query would look like:
Hope that helps!
Ok I understand the syntax.
Thank you, it helps a lot !