Filter by size of a list attribute about electrodb HOT 2 CLOSED

Hi @RaeesBhatti 👋

ElectroDB version 2.4.0 introduces a size() function within the where clause. To perform the operation you expect you can use the following syntax:

trackers.query.category({category: 'adventure'})
  .where(({ subscribers }, {size, escape}) => `
    ${size(subscribers)} > ${escape(2)}
  `)
  .go();

I will also add that the where clause is quite literally forming the FilterExpression. So you can always implement any functions and/or any other pattern without the use of specialized op functions. For example:

trackers.query.category({category: 'adventure'})
.where(({ subscribers }, {name, escape}) => `
  size(${name(subscribers)}) > ${escape(2)}
`)
.go();

from electrodb.

Ah I see. Thank you! I tried to write a custom where clause and FilterExpression but it would just get dropped in the final query. I see now that I need to use name() to make sure it wouldn't.

from electrodb.