Listfilter Model
Overview
The listfilter table is designed to store filtering preferences and list views for users within a specific application or organization. It tracks user-defined filters, their status, and the applied settings for various lists, enabling custom views and better management of data display based on specific criteria.
Fields
| Field | Type | Description | Required |
|---|---|---|---|
| id | string | Unique identifier for the list filter record. | ❌ |
| listName | string | The name of the list or view this filter applies to. | ✅ |
| user_id | string | ID of the user who created or owns the filter. This allows saving personal filters. | ✅ |
| application_id | string | ID of the application where the filter is used.Helps associate the filter with a specific app. | ❌ |
| org_id | string | Organization ID associated with the filter. Ensures filters are scoped correctly in multi-tenant or org-specific systems. | ✅ |
| default | any | Boolean flag indicating if this is the default filter. Could be used to auto-load it. | ❌ |
| extension_id | string | ID to link the filter to an extension or plugin feature that augments the base application. | ❌ |
| object_id | string | ID of the target object (like a list module or data type) the filter applies to. | ❌ |
| bundle_id | any | ID of the associated bundle, if any. | ❌ |
| override | any | Flag to determine if the filter overrides existing settings. | ❌ |
| filters | object | The actual filter configuration stored in JSON or serialized format. Includes fields like sort order, conditions, column selection, etc. | ✅ |
| appliedFilter | object | appliedFilter field | ❌ |
| listView | string | listView field | ✅ |
| created_at | date | Timestamp when the filter was created. | ❌ |
| modified_at | date | Timestamp when the filter was last updated. | ❌ |
Sample JSON
{
"id": "example_value",
"listName": "example_value",
"user_id": "example_value",
"application_id": "example_value",
"org_id": "example_value",
"default": "example_value",
"extension_id": "example_value",
"object_id": "example_value",
"bundle_id": "example_value",
"override": "example_value",
"filters": "example_value",
"appliedFilter": "example_value",
"listView": "example_value",
"created_at": "example_value",
"modified_at": "example_value"
}