0 Replies Latest reply on Jan 7, 2003 12:12 PM by Zaphod Beeblebrox

    CMR and "custom selects"

    Zaphod Beeblebrox Newbie

      Hi Folks,

      Is there a way to create a custom select that exploits CMR? In otherwords, if we have two tables such that:

      Company has Employees (1:M)

      CMR obviously allows implementation of -->
      company.getEmployees()

      Can CMR also allow implementation of -->
      company.getEmployeesWithMinSal(100000)

      Put another way, can I use xml/ejbql in conjunction with CMR to select all the employees that make >$100K at a company whose local entity object I currently have?

      Hopefully,
      whecks