data-filter-query Edge Function — Data

data-filter-query — MongoDB-style array filtering

Filters an array of objects using a MongoDB-style query language with comparison, logical, and regex operators.

---

API

POST /api/data-filter-query

Request body

Field	Type	Required	Description
items	object[]	✅	Array of objects to filter
query	object	✅	Filter query using operators

Supported operators:

Operator	Description
$eq	Equal (also implicit: { field: value })
$ne	Not equal
$gt	Greater than
$gte	Greater than or equal
$lt	Less than
$lte	Less than or equal
$in	Value in array
$nin	Value not in array
$exists	Field exists (true/false)
$regex	String matches regex pattern
$and	All conditions must match
$or	At least one condition must match
$not	Negates a condition

Success response (200)

{
  "success": true,
  "data": {
    "items": [{ "name": "Alice", "role": "admin" }],
    "count": 1,
    "total": 4
  }
}

Error responses

Code	HTTP	When
INVALID_INPUT	400	Missing or invalid field
INTERNAL_ERROR	500	Unexpected error

---

Usage

cURL

curl -X POST "$FUNCTION_URL" \
  -H "Content-Type: application/json" \
  -d '{"items": [{"name":"Alice","age":30},{"name":"Bob","age":20}], "query": {"age": {"$gte": 25}}}'

TypeScript / JavaScript (HTTP)

const response = await fetch(FUNCTION_URL, {
  method: 'POST',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({
    items: users,
    query: { $and: [{ role: 'admin' }, { age: { $gte: 25 } }] },
  }),
});
const { data } = await response.json();
console.log(data.items, data.count);

Direct import (Node / Bun / Deno)

import { filterQuery } from '@aerostack/functions/data-filter-query';

const { items, count } = filterQuery({ items: records, query: { status: 'active' } });

---

Use Cases

• Filtering in-memory datasets before displaying to a user without a database round-trip
• Building dynamic search/filter UIs where query conditions are constructed from user input
• Implementing configurable workflow conditions on JSON payloads

---

Notes

• Dot notation is supported for nested field access: { "user.role": "admin" }
• $regex uses JavaScript's RegExp — pattern is the string form without slashes
• $exists: true matches fields that are not undefined; $exists: false matches missing fields