title: Grails additional columns in table or list
body: <p>I'm trying for several days to receive a list from my Data. The Domain looks like this:</p>
  
  <pre><code>class Alpha {    
      String a
      String b
      etc.
      static hasMany = [beta:Beta]
  
  }
  
  class Beta {
      String a
      Integer foo
      String status
      static belongsTo = [alpha:Alpha]
      static constraints = {
          status(nullable:false, inList:["val1","val2","val3", "val4"])
      }
  }
  </code></pre>
  
  <p>I'd like to have in Alpha the sum of all Beta.foo and of all Beta.foo in a certain status. Best would be something like an additional row ( <code>Integer sumVal1 ...</code> ). </p>
  
  <p>I tried named queries:</p>
  
  <pre><code>static namedQueries = {
          erledigterProbeAufwend {
              createAlias ('Beta', 'b')
              eq ('b.status', 'val1')
              projections {
                  groupProperty('b.alpha')
                  sum('b.foo', 'sumFooVal1')
              }
          }
  }
  </code></pre>
  
  <p>But this just give me one sum at a time. </p>
  
  <p>I'm looking forward to get some help on that.</p>
  
  <p>Greetings
  Bas</p>