This post will show examples on how to use Grails HQL Update operations on a database. Using Grails HQL for bulk update operations is very efficient because a task can be completed in one go.
This post will show how to use the
aggregate function inside Grails/GORM HQL statements. Just like in SQL,
statements returns the number of rows that matches a specified criteria.
This post will show how to perform HQL Joins with one to many relationships and other cases. Joins are important when you need to check two or more tables to retrieve the required information
This will show how to use a Grails domain's createCriteria method to search for records in the database using the criteria API.
This will show how to use a Grails domain's executeQuery method to search for records in the database using HQL.
This will show how to use a Grails domain's executeUpdate method to update or delete records using HQL.
Maps are very useful when coding in Groovy. This tutorial will show the different ways of using a Groovy Map.
This will show how to use a Grails domain's count and countBy methods.
This Grails tutorial will teach the basics of using HQL. Grails supports dynamic finders which makes it convenient to perform simple database queries. But for more complex cases, Grails provides both Criteria API and HQL. This tutorial will focus on the latter.
This tutorial will show how to use Criteria API to search data from the database. Criteria is a powerful API and an elegant alternative to HQL.