Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
protogrid:filter [2019-11-29 14:53] – 46.140.51.3 | protogrid:filter [2023-01-19 09:57] – [Filter Options] dru | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Filter ====== | ====== Filter ====== | ||
- | A Filter is basically a field for choosing a filter | + | Protogrid has built-in |
- | By choosing one of the filter | + | For every field type you can control specific behavioral aspects which are related to data filtering. For tableviews you can select from 4 types of filter |
- | === Defining a Filter === | + | Additionally to data filters Protogrid provides 2 data security features to restrict access to data: "Read Access Role Definition" |
+ | ==== Filter | ||
- | First | + | Depending on the field type you have any of the following filtering options available for a field definition: |
+ | === Limit Using Compatible Filters on the same Card === | ||
+ | |||
+ | Available for: Relation Field Definition, Tag Field Definition | ||
+ | |||
+ | The available choices are filtered using neighboring relation fields and filters that use the same Proto as a relation field in the target data. | ||
+ | |||
+ | === Additional filter based on read access setting === | ||
+ | |||
+ | Available for: Relation Field Definition | ||
+ | |||
+ | The available choices are filtered based on the read access rights of the target data. The system default is that users can see the shortname of a card, even when the card itself is resticted from access using a read access role definition. | ||
+ | |||
+ | === Disable filter effect on neighboured fields on the same card === | ||
+ | |||
+ | Available for: Relation Field Definition | ||
+ | |||
+ | With this option you can disable the filtering effect on neighboring relation or tags fields. | ||
+ | |||
+ | === Filtering of cards represented in this field === | ||
+ | |||
+ | Available for: TableView Definition | ||
+ | |||
+ | With this option you can control if the TableView is filtered at all, only by filter fields, only by relation fields, or both. | ||
+ | ==== Filter Fields ==== | ||
+ | |||
+ | A Filter field is basically a field for choosing a filter condition and limiting which Cards are shown in a Table View or Chart View. | ||
+ | |||
+ | Currently there exist 4 types of filter fields: | ||
+ | * Relation Filter Field | ||
+ | * Text Filter Field | ||
+ | * Number Filter Field | ||
+ | * Date Filter Field | ||
+ | |||
+ | Hint: if you want to combine multiple filter fields for tableview filtering the target fields must have activated the option " | ||
+ | |||
+ | {{https:// | ||
+ | |||
+ | === Relation Filter === | ||
+ | |||
+ | A relation filter field let's the user select from the available values in the target field and limits the embedded tableview based on the selection. | ||
+ | |||
+ | === Text Filter === | ||
+ | |||
+ | A text filter field let's the user enter any input. Filtering occurs only on full match of the input term. | ||
+ | |||
+ | Please note that the content of text fields is relevant for filtering only up to and including the 300th character. | ||
+ | |||
+ | === Number Filter === | ||
+ | |||
+ | A number filter field let's the user enter any input. Filtering occurs only on full match of the input number. | ||
+ | |||
+ | === Date Filter === | ||
+ | |||
+ | A date filter field provides a date picker to select a date. Filtering for time values is not supported. | ||
+ | |||
+ | |||
+ | === Example: Creating a Relation Filter to filter a Table View === | ||
+ | - Open the Proto on which the Table View, you want to filter, is defined | ||
+ | - Go to " | ||
+ | - Choose " | ||
+ | - Assign a meaningful name for the new Relation Filter Field | ||
+ | - Define the " | ||
+ | - Save & Close the " | ||
+ | - The new " | ||
+ | - Open the Table View you want to filter, and use the new " | ||
+ | |||
+ | === Example: Creating a Date Filter to filter a Chart View === | ||
+ | - Open the Proto on which the Chart View, you want to filter, is defined | ||
+ | - Go to " | ||
+ | - Choose "Date Filter Definition" | ||
+ | - Assign a meaningful name for the new Date Filter Field | ||
+ | - Define the " | ||
+ | - Save & Close the "Date Filter Definition" | ||
+ | - The new "Date Filter Definition" | ||
+ | - Open the Chart View, you want to filter, and use the new "Date Filter Field" to choose the data to filter for | ||