[ https://issues.apache.org/jira/browse/JDO-650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14256741#comment-14256741 ]
Andy Jefferson commented on JDO-650: ------------------------------------ SELECT FROM org.apache.jdo.tck.pc.company.FullTimeEmployee WHERE this.salary > (IF (this.department.name == 'Development') 15000 ELSE 25000) ORDER BY this.empid Anyone want to give me an idea what/where is "empid" ? "personid" I can see (in the root class) > Support for conditional operator ? : in JDOQL > --------------------------------------------- > > Key: JDO-650 > URL: https://issues.apache.org/jira/browse/JDO-650 > Project: JDO > Issue Type: New Feature > Components: specification, tck > Affects Versions: JDO 2 maintenance release 2 (2.2) > Reporter: Michael Bouschen > Assignee: Michael Bouschen > Fix For: JDO 3.1 > > > JDOQL should support the Java conditional operator ? :, e.g. salary >= 1000.0 > ? salary : salary * 1.1 > The conditional operator can be mapped to the CASE-expression in SQL: CASE > WHEN condition THEN thenExpr ELSE elseExpr END. Are there any issues with > non-SQL datastores when supporting the conditional operator? > Another question: which part of a JDOQL query can include a conditional > expression? I propose the query filter, the having clause and the result > specification. -- This message was sent by Atlassian JIRA (v6.3.4#6332)