概述
函数listContains()
判断一个列表中是否包含某个元素。
参数:listContains(<list>, <any>)
<list>
:列表(list类型)<any>
:元素值(所有类型)
返回值:
- 判断结果,1(是)或0(否)
一般用法
本例使用异源别名计算:
uncollect [[1,2,3],[2,4,5]] as a
uncollect [3,4] as b
return table(toString(a), b, listContains(a, b))
| toString(a) | b | listContains(a, b) |
|-------------|---|--------------------|
| [1,2,3] | 3 | 1 |
| [2,4,5] | 4 | 1 |
本例将异源别名做笛卡尔积组合后计算:
uncollect [[1,2,3],[2,4,5]] as a
uncollect [3,4] as b
with listContains(a, b) as c
return table(toString(a), b, c)
| toString(a) | b | c |
|-------------|---|---|
| [1,2,3] | 3 | 1 |
| [1,2,3] | 4 | 0 |
| [2,4,5] | 3 | 0 |
| [2,4,5] | 4 | 1 |