Row expression

Unfold Hierarchy number Tags Values
      Row expression
        1  Row filter
            1.1  Examples
                1.1.1  Number
                    1.1.1.1  Is not number
Row expressionisNaN(#{stringColumn} - 1)
                    1.1.1.2  Compare
Row expression#{numberColumn1} != 0 || #{numberColumn1} < #{numberColumn2}
                    1.1.1.3  Compare with statistic
Row expression#{numberColumn} < #{numberColumn-Mean}
                1.1.2  Date
                    1.1.2.1  value of date
Row expressionif (#{dateColumn} != null) new Date(#{dateColumn}.getTime() else -1;
                    1.1.2.2  Special time
Row expression#{dateColumn} == '2016-05-19 11:34:28'
                    1.1.2.3  Match time
Row expressionif (#{dateColumn} != null) #{dateColumn}.startsWith('2016-05-19 09') else undefined;
                    1.1.2.4  Compare time
Row expressionif (#{dateColumn} != null) new Date(#{dateColumn}).getTime() > new Date('2016/05/19 09:23:12').getTime() else undefined;
                    1.1.2.5  Format Date
Row expressionfunction formatDate(date) { var y = date.getFullYear(); var m = date.getMonth() + 1; m = m < 10 ? ('0' + m) : m; var d = date.getDate(); d = d < 10 ? ('0' + d) : d; var h =date.getHours(); h = h < 10 ? ('0' + h) : h; var M =date.getMinutes(); M = M < 10 ? ('0' + M) : M; var s =date.getSeconds(); s = s < 10 ? ('0' + s) : s; return y + '-' + m + '-' + d + ' ' + h + ':' + M + ':' + s; } if (#{dateColumn} != null) formatDate(new Date(#{dateColumn})); else null;
                    1.1.2.6  whether Sunday
Row expressionif (#{dateColumn} != null) new Date(#{dateColumn}).getDay() == 0 else undefined;
                1.1.3  String
                    1.1.3.1  string is empty
Row expression#{stringColumn} == ''
                    1.1.3.2  string is not null
Row expression#{stringColumn} != null
                    1.1.3.3  string length
Row expressionif ( #{stringColumn} != null ) #{stringColumn}.length else -1
                    1.1.3.4  contain sub-string
Row expressionif ( #{stringColumn} != null ) #{stringColumn}.search(/hello/ig) else -1
                    1.1.3.5  Position of sub-string
Row expressionif ( #{stringColumn} != null ) #{stringColumn}.indexOf('hello') else -1
                    1.1.3.6  compare strings
Row expression#{stringColumn} === 'hello'
                    1.1.3.7  replace first
Row expressionif ( #{stringColumn} != null ) #{stringColumn}.replace("hello", "Hello"); else null
                    1.1.3.8  replace all
Row expressionif ( #{stringColumn} != null ) #{stringColumn}.replace(/hello/g, "Hello"); else null
                    1.1.3.9  starts with
Row expressionif ( #{stringColumn} != null ) #{stringColumn}.startsWith('Hello') else undefined
                    1.1.3.10  ends with
Row expressionif ( #{stringColumn} != null ) #{stringColumn}.endsWith('hello') else undefined
                    1.1.3.11  Special values
Row expressionvar array = [ 'A', 'B', 'C', 'D' ]; array.includes('#{stringColumn}')