deletebyquery.md

deleteByQuery

Delete by using an HQL query and iterating via the results. It is not performing a delete query but is a select query that should retrieve objects to remove

Returns

• This function returns void

Arguments

Key	Type	Required	Default	description
query	string	Yes	---
params	any	No	---
max	numeric	No	0
offfset	numeric	No	0
flush	boolean	No	false
transactional	boolean	No	From Property	Use transactions or not
datasource	string	false		The datasource to use or use the default datasource

Examples

// delete all blog posts
ormService.deleteByQuery("from Post");
// delete query with positional parameters
ormService.deleteByQuery("from Post as b where b.author=? and b.isActive = :active",['Luis Majano',false]);

// Use query options
var query = "from User as u where u.isActive=false order by u.creationDate desc"; 
// first 20 stale inactive users 
ormService.deleteByQuery(query=query,max=20); 
// 20 posts starting from my 15th entry
ormService.deleteByQuery(query=query,max=20,offset=15,flush=true);

// examples with named parameters
ormService.deleteByQuery("from Post as p where p.author=:author", {author='Luis Majano'})