XPath帮助文档
输入“/”快速插入内容
XPath帮助文档
XPath帮助文档
飞书用户82841月6日修改
一，XPath简介
XPath是一种筛选方式，可用于检索、增加限定条件。
二，符号说明
三，样例说明
1.
//m1.t1[f1 >= -1.1 and f2 = 'hu' and (/r1/t2/f3 = '[%currentUserId%]' or f4 = f5)]/f6/f7
等效于
select t1.f6, t1.f7
from t1
inner join t2 on t2.xxx = t1.xxx
where t1.f1 >= -1.1 and t1.f2='hu' and (t2.f3 = 9527 or t1.f4 = t1.f5)
2.
//m1.t1/r1/t2
等效于
select * from t1
inner join t2 on t2.xxx = t1.xxx
3.
//m1.t1[(f1 > 5 and f2 = 'hu') or (f3 != 5 or f4 <= '[%now%]')]
等效于
select * from t1
where (t1.f1 > 5 and t1.f2 = 'hu') or (t1.f3 != 5 or t1.f4 <= '2022-03-16 13:45:11')
四，系统关键字