如何正确查询vTiger CRM API

Question

I got an sql query:

$vtiger->query('*', 'Products', "(productname LIKE '%$name%' OR description LIKE '%$name%') AND cf_1007 = 'Ready'", null, 50, null); 

(using https://github.com/sumocoders/vtiger-api). It has an WHERE clause. How to make it right? (current query throws exception). I need to take all rows where productname or description contains %name% and where cell cf_1007 = "Ready".

UPD: answer from vTiger API (forgot to add it here)

{"success":false,"error":{"code":"QUERY_SYNTAX_ERROR","message":"Syntax Error on line 1: token '(' Unexpected PARENOPEN((), expected one of: COLUMNNAME"}}

Answer 1

There's a syntax error due to the first (.

Try removing it, changing

(A OR B) AND C

for

A AND C OR B AND C