Search

---

Object Hierarchy:

Description:

Content:

Creation methods:

• public Search () throws SearchError
  Create Search instance. Throws a SearchError if the entity is not registered.
• public Search.with_entity_type (Type entity_type) throws SearchError
  Create Search instance from existing entity. Throws a SearchError if the entity is not and cannot be registered.

Methods:

• public G lookup (int? default_id, ...) throws SearchError
  Perform lookup on entity based on primary keys. Returns null if row is not found.
• public Search<G> search_with_arraylist (ArrayList<Value?> values) throws SearchError
  Perform lookup on entity based on primary keys.
• public Search<G> rows (int rows)
  Limit the results to the given number of rows.
• public Search<G> page (int page)
  Given the number of rows set before the query is execute, paginate and return the given page of results.
• public Search<G> eq (string column, ...) throws SearchError
  Add an equality check to the search, is equivalent to WHERE foo = 'bar'. Values must not be null or nullable.
• public Search<G> gt (string column, ...) throws SearchError
  Add a greater-than check to the search, is equivalent to WHERE foo > 1. Values must not be null or nullable.
• public Search<G> lt (string column, ...) throws SearchError
  Add a less-than check to the search, is equivalent to WHERE foo > 1. Values must not be null or nullable.
• public Search<G> gte (string column, ...) throws SearchError
  Add a greater-than-or-equal-to check to the search, is equivalent to WHERE foo >= 1. Values must not be null or nullable.
• public Search<G> lte (string column, ...) throws SearchError
  Add a less-than-or-equal-to check to the search, is equivalent to WHERE foo <= 1. Values must not be null or nullable.
• public Search<G> is_not_null (string column, ...) throws SearchError
  Add a not-null check to the search, is equivalent to WHERE foo IS NOT NULL.
• public Search<G> is_null (string column, ...) throws SearchError
  Add a null check to the search, is equivalent to WHERE foo IS NULL.
• public Search<G> like (string column, ...) throws SearchError
  Add a like check to the search, is equivalent to WHERE foo LIKE 'bar'. Values must not be null or nullable.
• public Search<G> ilike (string column, ...) throws SearchError
  Add an ilike check to the search, is equivalent to WHERE foo ILIKE 'bar', but will only work with PostgreSQL. Values must not be null or nullable.
• public Search<G> order_by (string column, bool is_descending = false)
  Add an ordered column.
• public Search<G> order_by_raw (string column, bool is_descending = false)
  Add a raw order expression.
• public Search<G> relationship (string relationship_name)
  Retrieve results of an existing relationship.
• public string as_query () throws SearchError
  Display the current search expression as a rendered SQL query.
• public G single () throws SearchError
  Retrieve a single element from the search.
• public ArrayList<G> list () throws SearchError
  Retrieve the full list of elements from this search.
• public int64 count () throws SearchError
  Retrieve count of elements from this search.
• public Search<G> new_search () throws SearchError

Inherited Members: