1.1 Value is null or empty
| Script |
'#{Column1}' == ''
|
| Condition |
true
|
| Maximum |
-1
|
1.2 Value is not null nor empty
| Script |
'#{Column1}'.length > 0
|
| Condition |
true
|
| Maximum |
-1
|
1.3 10 rows in front
| Condition |
true
|
| Maximum |
10
|
1.4.1 Is number
| Script |
Math.abs(#{Column1}) >= 0
|
| Condition |
true
|
| Maximum |
-1
|
1.4.2 Compare
| Script |
#{Column1} != 0 || #{Column1} < #{Column2}
|
| Condition |
true
|
| Maximum |
-1
|
1.4.3 Compare with statistic
| Script |
#{Column1} < #{Column1-Mean}
|
| Condition |
true
|
| Maximum |
-1
|
1.5.1 Special time
| Script |
'#{Date}' == '2016-05-19 11:34:28'
|
| Condition |
true
|
| Maximum |
-1
|
1.5.2 Match time
| Script |
'#{Date}'.startsWith('2016-05-19 09')
|
| Condition |
true
|
| Maximum |
-1
|
1.5.3 Compare time
| Script |
new Date('#{Date}'.replace(/-/g,'/')).getTime() > new Date('2016/05/19 09:23:12').getTime()
|
| Condition |
true
|
| Maximum |
-1
|
1.6.1 Length
| Script |
'#{Column1}'.length > 3
|
| Condition |
true
|
| Maximum |
-1
|
1.6.2 Match
| Script |
'#{Column1}'.search(/Hello/ig) >= 0
|
| Condition |
true
|
| Maximum |
-1
|
1.6.3 Position of sub-string
| Script |
'#{Column1}'.indexOf('Hello') == 3
|
| Condition |
true
|
| Maximum |
-1
|
1.6.4 Special values
| Script |
var array = [ 'A', 'B', 'C', 'D' ];
array.includes('#{Column1}')
|
| Condition |
true
|
| Maximum |
-1
|