Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
protogrid:filter [2020-07-03 17:58] – mhaprotogrid:filter [2023-05-16 13:57] (current) – [Filter] dru
Line 3: Line 3:
 Protogrid has built-in filter mechanisms which are enabled by default for the most common use cases. For example if you have embedded a tableview on a proto for displaying next working steps the displayed entries are automatically filtered so only those next working steps are shown which are assigned to the current responsible (which is placed in a relation field on the same proto). Protogrid has built-in filter mechanisms which are enabled by default for the most common use cases. For example if you have embedded a tableview on a proto for displaying next working steps the displayed entries are automatically filtered so only those next working steps are shown which are assigned to the current responsible (which is placed in a relation field on the same proto).
  
-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 fields to allow users dynamically limiting the data available.  +For every field type you can control specific behavioral aspects which are related to data filtering.
- +
-Additionally to data filters Protogrid provides 2 data security features to restrict access to data: "Read Access Role Definition" and "Write Access Role Definition" fields (see [[protogrid/read_and_write_access_role_definition]]).+
  
 +Additionally to data filters Protogrid provides 2 data security features to restrict access to data: "Read Access Role Definition" and "Write Access Role Definition" fields (see [[protogrid:Read And Write Access Role Definition|Read And Write Access Role Definition]]).
 ==== Filter Options ==== ==== Filter Options ====
  
Line 33: Line 32:
 Available for: TableView Definition 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 +With this option you can control if the TableView is filtered at all, only by filter fields, only by relation fields, or both.
- +
-=== Enable Multi Column Indexing for this Field === +
- +
-Available for: Text Field Definition, Number Field Definition, Date Field Definition, Relation Field Definition, Tags Field Definition +
- +
-This setting effects TableView filtering in combination with Filter Fields. A maximum of four fields can be enabled per Proto in order to filter and sort TableViews for them in combination. If this setting is set to "No", TableViews cannot be sorted or filtered for this column if another filter is already active. +
- +
 ==== Filter Fields ==== ==== Filter Fields ====
  
Line 51: Line 42:
   * Number Filter Field   * Number Filter Field
   * Date 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 "Enable Multi Column Indexing for this Field": 
- 
-{{https://protogrid.wiki/_media/protogrid/enablemulticolumnindexing.png}} 
  
 === Relation Filter === === Relation Filter ===
Line 63: Line 50:
  
 A text filter field let's the user enter any input. Filtering occurs only on full match of the input term. 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 === === Number Filter ===

Trace:

Print/export