Filter
Filter group
A filter group is the base definition for the powerful filtering mechanism of Dime.Scheduler. Filter groups are used to filter on resources and tasks, but also to set up the data-driven part of the security system.
The following entities are exposed through the import service.
Upsert filter group
Inserts or updates a filter group record.
| Name | Data Type | Default | Required |
|---|---|---|---|
| Id | int | 0 | |
| GroupName | nvarchar(50) | ✔️ | |
| ColumnNo | int | 0 | |
| DataFilter | bit | 0 |
Rename filter group
Renames the filter group.
| Name | Data Type | Default | Required |
|---|---|---|---|
| GroupName | nvarchar(50) | ✔️ | |
| NewGroupName | nvarchar(50) | ✔️ |
Delete filter group
Removes the filter group.
| Name | Data Type | Default | Required |
|---|---|---|---|
| GroupName | nvarchar(50) | ✔️ |
Filter value
A filter value is the child of filter group, and a filter group is required before any filter value can be added.
Upsert filter value
Inserts or updates a filter value record.
| Name | Data Type | Default | Required |
|---|---|---|---|
| FilterGroupName | nvarchar(50) | ✔️ | |
| FilterValue | nvarchar(100) | ✔️ |
Rename filter value
Renames a filter value record. A filter value is the child of filter group, and a filter group is required before any filter value can be added.
| Name | Data Type | Default | Required |
|---|---|---|---|
| FilterGroupName | nvarchar(50) | ✔️ | |
| FilterValue | nvarchar(100) | ✔️ | |
| NewFilterValue | nvarchar(100) | ✔️ |
Delete filter value
Removes the filter value.
| Name | Data Type | Default | Required |
|---|---|---|---|
| FilterGroupName | nvarchar(50) | ✔️ | |
| FilterValue | nvarchar(100) | ✔️ |