| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Field Type | Value Type | Operators | Filter(s) | Filter Behaviour (Returns results if …) | Fields | ||||||||||||||||||||
2 | Dropdown | String | is set | N/A | Field has value | |||||||||||||||||||||
3 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
4 | is equal to | Searchable Dropdown (field values) | Field value is one of specified filter values | |||||||||||||||||||||||
5 | is not equal to | Searchable Dropdown (field values) | Field value is not one of specified filter values | |||||||||||||||||||||||
6 | Searchable Dropdown | String | is set | N/A | Field has value | |||||||||||||||||||||
7 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
8 | is equal to | Searchable Dropdown (field values) | Field value is one of specified filter values | |||||||||||||||||||||||
9 | is not equal to | Searchable Dropdown (field values) | Field value is not one of specified filter values | |||||||||||||||||||||||
10 | Text Input | String | is set | N/A | Field has value | |||||||||||||||||||||
11 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
12 | is equal to | Searchable Dropdown (field values) | Field value is one of specified filter values | |||||||||||||||||||||||
13 | is not equal to | Searchable Dropdown (field values) | Field value is not one of specified filter values | |||||||||||||||||||||||
14 | Calendar Selection | Date | is set | N/A | Field has value | |||||||||||||||||||||
15 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
16 | is equal to | Date Picker | Field value is specified filter value | |||||||||||||||||||||||
17 | is not equal to | Date Picker | Field value is not specified filter value | |||||||||||||||||||||||
18 | is after | Date Picker | Field value is after specified filter value (excluding specified filter value) | |||||||||||||||||||||||
19 | is before | Date Picker | Field value is before specified filter value (excluding specified filter value) | |||||||||||||||||||||||
20 | is between | Date Pickers (2) | Field value is between specified filter values (including specified filter values) | |||||||||||||||||||||||
21 | is not between | Date Pickers (2) | Field value is not between specified filter values (including specified filter values) | |||||||||||||||||||||||
22 | Date Range Selection | Dates (2) | is set | N/A | Field has value | |||||||||||||||||||||
23 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
24 | starts before | Date Picker | Field 'start' value is before specified filter value (excluding 'start' filter value) | |||||||||||||||||||||||
25 | starts after | Date Picker | Field 'start' value is after specified filter value (excluding 'start' filter value) | |||||||||||||||||||||||
26 | ends before | Date Picker | Field 'end' value is before specified filter value (excluding 'end' filter value) | |||||||||||||||||||||||
27 | ends after | Date Picker | Field 'end' value is after specified filter value (excluding 'end' filter value) | |||||||||||||||||||||||
28 | lasts more than | Number input + Dropdown (days, months, years) | Duration calculated from field values is greater than specified filter value (including specified filter values) | |||||||||||||||||||||||
29 | lasts less than | Number input + Dropdown (days, months, years) | Duration calculated from field values is less than specified filter value (including specified filter values) | |||||||||||||||||||||||
30 | Yes/No Toggle | True/False | is set | N/A | Field has value | |||||||||||||||||||||
31 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
32 | is equal to | Yes/No Toggle | Field value is specified filter value | |||||||||||||||||||||||
33 | URL | String | is set | N/A | Field has value | |||||||||||||||||||||
34 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
35 | is equal to | Searchable Dropdown (field values) | Field value is one of specified filter values | |||||||||||||||||||||||
36 | is not equal to | Searchable Dropdown (field values) | Field value is not one of specified filter values | |||||||||||||||||||||||
37 | Number | Number | is set | N/A | Field has value | |||||||||||||||||||||
38 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
39 | is equal to | Number input | Field value is specified filter value | |||||||||||||||||||||||
40 | is not equal to | Number input | Field value is not specified filter value | |||||||||||||||||||||||
41 | is greater than | Number input | Field value is greater than specified filter value (excluding specified filter value) | |||||||||||||||||||||||
42 | is less than | Number input | Field value is less than specified filter value (excluding specified filter value) | |||||||||||||||||||||||
43 | is between | Number inputs (2) | Field value is between specified filter values (including specified filter value) | |||||||||||||||||||||||
44 | is not between | Number inputs (2) | Field value is not between specified filter values (including specified filter values) | |||||||||||||||||||||||
45 | Currency | Number | is set | N/A | Field has value | |||||||||||||||||||||
46 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
47 | is equal to | Number input + Dropdown (currencies) | Field value is specified filter value | |||||||||||||||||||||||
48 | is not equal to | Number input + Dropdown (currencies) | Field value is not specified filter value | |||||||||||||||||||||||
49 | is greater than | Number input + Dropdown (currencies) | Field value is greater than specified filter value (excluding specified filter value) | |||||||||||||||||||||||
50 | is less than | Number input + Dropdown (currencies) | Field value is less than specified filter value (excluding specified filter value) | |||||||||||||||||||||||
51 | is between | Number inputs (2) + Dropdown (currencies) | Field value is between specified filter values (including specified filter value) | |||||||||||||||||||||||
52 | is not between | Number inputs (2) + Dropdown (currencies) | Field value is not between specified filter values (including specified filter values) | |||||||||||||||||||||||
53 | Percentage | Number | is set | N/A | Field has value | |||||||||||||||||||||
54 | is not set | N/A | Field does not have value | |||||||||||||||||||||||
55 | is equal to | Number input + '%' symbol | Field value is specified filter value | |||||||||||||||||||||||
56 | is not equal to | Number input + '%' symbol | Field value is not specified filter value | |||||||||||||||||||||||
57 | is greater than | Number input + '%' symbol | Field value is greater than specified filter value (excluding specified filter value) | |||||||||||||||||||||||
58 | is less than | Number input + '%' symbol | Field value is less than specified filter value (excluding specified filter value) | |||||||||||||||||||||||
59 | is between | Number inputs (2) + '%' symbol | Field value is between specified filter values (including specified filter value) | |||||||||||||||||||||||
60 | is not between | Number inputs (2) + '%' symbol | Field value is not between specified filter values (including specified filter values) | |||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |