title: How to select partial fields from collection which is of one-to-many relation to the entity in JPQL
body: <p>The question is quite mouthful , it can be simply  described by the following query:</p>
  
  <pre><code>select c.name,c.brands FROM ShopChannels c 
  </code></pre>
  
  <p>ShopChannel is the basic entity which has a collection of  brands which is of on-to-many,instead select all the brand properties in this query ,I only want to select partial fields of Brand, if I use</p>
  
  <pre><code>select c.name,c.brands.spell from ShopChannels c
  </code></pre>
  
  <p>I'll get a "cannot navigate collection valued association field " error message.</p>
  
  <p>This kind of query can greatly boost performance, so anyone has an idea?</p>