嵌套条件在 Vtiger Rest Query API 中不起作用
我正在尝试使用 Query API 从 Vtiger 获取匹配的结果集。
这个 API 可以很好地处理普通查询（没有多个 AND/OR 条件），例如： working_query = SELECT * FROM Leads WHERE id = 10x2482688 AND designation = 'SalesMan' order bycreatedtime LIMIT 1;
但是我们希望使用嵌套 AND/OR 来获取结果，并且这些结果将包含括号。 “）” 我们收到诸如 'QUERY_SYNTAX_ERROR', Syntax Error on line 1: token '(' Unexpected
Not_working_query = SELECT * FROM Leads WHERE id = 10x2482688 AND (email = '[电子邮件受保护]' OR designation = 'SalesMan') order bycreatedtime LIMIT 1;
关于如何解决此问题有什么想法吗？
I'm trying to work with Query API to get matched results set from Vtiger.
This API works fine with normal queries (without multiple AND/ OR conditions) like:
working_query = SELECT * FROM Leads WHERE id = 10x2482688 AND designation = 'SalesMan' order by createdtime LIMIT 1;
But we want to get results using nested AND/OR and those will contain parentheses. ")"
and we are getting errors like 'QUERY_SYNTAX_ERROR', Syntax Error on line 1: token '(' Unexpected
Not_working_query = SELECT * FROM Leads WHERE id = 10x2482688 AND (email = '[email protected]' OR designation = 'SalesMan') order by createdtime LIMIT 1;
Any ideas on how we can resolve this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
只需将您的查询更改为
Simply change your query to