Does orama support "nested conditions" and "Or" operation in filtering?

[AHaseebAwan]

Orama documentation on filtering - https://docs.oramasearch.com/open-source/usage/search/filters - presents this kind of structure for applying filters:

const results = await search(db, {
  term: 'prestige',
  where: {
    year: {
      gte: 2000,
    },
    'meta.rating': {
      between: [5, 10],
    },
    'meta.length': {
      lte: 60,
    }
  },
})

By the looks of it, this implies that these conditions are joined by an "and", and there is also no talk of an "or" operator or nested conditions. So in short, my question is whether orama support or plan to support this in future?

Basically something like this mongodb filter:

status: 'A',
$or: [
    { qty: { $lt: 30 } }, { item: { $regex: '^p' } }
  ]
}

or this SQL where clause:

WHERE status = "A" AND ( qty < 30 OR item LIKE "p%")

[micheleriva]

Hi @AHaseebAwan ,
We don't support this right now. Might be in the roadmap for the future, but I don't have an exact timeframe to give you right now.