Grails

Document createAlias usage in GORM Criteria queries

Details

  • Type: Task Task
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 2.0-RC1
  • Fix Version/s: None
  • Component/s: Documentation
  • Labels:
    None

Description

Grails reference documentation doesn't contain any documentation for "createAlias".

Rob has written a nice blog article which explains the usage for querying hasMany associations.
http://adhockery.blogspot.com/2009/06/querying-by-association-redux.html

I hope this information could be added to Grails manual.

createAlias is mentioned in these Jira issues:
http://jira.codehaus.org/secure/IssueNavigator.jspa?reset=true&jqlQuery=project+%3D+GRAILS+AND+(summary+~+createAlias+OR+description+~+createAlias+OR+comment+~+createAlias)

There seems to be several use cases where createAlias should be used.

Issue Links

relates to

Bug - A problem which impairs or prevents the functions of the product. GRAILS-7087 hasMany cached association does not return all instances if following a specific criteria Query

  • Blocker - Blocks development and/or testing work, production could not run.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Improvement - An improvement or enhancement to an existing feature or task. GRAILS-6971 Add Documentation for GORM Criteria Default Alias Generation

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Open - The issue is open and ready for the assignee to start work on it.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Lari Hotari added a comment -

Another blog article: http://www.intelligrape.com/blog/2011/01/17/grails-criteria-query-createalias-made-it-easy/

Show
Lari Hotari added a comment - Another blog article: http://www.intelligrape.com/blog/2011/01/17/grails-criteria-query-createalias-made-it-easy/
Hide
Permalink
Peter Ledbrook added a comment -

We can document createAlias, but since Graeme has changed the default for nested associations to INNER_JOIN, I don't think we should mention it as the solution to the problem described in Rob's post.

Show
Peter Ledbrook added a comment - We can document createAlias, but since Graeme has changed the default for nested associations to INNER_JOIN , I don't think we should mention it as the solution to the problem described in Rob's post.

People

  • Assignee:
    Peter Ledbrook
    Reporter:
    Lari Hotari
Vote (4)
Watch (2)

Dates

  • Created:
    Updated:
    Last Reviewed: