9,266
edits
(4 intermediate revisions by 2 users not shown) | |||
Line 55: | Line 55: | ||
* AND operator: all grouped conditions must be met | * AND operator: all grouped conditions must be met | ||
* OR operator: at least one of the grouped conditions must be met | * OR operator: at least one of the grouped conditions must be met | ||
Unless you specify a different relation between conditions, the implicit operator is AND, i.e., all conditions must be met. | |||
To establish a relation between multiple groups of conditions, use the Group AND and Group OR operators. | |||
=== Example with multiple linked entities === | |||
The following filter for the Bookable Resource Booking links three additional entities. One of them, L1, is explicitly mentioned in the BRB condition group. The two other links are not, but they are still part of the filter, and they are linked by the implicit AND operator. In effect, this filter has three condition groups that '''all must be met''': | |||
* Bookable Resource Booking | |||
* Work Order (L0) | |||
* Resource (L2) | |||
[[File:Example of a complex filter.png|600px]] | |||
== Define sort order and restrict count == | == Define sort order and restrict count == | ||
Line 104: | Line 117: | ||
[[File:Search vs filter.png|300px]] | [[File:Search vs filter.png|300px]] | ||
If you use search strings in filters, you have to remove all fields configured for search from the view and add them as a search condition into the filter using <code>@@filter@@</code> as well. The reason is that the fetch for entity records is constructed from conditions defined in the filter and search fields using AND to group them together. If the conditions are grouped using AND, it will restrict the desired records from being filtered, as it is unlikely that the conditions will be met. | |||
[[File:Search fields.png]] | |||
[[Category:Woodford]] | [[Category:Woodford]] |