Skip to content

Latest commit

 

History

History
39 lines (29 loc) · 1.43 KB

method-expressions.md

File metadata and controls

39 lines (29 loc) · 1.43 KB
Raw

Method Expressions

A method expression is made up of the prefixes: findBy, findAllBy, countBy followed by the expression that combines a query upon one or more properties:

User.findBy{property}[Conditional=equal][Operator]?{property}[Conditional][Operator]
User.findAllBy{property}[Conditional=equal][Operator]?{property}[Conditional][Operator]
User.countBy{property}[Conditional=equal][Operator]?{property}[Conditional][Operator]

If a conditional keyword is not passed, we assume you want equality. Remember that!

{% hint style="danger" %} IMPORTANT: The ? means that you can concatenate the same pattern over and over again. {% endhint %}

Conditionals

The available conditionals in ColdBox are:

  • LessThanEquals - Less than or equal to passed value
  • LessThan - Less than to passed value
  • GreaterThanEquals - Greater than or equal to passed value
  • GreaterThan - Greater than to passed value
  • Like - Equivalent to the SQL like expression
  • NotEqual - Not equal to the passed value
  • isNull - The property must be null
  • isNotNull - The property must not be null
  • NotBetween - The property value must not be between two values
  • Between - The property value must be between two values
  • NotInList - The property value must not be in the passed in simple list or array
  • inList - The property value must be in the passed in simple list or array

Operators

The only valid operators are:

  • And
  • Or