# Filters ## Documentation The filters of the users, used to select deals, leads, persons, organizations, products and activities. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Settings` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Filters` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active_flag` | `char` | | ☐ | The active flag of the filter. | | `add_time` | `datetime` | | ☐ | The date and time when the filter was added. | | `conditions` | `varchar2` | | ☐ | The conditions of the filter as a JSON object. Only taken when writing; empty when read. | | `custom_view_id` | `int64` | | ☐ | The custom view ID linked to the filter. | | `filter_code` | `varchar2` | | ☐ | The system code of the filter. | | `id` | `int64` | | ☑ | The ID of the filter. | | `is_editable` | `char` | | ☐ | Whether the filter can be edited by the requesting user. | | `last_used_time` | `datetime` | | ☐ | The date and time when the filter was last used. | | `name` | `varchar2` | | ☐ | The name of the filter. | | `temporary_flag` | `char` | | ☐ | Whether the filter is temporary. | | `type` | `varchar2` | | ☐ | The type. | | `update_time` | `datetime` | | ☐ | The date and time when the filter was updated. | | `user_id` | `int64` | | ☐ | The owner of the filter. | | `visible_to` | `varchar2` | | ☐ | The visible to. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Filters, when item is 'filter'. |