Skip to main content
Source

​
pub async fn filter_by_string( &self, table_name: String, view_name: String, expression: String, mode: String, column_names: Vec<String>, ) -> Result<FilterByStringResponse, KineticaError>

Filter a dataset for records with matching column text values

Calculates which objects from a table or view match a string expression for the given string columns. Setting case_sensitive can modify case sensitivity in matching for all modes except search. For search mode details and limitations, see Full Text Search.

  • table_name - Name of the table on which the filter operation will be performed, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table or view.
  • view_name - If provided, then this will be the name of the view containing the results, in [schema_name.]view_name format, using standard name resolution rules and meeting table naming criteria. Must not be an already existing table or view.
  • expression - The expression with which to filter the table.
  • mode - The string filtering mode to apply. See below for details.
  • column_names - List of columns on which to apply the filter. Ignored for search mode.
Source

​
pub async fn filter_by_string_with_opts( &self, table_name: String, view_name: String, expression: String, mode: String, column_names: Vec<String>, options: FilterByStringRequestOptions, ) -> Result<FilterByStringResponse, KineticaError>

Filter a dataset for records with matching column text values

Calculates which objects from a table or view match a string expression for the given string columns. Setting case_sensitive can modify case sensitivity in matching for all modes except search. For search mode details and limitations, see Full Text Search.

  • table_name - Name of the table on which the filter operation will be performed, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table or view.
  • view_name - If provided, then this will be the name of the view containing the results, in [schema_name.]view_name format, using standard name resolution rules and meeting table naming criteria. Must not be an already existing table or view.
  • expression - The expression with which to filter the table.
  • mode - The string filtering mode to apply. See below for details.
  • column_names - List of columns on which to apply the filter. Ignored for search mode.
  • options - The optional parameters; any left unset take the server’s defaults.

Sends a pre-built FilterByStringRequest to the /filter/bystring endpoint.

Sends a pre-built FilterByStringRequest to a specific worker URL, bypassing HA head-node selection. Used for multi-head access.