Uploaded image for project: 'Isis'
  1. Isis
  2. ISIS-698

Allow JDOQL to be able to select scalars (eg project individual field(s)) rather than entire entities.

    Details

      Description

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

        Attachments

          Activity

            People

            • Assignee:
              danhaywood Dan Haywood
              Reporter:
              danhaywood Dan Haywood
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: