Views query IN operator (specify multiple values)

Hi,
by the View docs, SQL like operators are currently not including IN operator.
This would be a very nice feature to have.
It would require view command to have a list of values that would then be passed like IN (:myIds).

That is IN our roadmap, so good to know that you would like to see it added.

Here is a list of a few other things of the view queries that are not supported yet. I’d love to hear what you find most important.

  • transformation function for filtering and transformation of the result in code
  • parentheses for AND / OR clauses
  • IS NULL and IS NOT NULL
  • limits, offset and paging
  • string comparators LIKE
1 Like

IMHO priority order would be like this:

  1. limits, offset and paging
  2. string comparators LIKE
  3. transformation function for filtering and transformation of the result in code (emphasize on filtering)
  4. IS NULL and IS NOT NULL
  5. parentheses for AND / OR clauses

First 3 i see as top priorirty.

What I really want at the moment is a query function such as ".startsWith(“string value”), which could obviously be accomplished with transformation function / filter.

I really like the list of proposed features though.

How about joins? I can imagine creating different views based on different events, which you want to join in yet another view.

IMHO using joins would be an anti-pattern for querying views.
One view should represent one data set representation (one table).
What is currently missing is enrichment that would be done on populating views (transformations). Here is a discussion about that:

I understand, you’re right.
Thanks for the link.