count

Return the count of instances in the DB for the given entity name. You can also pass an optional where statement that can filter the count. Ex: count('User','age > 40 AND name="joe"'). You can even use named or positional parameters with this method: Ex: count('User','age > ? AND name = ?',[40,"joe"])
Returns
This function returns numeric
Arguments
Key
Type
Required
Default
Description
entityName
string
Yes
---
​
where
string
No
​
​
params
any
No
strucnew()
Named or positional parameters
Examples
// Get the count of instances for all books
ormService.count("Book");
// Get the count for users with age above 40 and named Bob
ormService.count("User","age > 40 AND name='Bob'");
// Get the count for users with passed in positional parameters
ormService.count("User","age > ? AND name=?",[40,'Bob']);
// Get the count for users with passed in named parameters
ormService.count("Post","title like :title and year = :year",{title="coldbox",year="2007"});

Counters

countWhere

Last modified 6mo ago

Key	Type	Required	Default	Description
entityName	string	Yes	---
where	string	No
params	any	No	strucnew()	Named or positional parameters