Filters
Returns all saved filters defined in the Pipedrive account, including their type, ownership, and visibility settings.
Table-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| Type | = |
For example, the following query is processed server-side:
SELECT * FROM Filters WHERE Id = 39
INSERT
Execute INSERT by specifying the Name, Conditions, and Type columns. You can also insert any columns that are not required.
For example:
INSERT INTO Filters (Name, Conditions, Type) VALUES ('Indias Filter', '{"glue": "and","conditions": [{"glue": "and","conditions": [{"object": "organization","field_id": "4020"}]}]}', 'deals')
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE Filters SET Name = 'Updating Pipedrive filters', Conditions = '{"glue": "and","conditions": [{"glue": "or","conditions": [{"object": "organization123","field_id": "4021"}]}]}' WHERE Id = 39
DELETE
Execute DELETE by specifying the Id in the WHERE clause.
For example:
DELETE FROM Filters WHERE Id = 10
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The ID of the filter. | |
| ActiveFlag | Boolean | True |
Indicates whether the filter is currently active and available for use in the Pipedrive application. | |
| AddTime | Datetime | True |
The date and time when the filter was created. | |
| CustomViewId | String | True |
The ID of the custom view associated with this filter, if applicable. | |
| Name | String | False |
The name of the filter. | |
| TemporaryFlag | String | True |
Indicates whether the filter is temporary and not permanently saved in the Pipedrive application. | |
| Type | String | False |
The types of filters to fetch. The allowed values are deals, org, people, products, activity. | |
| UpdateTime | String | True |
The date and time when the filter was last updated. | |
| UserId | Integer | True |
The ID of the user who owns this filter. | |
| VisibleTo | Integer | True |
The visibility level of the filter, controlling which users can see and apply it. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| Conditions | String |
The conditions of the filter as a JSON object. |