Enum Filter 

pub enum Filter {
    Eq {
        column: String,
        value: Value,
    },
    In {
        column: String,
        values: Vec<Value>,
    },
    Contains {
        column: String,
        value: String,
    },
    AnyContains {
        columns: Vec<String>,
        value: String,
    },
}

An extra predicate applied to a query: equality (owner/org scoping, ?field= filters) or membership (id IN (…), e.g. “organisations you belong to”). Column names are always validated and quoted; values are always bound.

Variants

Eq

column = value.

Fields

column: String

value: Value

In

column IN (values…). An empty set matches no rows.

Fields

column: String

values: Vec<Value>

Contains

column ILIKE '%value%' — a case-insensitive substring match, which is what a search box means by “search”. The pattern’s own wildcards are escaped, so a term containing % looks for a per-cent sign.

Fields

column: String

value: String

AnyContains

(c1 ILIKE '%value%' OR c2 ILIKE '%value%' …) — one term against several columns, which is what a search box over a configured set of fields means. An empty column list matches no rows.

Fields

columns: Vec<String>

value: String

Implementations

impl Filter

pub fn eq(column: impl Into<String>, value: impl Into<SqlValue>) -> Self

pub fn in_(column: impl Into<String>, values: Vec<SqlValue>) -> Self

pub fn in_uuids(column: impl Into<String>, ids: Vec<Uuid>) -> Self

Convenience: column IN (…uuids).

pub fn contains(column: impl Into<String>, value: impl Into<String>) -> Self

pub fn any_contains(columns: Vec<String>, value: impl Into<String>) -> Self

Search value against every one of columns, matching if any does.

Trait Implementations

impl Clone for Filter

fn clone(&self) -> Filter

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Filter

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.