Grails

size evaluation of non-collection properties is missing

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.1.1
  • Fix Version/s: 1.2-RC1
  • Component/s: Persistence
  • Labels:
    None
  • Environment:
    all

Description

The CriteriaBuilder API is missing the methods to evaluate a size of a non-collection property, or a hook to sqlRestriction to enable smth like:

sqlRestriction 'char_length( aField ) >= 444'

Issue Links

relates to

New Feature - A new feature of the product, which has yet to be developed. GRAILS-9402 sqlProjection is not supported

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Jeff Brown added a comment -

Support for expressing sql restrictions has been added. The following should work now...

def results = Person.withCriteria {
    sqlRestriction "char_length( first_name ) <= 4"
}

Note that "first_name" refers to a column in the database, not necessarily the name of a domain property. This is SQL.

Show
Jeff Brown added a comment - Support for expressing sql restrictions has been added. The following should work now... def results = Person.withCriteria { sqlRestriction "char_length( first_name ) <= 4" } Note that "first_name" refers to a column in the database, not necessarily the name of a domain property. This is SQL.
Hide
Permalink
Jeff Brown added a comment -

See http://github.com/grails/grails/commit/3034022eeb95e3f2b88627ae97e1f63236923703 and http://github.com/grails/grails/commit/479deecce238bc65975c62554be2bd27c5ede59b

Show
Jeff Brown added a comment - See http://github.com/grails/grails/commit/3034022eeb95e3f2b88627ae97e1f63236923703 and http://github.com/grails/grails/commit/479deecce238bc65975c62554be2bd27c5ede59b

People

  • Assignee:
    Jeff Brown
    Reporter:
    Konstantyn Smirnov
Vote (2)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: