Grails

Add Documentation for GORM Criteria Default Alias Generation

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Minor 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

Task - A task that needs to be done. GRAILS-7152 Document createAlias usage in GORM Criteria queries

  • Major - Major loss of function.
  • Open - The issue is open and ready for the assignee to start work on it.

Activity

No work has yet been logged on this issue.

People

  • Assignee:
    Peter Ledbrook
    Reporter:
    zyro
Vote (1)
Watch (2)

Dates

  • Created:
    Updated:
    Last Reviewed: