The table supports a filter mechanism. Activation/Deactivation by symbol "Downside arrow" in right upper corner.
...
Examples for filter rules
matchingmatching (comma seperated) | not |
|---|
matching| 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 (since frankfurt)| 19 | - | number | 19 | 20, 1 |
| >19 | number greater than |
19 (since frankfurt)| 19 | - | number | 20, 25 | 19, 1 |
| >=19 | number greater or equal than 19 |
(since frankfurt) | - | number | 20, 3300 | 1, 11 |
| <=22 | number smaller or equal than 22 |
(since frankfurt) | - | number | 1, 21, 22 | 23, 553 |
| <19 | number smaller than 19 |
(since frankfurt) | - | number | 18, 3 | 19, 20 |
| true | boolean |
filter (since frankfurt)| filter | - | boolean | true | false |
| false | boolean |
filter (since frankfurt)| filter | - | boolean | false | true |
>2019 |
date newer than 2019 | - | datetime | 2020-01T020611Z2019-09-01T020611Z | >2019-01 |
(same for >=,<, <=)
| date newer than 5th January 2019 | - | datetime | 2019- |
0501T020611Z01T020611Z0505T10
(same for >=,<, <=) | date newer than 5th January 2019 10:59:59 | - | datetime | 2019-01- |
06T020611Z05T020611Z| 05T100611Z |
>2019-01-05T10:05
(same for >=,<, <=) | date newer than 5th January 2019 10: |
0000| 59 | - | datetime | 2019-01-05T100611Z | 2019-01- |
05T090611Z05T100505T10:05:05
(same for >=,<, <=) | date newer than 5th January 2019 10:05: |
00| 05 | - | datetime | 2019-01-05T100511Z | 2019-01- |
05T100411Z| 05T100500Z |
| 2019* | date within the year 2019 | - | datetime | 2019-01-05T100511Z,
2019-10-05T100511Z | 2020-01-05T100511Z,
2017-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
...