v2.0.0-pre.18

Querying Data

You can query data from the store using the Feathers Query Syntax with the findInStore method.

$select is disabled

The $select filter in local queries is ignored. The purpose of $select is to choose a subset of keys on the API server data to return. The primary goal for this functionality is to reduce the amount of transferred data. In client apps, the data is naturally filtered out of the UI through template-specific bindings.

Local Params API

Notice

As a security measure, the Feathers Client does not send query params to the API server.

params.temps

By default, queries do not include temporary records. You can add temporary records to the query results by setting params.temps to true.

const { data } = Model.findInStore({ query: {}, temps: true })

params.clones

Store queries normally return data from items (or temps if params.temps is used). If you pass params.clones as true it will return clones of the matching items. This applies to the findInStore and getFromStore methods on the model and store:

const { data } = Model.findInStore({ query: {}, clones: true })
data.forEach(item => {
  console.log(item.__isClone) // --> true
})

The clones param can be used together with temps, as well:

const { data } = Model.findInStore({ query: {}, clones: true, temps: true })

Note that any existing clones are re-used, so if you need the clone to match the latest data you need to call clone.reset(), manually.

Query Props Overview

Feathers-Pinia supports all of the following query props, however, different filters and operators are supported by different databases. The following key indicates support:

🕊️ all Feathers Database Adapters
🌱 the MongoDB Adapter
🚩 one of the SQL Adapters (see @feathersjs/knex)

If your Feathers API Service supports any of these operators, you can use the operators in useFind queries to speed up user experience with the fall-through cache.

Filters

Filters are special properties (starting with a $) added at the top level of a query.

$limit 🕊️

$limit limits the number of records returned. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob' },
  { id: 2, name: 'Joe' },
  { id: 3, name: 'Mary' },
]

Model.find({ query: { $limit: 1 } })

[
  { id: 1, name: 'Bob' },
]

$skip 🕊️

$skip skips the number of records indicated. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob' },
  { id: 2, name: 'Joe' },
  { id: 3, name: 'Mary' },
]

Model.find({ query: { $limit: 1, $skip: 1 } })

[
  { id: 2, name: 'Joe' },
]

$sort 🕊️

$sort sorts data in the direction indicated by 1 (ascending) or -1 (descending). docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob' },
  { id: 2, name: 'Joe' },
  { id: 3, name: 'Mary' },
]

Model.find({ query: { $sort: { name: -1 } } })

[
  { id: 3, name: 'Mary' },
  { id: 2, name: 'Joe' },
  { id: 1, name: 'Bob' },
]

$select 🕊️

$select restricts each object to the named keys. docs

🕊️ Supported by all database adapters.

ignored for local queries

Feathers-Pinia local queries will always return the full object and ignore `$select`. Queries to API servers will work as normal.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ query: { $select: ['id', 'name'] } })

[
  { id: 1, name: 'Bob' },
  { id: 2, name: 'Joe' },
  { id: 3, name: 'Mary' },
]

$or 🕊️

$or matches records against any query provided in its array of queries. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ query: { $or: [{ name: 'Bob' }, { id: 3 }] } })

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 3, name: 'Mary', age: 35 },
]

$nor 🌱

$nor matches records that match non of the queries provided in the array.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ query: { $nor: [{ name: 'Bob' }, { id: 3 }] } })

[
  { id: 2, name: 'Joe', age: 21 },
]

$and 🌱 🚩

$and matches records which match all queries provided in its array.

🌱 🚩 Supported by MongoDB and Knex

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ 
  query: { 
    $and: [
      { age: { $gt: 20 } },
      { id: { $gt: 2 } }
    ] 
  } 
})

[
  { id: 3, name: 'Mary', age: 35 },
]

Operators

Operators either query a property for a specific value or determine nested special properties (starting with a $) that allow querying the property for certain conditions. When multiple operators are set, conditions have to apply for a property to match.

Equality 🕊️

Matches if an object has the same key:value pair as provided in the query. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: 'Mary' })

[
  { id: 3, name: 'Mary', age: 35 },
]

$in 🕊️

$in matches any record with a value matching any of the values in the array. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: { $in: ['Mary', 'Bob'] } })

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 3, name: 'Mary', age: 35 },
]

$nin 🕊️

$nin matches any record with no matching value from the array. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: { $nin: ['Mary', 'Bob'] } })

[
  { id: 2, name: 'Joe', age: 21 },
]

$lt 🕊️

$lt matches any value less than the provided value. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: { $lt: 35 } })

[
  { id: 2, name: 'Joe', age: 21 },
]

$lte 🕊️

$lte matches any value less than or equal to the provided value. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: { $lte: 35 } })

[
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

$gt 🕊️

$gt matches any value greater than the provided value. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: { $gt: 35 } })

[
  { id: 1, name: 'Bob', age: 42 },
]

$gte 🕊️

$gte matches any value greater than or equal to the provided value. docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: { $gte: 35 } })

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 3, name: 'Mary', age: 35 },
]

$ne 🕊️

$ne matches any value that does not equal the provided value docs

🕊️ Supported by all database adapters.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ name: { $ne: 35 } })

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
]

$exists 🌱

$exists matches if the property is not null or undefined docs

🌱 Supported by the MongoDB Adapter

[
  { _id: 1, name: 'Bob' },
  { _id: 2, name: null },
  { _id: 3, name: 'Mary' },
]

Model.find({ query: { name: { $exists: true } } })

[
  { _id: 1, name: 'Bob' },
  { _id: 3, name: 'Mary' },
]

$mod 🌱

$mod matches where the value of a field divided by a divisor has the specified remainder. docs

