# 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:

```java
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`


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://coldbox-orm.ortusbooks.com/v3.x-3/base-orm-service-1/dynamic-finders-counters/method-expressions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.