[Vtigercrm-developers] server api vtws query parenthesis?

[nilay khatri]

I don't think  grouped where clauses are supported.

On Mon, Apr 6, 2020 at 2:50 PM Alan Lord <alanslists at gmail.com> wrote:

> I need to use vtws_query but when I include parenthesis like this I get
> an error:
>
>          $query = "SELECT id, name, status, assigned_user_id
>                    FROM LSModule
>                    WHERE (status = 'Active' OR status = 'Development')
>                    AND tgt_module = '".$moduleName."';";
>
>
>
> > Mon Apr  6 09:08:59 2020,529 [28641] DEBUG VT - Syntax Error on line 1:
> token '(' Unexpected PARENOPEN((), expected one of: COLUMNNAME
>
> If I remove the parenthesis the query runs but I am not then sure if the
> result as actually what I want, e.g. how are the OR and AND clauses
> interpreted?
>
> Cheers
>
> Al
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200406/81ce8187/attachment.html>