geode-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dharam Thacker (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (GEODE-4040) Add support for 'if/Else'/''case/when' flow in OQL query
Date Fri, 01 Dec 2017 10:16:00 GMT

     [ 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)

Mime
View raw message