GPUdb.filter_by_list( table_name = None, view_name = '', column_values_map =
None, options = {} )
Calculates which records from a table have values in the given list for the corresponding column. The operation is synchronous meaning that GPUdb will not return a response until all the objects are fully available. The response payload provides the count of the resulting set. A new resultant set (view) which satisfies the input filter specification is also created if a input parameter view_name is passed in as part of the request.
For example, if a type definition has the columns 'x' and 'y', then a filter by list query with the column map {"x":["10.1", "2.3"], "y":["0.0", "-31.5", "42.0"]} will return the count of all data points whose x and y values match one of the values in the respective x- and y-lists. If the filter_mode option is set to 'not_in_list' then the filter will match all items that are not in the provided list(s).
Input Parameter Description
| Name | Type | Description | ||||
|---|---|---|---|---|---|---|
| table_name | str | Name of the table to filter. This may be the ID of a collection, table or a result set (for chaining queries). Collections may be filtered only if all tables within the collection have the same type ID. | ||||
| view_name | str | If provided, then this will be the name of the view containing the results. Must not be an already existing collection, table or view. Default value is ''. | ||||
| column_values_map | dict of lists of str | List of values for the corresponding column in the table | ||||
| options | dict of str | Optional parameters. Default value is an empty dict ( {} ).
|
Output Parameter Description
| Name | Type | Description |
|---|---|---|
| count | long | The number of records passing the list filter. |