Source: https://tanstack.com/db/latest/docs/reference/functions/extractSimpleComparisons

TanStack

DB v0v0

Search...

+ K

Auto

Log In

TanStack StartRC

Docs Examples GitHub Contributors

TanStack Router

Docs Examples GitHub Contributors

TanStack Query

Docs Examples GitHub Contributors

TanStack Table

Docs Examples Github Contributors

TanStack Formnew

Docs Examples Github Contributors

TanStack DBbeta

Docs Github Contributors

TanStack Virtual

Docs Examples Github Contributors

TanStack Paceralpha

Docs Examples Github Contributors

TanStack Storealpha

Docs Examples Github Contributors

TanStack Devtoolsalpha

Docs Github Contributors

More Libraries

Maintainers Partners Support Learn StatsBETA Discord Merch Blog GitHub Ethos Brand Guide

Documentation

Framework

React

Version

Latest

Search...

+ K

Menu

• Home

• Frameworks

• Contributors

• GitHub

• Discord

Getting Started

• Overview
  
  core

• Quick Start
  
  core

• Installation
  
  core

Guides

• Live Queries
  
  core

• Mutations
  
  core

• Schemas
  
  core

• Error Handling
  
  core

• Creating Collection Options Creators
  
  core

Collections

• Query Collection
  
  core

• Electric Collection
  
  core

• TrailBase Collection
  
  core

• RxDB Collection
  
  core

• PowerSync Collection
  
  core

• LocalStorage Collection
  
  core

• LocalOnly Collection
  
  core

Frameworks

• React
  
  core

• Vue
  
  core

• Angular
  
  core

• Solid
  
  core

• Svelte
  
  core

Community

• Resources & Packages
  
  core

API Reference

• Core API Reference
  
  core

• Collection
  
  core

• createCollection
  
  core

• liveQueryCollectionOptions
  
  core

• createLiveQueryCollection
  
  core

• createOptimisticAction
  
  core

• createTransaction
  
  core

• Electric DB Collection
  
  core

• electricCollectionOptions
  
  core

• Query DB Collection
  
  core

• queryCollectionOptions
  
  core

• RxDB DB Collection
  
  core

• rxdbCollectionOptions
  
  core

• PowerSync Collection
  
  core

• powerSyncCollectionOptions
  
  core

• React Hooks
  
  react

• useLiveQuery
  
  react

Framework

React

Version

Latest

Menu

• Home

• Frameworks

• Contributors

• GitHub

• Discord

Getting Started

• Overview
  
  core

• Quick Start
  
  core

• Installation
  
  core

Guides

• Live Queries
  
  core

• Mutations
  
  core

• Schemas
  
  core

• Error Handling
  
  core

• Creating Collection Options Creators
  
  core

Collections

• Query Collection
  
  core

• Electric Collection
  
  core

• TrailBase Collection
  
  core

• RxDB Collection
  
  core

• PowerSync Collection
  
  core

• LocalStorage Collection
  
  core

• LocalOnly Collection
  
  core

Frameworks

• React
  
  core

• Vue
  
  core

• Angular
  
  core

• Solid
  
  core

• Svelte
  
  core

Community

• Resources & Packages
  
  core

API Reference

• Core API Reference
  
  core

• Collection
  
  core

• createCollection
  
  core

• liveQueryCollectionOptions
  
  core

• createLiveQueryCollection
  
  core

• createOptimisticAction
  
  core

• createTransaction
  
  core

• Electric DB Collection
  
  core

• electricCollectionOptions
  
  core

• Query DB Collection
  
  core

• queryCollectionOptions
  
  core

• RxDB DB Collection
  
  core

• rxdbCollectionOptions
  
  core

• PowerSync Collection
  
  core

• powerSyncCollectionOptions
  
  core

• React Hooks
  
  react

• useLiveQuery
  
  react

On this page

• Function: extractSimpleComparisons()

• Parameters

• expr

• Returns

• Throws

• Example

extractSimpleComparisons

Copy Markdown

Function: extractSimpleComparisons()
====================================

ts

function extractSimpleComparisons(expr): SimpleComparison[];


function extractSimpleComparisons(expr): SimpleComparison[];

Defined in: packages/db/src/query/expression-helpers.ts:327

Extracts all simple comparisons from a WHERE expression. This is useful for simple APIs that only support basic filters.

Note: This only works for simple AND-ed conditions and NOT-wrapped comparisons. Throws an error if it encounters unsupported operations like OR or complex nested expressions.

NOT operators are flattened by prefixing the operator name (e.g., not(eq(...)) becomes not_eq).

Parameters
---------- ### expr

The WHERE expression to parse

BasicExpression<boolean> | null | undefined

Returns
-------

SimpleComparison []

Array of simple comparisons

Throws
------

Error if expression contains OR or other unsupported operations

Example
-------

typescript

const comparisons = extractSimpleComparisons(where)
// Returns: [\
//   { field: ['category'], operator: 'eq', value: 'electronics' },\
//   { field: ['price'], operator: 'lt', value: 100 },\
//   { field: ['email'], operator: 'isNull' }, // No value for null checks\
//   { field: ['status'], operator: 'not_eq', value: 'archived' }\
// ]


const comparisons = extractSimpleComparisons(where)
// Returns: [\
//   { field: ['category'], operator: 'eq', value: 'electronics' },\
//   { field: ['price'], operator: 'lt', value: 100 },\
//   { field: ['email'], operator: 'isNull' }, // No value for null checks\
//   { field: ['status'], operator: 'not_eq', value: 'archived' }\
// ]

Edit on GitHub

Home

Partners Become a Partner