UX-Framework Tablefilter
- Herbert Eiselt
- Michael Dürre
- aijana.schumann
The table supports a filter mechanism. Activation/Deactivation by symbol "Downside arrow" in right upper corner.
Available field for one entry are
as (String) "date", "modelIdentifier", "manufacturerIdentifier", "typeName", "description", "uuid", "version", "parentUuid", "containedHolder", "mountpoint", "partTypeId", "serial",
as (long) "treeLevel".
Filter rules for filter string
ES wildchar query is used
Case sensitive
Wildchards are:
'*' A sequence of chars
'?' Exact one char
Examples for filter rules
input | desc | regex | datatype | matching (comma seperated) | not matching (comma seperated) |
|---|---|---|---|---|---|
Ad | equals 'Ad' | /^Ad$/g | string | Ad | admin, monica |
Ad* | startswith 'Ad' | /^Ad/g | string | Admin, Add | admin, monica |
*Ad | endswith 'Ad' | /Ad$/g | string | mkisdAd | mkdisad, youtube |
*Ad* | contains 'Ad' | /Ad/g | string | mmAdkias, mmAd | admin, monica |
*Ad*s* | contains 'Ad' something 's' something | /Ad.*s/g | string | Admins, Ads, fAds | Admin, admins |
?Ad?s* | starts with single any char, followed by 'Ad', another single char, 's', something | /^.Ad.s/g | string | fAdhs, gAdis, hAdtsabc | Admin, admins |
all below since Frankfurt release | |||||
19 | number is 19 | - | number | 19 | 20, 1 |
>19 | number greater than 19 | - | number | 20, 25 | 19, 1 |
>=19 | number greater or equal than 19 | - | number | 20, 3300 | 1, 11 |
<=22 | number smaller or equal than 22 | - | number | 1, 21, 22 | 23, 553 |
<19 | number smaller than 19 | - | number | 18, 3 | 19, 20 |
true | boolean filter | - | boolean | true | false |
false | boolean filter | - | boolean | false | true |
>2019-01-05 | date newer than 5th January 2019 | - | datetime | 2019-01-06T020611Z | 2019-01-05T020611Z |
>2019-01-05T10 | date newer than 5th January 2019 10:59:59 | - | datetime | 2019-01-05T110611Z | 2019-01-05T100611Z |
>2019-01-05T10:05 | date newer than 5th January 2019 10:05:59 | - | datetime | 2019-01-05T100611Z | 2019-01-05T100511Z |
>2019-01-05T10:05:05 | date newer than 5th January 2019 10:05:05 | - | datetime | 2019-01-05T100511Z | 2019-01-05T100500Z |
2019* | date within the year 2019 | - | datetime | 2019-01-05T100511Z, | 2020-01-05T100511Z, |
2019-07* | date within July 2019 | - | datetime | 2019-07-05T100511Z | 2019-01-05T100511Z |
2019-07-1* | date within 10th to 19th of July 2019 | - | datetime | 2019-07-15T100511Z | 2019-07-05T100511Z |
2019-07-15* | date within 15th of July 2019 | - | datetime | 2019-07-15T100511Z | 2019-01-05T100511Z |
2019-07-15T1* | date on 15th of July 2019 between 10:00:00 and 19:59:59 | - | datetime | 2019-07-15T100511Z | 2019-07-15T200511Z |
2019-07-15T16* | date on 15th of July 2019 between 16:00:00 and 16:59:59 | - | datetime | 2019-07-15T160511Z | 2019-07-15T100511Z |
2019-07-15T16:2* | date on 15th of July 2019 between 16:20:00 and 16:29:59 | - | datetime | 2019-07-15T162511Z | 2019-07-15T160511Z |
2019-07-15T16:28* | date on 15th of July 2019 between 16:28:00 and 16:28:59 | - | datetime | 2019-07-15T162811Z | 2019-07-15T162211Z |
2019-07-15T16:28:2* | date on 15th of July 2019 between 16:28:20 and 16:28:29 | - | datetime | 2019-07-15T162821Z | 2019-07-15T162811Z |
2019-07-15T16:28:23.* | date on 15th of July 2019 between 16:28:23.0 and 16:28:23.9 | - | datetime | 2019-07-15T162823.2Z | 2019-07-15T162824.2Z |
2019-07-15T16:28:23 | exactly 2019-07-15T16:28:23 | - | datetime | 2019-07-15T16:28:23Z | 2019-07-15T162811Z |
The rules are described in column “regex” to be tested with Flavor “ECMAScript” regex at this site: https://regex101.com/
Examples for filtered row in table
