Skip to content

Allow queries to use SQLite functions #3609

@so1ve

Description

@so1ve

Is your feature request related to a problem? Please describe

Currently we cannot use where to query nested fields e.g. where("foo.bar", "=", "test").

Describe the solution you'd like

After some research I found that I needed to use json_extract function to do this, but the first parameter of where seems to be forced to be wrapped in quotes. Enabling such usage would be much more convenient.

Describe alternatives you've considered

Additional context

#2960 (comment) says not yet supported in Content query builder.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions