You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@geode.apache.org by "Dharam Thacker (JIRA)" <ji...@apache.org> on 2017/12/01 10:17:00 UTC
[jira] [Updated] (GEODE-4040) Add support for if-Else/case-when
flow in OQL query
[ https://issues.apache.org/jira/browse/GEODE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dharam Thacker updated GEODE-4040:
----------------------------------
Summary: Add support for if-Else/case-when flow in OQL query (was: Add support for 'if/Else'/''case/when' flow in OQL query)
> Add support for if-Else/case-when flow in OQL query
> ---------------------------------------------------
>
> Key: GEODE-4040
> URL: https://issues.apache.org/jira/browse/GEODE-4040
> Project: Geode
> Issue Type: New Feature
> Components: querying
> Reporter: Dharam Thacker
>
> It's very handy and widely used feature where case..when,if/else kind of evaluations can be done directly using OQL
> In current situation one has to write function for all such cases which increases time to market as it needs deployment and approvals for large organizations.
> *+Example+*: [Just to provide glimpse of use case but not actual syntax]
> select c.clientId from /Client c where (if(c.isGoldenParty) then c.parentId;else c.clientId endif) as clientId
>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)