Uploaded image for project: 'Causeway'
  1. Causeway
  2. CAUSEWAY-698

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • objectstore-jdo-1.3.0
    • objectstore-jdo-1.4.0
    • Persistence JDO
    • None

    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

            danhaywood Daniel Keir Haywood
            danhaywood Daniel Keir Haywood
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: