Selecto.Subfilter.SQL.AnyAllBuilder (Selecto v0.4.5)

Copy Markdown

Builds ANY and ALL subqueries for subfilters.

These strategies are useful for more complex comparisons against a set of values returned by a subquery.

Example SQL (ANY)

release_year > ANY (
  SELECT year
  FROM special_release_years
)

Example SQL (ALL)

rating > ALL (
  SELECT rating
  FROM competing_films
)

Summary

Functions

generate(type, spec, join_resolution, registry)

Generate ANY or ALL subquery SQL for a given subfilter.

Functions

generate(type, spec, join_resolution, registry)

@spec generate(
  :any | :all,
  Selecto.Subfilter.Spec.t(),
  Selecto.Subfilter.JoinPathResolver.JoinResolution.t(),
  any()
) :: {:ok, String.t(), [any()]} | {:error, Selecto.Subfilter.Error.t()}

Generate ANY or ALL subquery SQL for a given subfilter.