[OFBiz] Users - Entity Engine Group By in View Entity Question...

[David E. Jones]

Yes, you can set group-by to true on multiple field aliases, in fact in 
most cases with SQL style grouping you MUST do this.

As far as group, sub-group, etc go, I wasn't aware you could do 
anything like that in SQL. What would it look like?

For the literal value, I think it is possible with some of Adam Heath's 
recent extensions.

-David


On Aug 11, 2004, at 9:16 AM, Porter Woodward wrote:

> Hi there -
>  
> is it possible to use group-by on more than one column (field) of a 
> view entity?  It's pretty easy to construct SQL by hand to do this 
> sort of query, but it doesn't seem possible in the XML definition for 
> the view-entity, declaring group-by=true on more than a single field 
> seems to have no effect.
>  
> It might make sense to allow for a <group-by> tag, as opposed to 
> per-field attribute - thus allowing one to specify multiple fields to 
> group-by and in which order (group, sub-group, sub-sub-group, etc).
>  
> Another question came up as well - is it possible to specify a literal 
> value for matching in the join criteria of a view? 
>   
> - Porter Woodward
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2363 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/users/attachments/20040811/8de1935d/smime.bin