[
https://issues.apache.org/jira/browse/ISIS-698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13902434#comment-13902434
]
ASF subversion and git services commented on ISIS-698:
------------------------------------------------------
Commit ee3b0f7369c6c6759f10121aea9f1eff8f110b53 in isis's branch
refs/heads/master from [~danhaywood]
[ https://git-wip-us.apache.org/repos/asf?p=isis.git;h=ee3b0f7 ]
ISIS-698: support scalar values in SELECT clause of JDOQL
eg "SELECT startDate FROM ..."
> Allow JDOQL to be able to select scalars (eg project individual field(s))
> rather than entire entities.
> ------------------------------------------------------------------------------------------------------
>
> Key: ISIS-698
> URL: https://issues.apache.org/jira/browse/ISIS-698
> Project: Isis
> Issue Type: Improvement
> Components: Objectstore: JDO
> Affects Versions: objectstore-jdo-1.3.0
> Reporter: Dan Haywood
> Assignee: Dan Haywood
> Priority: Minor
> Fix For: objectstore-jdo-1.4.0
>
>
> a typical (currently supported) query is:
> @javax.jdo.annotations.Query(
> name = "findByPropertyAndType", language = "JDOQL",
> value = "SELECT "
> + "FROM org.estatio.dom.lease.LeaseTerm "
> + "WHERE leaseItem.type == :leaseItemType "
> + " && leaseItem.lease.occupancies.contains(lu) "
> + " && (lu.unit.property == :property) "
> + "VARIABLES org.estatio.dom.lease.Occupancy lu"),
> this ticket is to support queries of the form (note the "SELECT startDate"):
> @javax.jdo.annotations.Query(
> name = "findStartDatesByPropertyAndType", language = "JDOQL",
> value = "SELECT startDate "
> + "FROM org.estatio.dom.lease.LeaseTerm "
> + "WHERE leaseItem.type == :leaseItemType "
> + " && leaseItem.lease.occupancies.contains(lu) "
> + " && (lu.unit.property == :property) "
> + "VARIABLES org.estatio.dom.lease.Occupancy lu")
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
