Alex Rivera | Logout

Grails query not using GORM

Asked 2011-01-05T04:04:46.997
14

What is the best way to query for something without using GORM in grails?

I have query that doesn't seem to fit in the GORM model, the query has a subquery and a computed field. I posted on stackoverflow already with no response so I decided to take a different approach. I want to query for something not using GORM within a grails application. Is there an easy way to get the connection and go through the result set?

grails groovy grails-orm
Edit
Report

1 Answer

-1

In the moste cases I use criteria queries.

def c = Account.createCriteria()
def results = c {
    between("balance", 500, 1000)
    eq("branch", "London")
    or {
        like("holderFirstName", "Fred%")
        like("holderFirstName", "Barney%")
    }
    maxResults(10)
    order("holderLastName", "desc")
}
answered 2011-01-05T12:18:56.750

Your Answer