Row filter

Unfold Hierarchy number Tags Values

1 Examples

1.1 Number

1.1.1 Is not number

Script	`isNaN(#{stringColumn} - 1)`
Condition	`true`
Maximum	`-1`

1.1.2 Compare

Script	`#{numberColumn1} != 0 \|\| #{numberColumn1} < #{numberColumn2}`
Condition	`true`
Maximum	`-1`

1.1.3 Compare with statistic

Script	`#{numberColumn} < #{numberColumn-Mean}`
Condition	`true`
Maximum	`-1`

1.2 Date

1.2.1 value of date

Script	`if (#{dateColumn} != null) new Date(#{dateColumn}.getTime() else -1;`
Condition	`true`
Maximum	`-1`

1.2.2 Special time

Script	`#{dateColumn} == '2016-05-19 11:34:28'`
Condition	`true`
Maximum	`-1`

1.2.3 Match time

Script	`if (#{dateColumn} != null) #{dateColumn}.startsWith('2016-05-19 09') else undefined;`
Condition	`true`
Maximum	`-1`

1.2.4 Compare time

Script	`if (#{dateColumn} != null) new Date(#{dateColumn}).getTime() > new Date('2016/05/19 09:23:12').getTime() else undefined;`
Condition	`true`
Maximum	`-1`

1.2.5 Format Date

Script

function 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;

Condition

true

Maximum

-1

1.2.6 whether Sunday

Script	`if (#{dateColumn} != null) new Date(#{dateColumn}).getDay() == 0 else undefined;`
Condition	`true`
Maximum	`-1`

1.3 String

1.3.1 string is empty

Script	`#{stringColumn} == ''`
Condition	`true`
Maximum	`-1`

1.3.2 string is not null

Script	`#{stringColumn} != null`
Condition	`true`
Maximum	`-1`

1.3.3 string length

Script	`if ( #{stringColumn} != null ) #{stringColumn}.length else -1`
Condition	`true`
Maximum	`-1`

1.3.4 contain sub-string

Script	`if ( #{stringColumn} != null ) #{stringColumn}.search(/hello/ig) else -1`
Condition	`true`
Maximum	`-1`

1.3.5 Position of sub-string

Script	`if ( #{stringColumn} != null ) #{stringColumn}.indexOf('hello') else -1`
Condition	`true`
Maximum	`-1`

1.3.6 compare strings

Script	`#{stringColumn} === 'hello'`
Condition	`true`
Maximum	`-1`

1.3.7 replace first

Script	`if ( #{stringColumn} != null ) #{stringColumn}.replace("hello", "Hello"); else null`
Condition	`true`
Maximum	`-1`

1.3.8 replace all

Script	`if ( #{stringColumn} != null ) #{stringColumn}.replace(/hello/g, "Hello"); else null`
Condition	`true`
Maximum	`-1`

1.3.9 starts with

Script	`if ( #{stringColumn} != null ) #{stringColumn}.startsWith('Hello') else undefined`
Condition	`true`
Maximum	`-1`

1.3.10 ends with

Script	`if ( #{stringColumn} != null ) #{stringColumn}.endsWith('hello') else undefined`
Condition	`true`
Maximum	`-1`

1.3.11 Special values

Script	`var array = [ 'A', 'B', 'C', 'D' ]; array.includes('#{stringColumn}')`
Condition	`true`
Maximum	`-1`

1.4 Limit Rows

1.4.1 10 rows in front

Condition	`true`
Maximum	`10`