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)