🌱 Supported by the MongoDB Adapter

[
  { _id: 1, item: 'Banana', qty: 0 },
  { _id: 2, item: 'Apple', qty: 5 },
  { _id: 3, item: 'Orange', qty: 12 }
]

Model.find({ query: { qty: { $mod: [ 4, 0 ] } } })

[
  { _id: 1, item: 'Banana', qty: 0 },
  { _id: 3, item: 'Orange', qty: 12 }
]

$all 🌱

$all matches when an array value contains all the specified elements. docs

🌱 Supported by the MongoDB Adapter

[
  { _id: 1, name: 'Bob', languages: ['English'] },
  { _id: 2, name: 'Joe', languages: ['English', 'Spanish'] },
  { _id: 3, name: 'Mary', languages: ['Spanish'] },
]

Model.find({ query: { languages: { $all: ['Spanish', 'English'] } } })

[
  { _id: 2, name: 'Joe', languages: ['English', 'Spanish'] },
]

$size 🌱

$size matches when the array field's length matches the provided number. docs

🌱 Supported by the MongoDB Adapter

[
  { _id: 1, name: 'Bob', languages: ['English'] },
  { _id: 2, name: 'Joe', languages: ['English', 'Spanish'] },
  { _id: 3, name: 'Mary', languages: ['Spanish'] },
]

Model.find({ query: { languages: { $size: 1 } } })

[
  { _id: 1, name: 'Bob', languages: ['English'] },
  { _id: 3, name: 'Mary', languages: ['Spanish'] },
]

$regex 🌱

$regex matches a regular expression against a value based on matching $options. docs

🌱 Supported by the MongoDB Adapter

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

// Match any `name` with an "o" in it
Model.find({ name: { $regex: 'o', $options 'igm' } })

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
]

$options 🌱

Can only be used with the $regex operator. See above.

🌱 Supported by the MongoDB Adapter

$not 🌱

$not performs a logical NOT operation on the specified query. docs

🌱 Supported by the MongoDB Adapter

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

// Match any `name` without an "o" in it
Model.find({ name: { $not: { $regex: 'o', $options 'igm' } } })

[
  { id: 3, name: 'Mary', age: 35 },
]

$like 🚩

$like performs a case-sensitive match on values.

🚩 Supported by these SQL Adapters: @feathersjs/knex, feathers-objection, feathers-sequelize

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

// Match any `name` with an "o" in it
Model.find({ name: { $like: '%o%' } })

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
]

$ilike 🚩

$ilike performs a case-insensitive match on values.

🚩 Supported by these SQL Adapters: @feathersjs/knex, feathers-objection

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

// Match any `name` with an "o" in it
Model.find({ name: { $ilike: 'b%' } })

[
  { id: 1, name: 'Bob', age: 42 },
]

$iLike 🚩

See $ilike.

🚩 Supported by these SQL Adapters: feathers-sequelize

$notlike 🚩

$notlike performs a case-sensitive negative match against values.

🚩 Supported by these SQL Adapters: @feathersjs/knex, feathers-sequelize

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

// Match any `name` with an "o" in it
Model.find({ name: { $notlike: 'B%' } })

[
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

$notLike 🚩

See $notlikeperforms a case-insensitive negative match against values.

🚩 Supported by these SQL Adapters: feathers-objection, feathers-sequelize

$notILike 🚩

$notILike

🚩 Supported by these SQL Adapters: feathers-objection, feathers-sequelize

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

// Match any `name` with an "o" in it
Model.find({ name: { $notILike: 'b%' } })

[
  { id: 2, name: 'Joe', age: 21 },
  { id: 3, name: 'Mary', age: 35 },
]

$type

$type matches when the type of the value matches the provided JS constructor.

Only supported by local queries. A variation of $type is supported by MongoDB, but uses alias strings instead of JS constructors.

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 2, name: 'Joe', age: null },
  { id: 3, name: 'Mary', age: 35 },
]

Model.find({ age: { $type: Number } })

[
  { id: 1, name: 'Bob', age: 42 },
  { id: 3, name: 'Mary', age: 35 },
]

Querying Data #

Local Params API #

params.temps #

params.clones #

Query Props Overview #

Filters #

$limit 🕊️ #

$skip 🕊️ #

$sort 🕊️ #

$select 🕊️ #

$or 🕊️ #

$nor 🌱 #

$and 🌱 🚩 #

Operators #

Equality 🕊️ #

$in 🕊️ #

$nin 🕊️ #

$lt 🕊️ #

$lte 🕊️ #

$gt 🕊️ #

$gte 🕊️ #

$ne 🕊️ #

$exists 🌱 #

$mod 🌱 #

$all 🌱 #

$size 🌱 #

$regex 🌱 #

$options 🌱 #

$not 🌱 #

$like 🚩 #

$ilike 🚩 #

$iLike 🚩 #

$notlike 🚩 #

$notLike 🚩 #

$notILike 🚩 #

$type #

Querying Data

Local Params API

params.temps

params.clones

Query Props Overview

Filters

$limit 🕊️

$skip 🕊️

$sort 🕊️

$select 🕊️

$or 🕊️

$nor 🌱

$and 🌱 🚩

Operators

Equality 🕊️

$in 🕊️

$nin 🕊️

$lt 🕊️

$lte 🕊️

$gt 🕊️

$gte 🕊️

$ne 🕊️

$exists 🌱

$mod 🌱

$all 🌱

$size 🌱

$regex 🌱

$options 🌱

$not 🌱

$like 🚩

$ilike 🚩

$iLike 🚩

$notlike 🚩

$notLike 🚩

$notILike 🚩

$type