[jira] [Updated] (GEODE-4040) Add support for if-Else/case-when flow in OQL query

["Dharam Thacker (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GEODE-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dharam Thacker updated GEODE-4040:
----------------------------------
    Description: 
We would like to see support for conditional flow within OQL using *where case..when*,*if/else* pattern.

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 (if(c.isGoldenParty) then c.parentId;else c.clientId endif) as clientId from /Client c

  was:
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 (if(c.isGoldenParty) then c.parentId;else c.clientId endif) as clientId from /Client c  

 


> 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
>            Priority: Major
>
> We would like to see support for conditional flow within OQL using *where case..when*,*if/else* pattern.
> 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 (if(c.isGoldenParty) then c.parentId;else c.clientId endif) as clientId from /Client c



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)