# Interface: FilterConditionObject

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:36

Object-form filter condition supporting scalar operators, logical grouping, and column-anchored EXISTS/NOT EXISTS predicates.

Example

const filter: FilterConditionObject = {
  min: 10,
  max: 100,
  exists: { sql: 'SELECT 1 FROM orders WHERE user_id = $c0' }
};
Related tests: packages/core/tests/transformers/DynamicQueryBuilder.test.ts

Properties

min?

optional min: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:37

---

max?

optional max: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:38

---

like?

optional like: string

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:39

---

ilike?

optional ilike: string

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:40

---

in?

optional in: SqlParameterValue[]

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:41

---

any?

optional any: SqlParameterValue[]

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:42

---

=?

optional =: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:43

---

>?

optional >: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:44

---

<?

optional <: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:45

---

>=?

optional >=: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:46

---

<=?

optional <=: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:47

---

!=?

optional !=: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:48

---

<&gt;?

optional <&gt;: SqlParameterValue

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:49

---

or?

optional or: object[]

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:50

Index Signature

[operator: string]: SqlParameterValue

column

column: string

---

and?

optional and: object[]

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:51

Index Signature

[operator: string]: SqlParameterValue

column

column: string

---

column?

optional column: string

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:53

---

exists?

optional exists: ExistsSubqueryDefinition

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:54

---

notExists?

optional notExists: ExistsSubqueryDefinition

Defined in: packages/core/src/transformers/DynamicQueryBuilder.ts:55