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:16: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:
----------------------------------
Description:
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
was:
It's very handy and common 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
> 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)