Add Documentation for GORM Criteria Default Alias Generation

Details

Type: Improvement
Status: Open
Priority: Minor
Resolution: Unresolved
Affects Version/s: 1.3.5
Fix Version/s: None
Component/s: Documentation
Labels:
None

Description

given a case like this

Building.withCriteria {
    jobs { tasks {} }
    projections {
        groupProperty "name"
        groupProperty "id"
        sum "tasks_alias2.cost"
        sum "tasks_alias2.duration"
    }
}

it comes very handy to know that

grails criteria defaults to a left join on associations and
creates the aliases with names like associationPropertyName + "_alias" + "aliasNumber" where aliasNumber is starting with 1 and is incremented in the order the HibernateCriteriaBuilder builds the criteria...

Issue Links

is related to

GRAILS-7152 Document createAlias usage in GORM Criteria queries

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Peter Ledbrook added a comment - 07/Dec/10 6:16 AM

We definitely need a better way of doing this The aliases are obviously not designed to be used directly by developers, but I guess that should be a separate issue.

Show

Peter Ledbrook added a comment - 07/Dec/10 6:16 AM We definitely need a better way of doing this The aliases are obviously not designed to be used directly by developers, but I guess that should be a separate issue.

Peter Ledbrook made changes - 07/Dec/10 6:21 AM