Below you will find an overview of the supported filter functions and parameters for URL filters.
-
DateTimeRange("YYYY-MM-DDTHH:mm:ss.SSS", "YYYY-MM-DDTHH:mm:ss.SSS", "Europe/Berlin")
-
DateTimeBetween([Input], "YYYY-MM-DDTHH:mm:ss.SSS", "YYYY-MM-DDTHH:mm:ss.SSS", "Europe/Berlin")
-
DateTimeGt([Input], "YYYY-MM-DDTHH:mm:ss.SSS", "Europe/Berlin")
-
DateTimeGte([Input], "YYYY-MM-DDTHH:mm:ss.SSS", "Europe/Berlin")
-
DateTimeLt([Input], "YYYY-MM-DDTHH:mm:ss.SSS", "Europe/Berlin")
-
DateTimeLte([Input], "YYYY-MM-DDTHH:mm:ss.SSS", "Europe/Berlin")
-
TimeRange("11:28", "18:28", "Europe/Berlin")
-
NumberBetween([Input], 10.123, 20.675)
-
NumberGt([Input], 2e-10)
-
NumberGte([Input], 2e+10)
-
NumberLt([Input], 0.12)
-
NumberLte([Input], 13)
-
NumberIn([Input], 12, 13, 15, 17, ...)
-
StringContains([Input], "ABC")
-
StringEq([Input], "ABC")
-
StringIn([Input], "ABC", "BCD", ...)
The parameters labeled "Input" are the value fields, alias names, columns or signal names that can be used as filters. It is not necessary to specify the data source as a parameter, e.g. the name of the HD store or database table.