newCriteria

Get a brand new criteria builder object to do criteria queries with (See ORM:CriteriaBuilder)

Returns

  • This function returns coldbox.system.orm.hibernate.CriteriaBuilder

Arguments

Key

Type

Required

Default

Description

entityName

string

true

---

The entity name to bind the criteria query to

useQueryCaching

boolean

false

false

Do automatic query caching for queries

queryCacheRegion

string

false

criterias.{entityName}

The queryCacheRegion name property for all queries in this criteria object

datasource

string

false

‚Äč

The datasource to use or default it to the application or entity in use

Examples

var users = ORMService.newCriteria( entityName="User" )
.gt( "age", ormService.idCast( 30 ) )
.isTrue( "isActive" )
.list( max=30, offset=10, sortOrder="lname" );