Skip to main content
interface FilterByTableRequest
column_name: string;
options?: Record<string, string>;
source_table_column_name: string;
source_table_name: string;
table_name: string;
view_name?: string;
column_name options? source_table_column_name source_table_name table_name view_name?
column_name: string

Name of the column by whose value the data will be filtered from the table designated by table_name.

options?: Record<string, string>

Optional parameters.

source_table_column_name: string

Name of the column in the source_table_name whose values will be used as the filter for table table_name. Must be a geospatial geometry column if in ‘spatial’ mode; otherwise, Must match the type of the column_name.

source_table_name: string

Name of the table whose data will be compared against in the table called table_name, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table.

table_name: string

Name of the table whose data will be filtered, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table.

view_name?: string

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.