You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@usergrid.apache.org by "Brandon Shelley (JIRA)" <ji...@apache.org> on 2015/08/27 19:40:45 UTC

[jira] [Comment Edited] (USERGRID-951) Update documentation to reflect order of operations

    [ https://issues.apache.org/jira/browse/USERGRID-951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14717135#comment-14717135 ] 

Brandon Shelley edited comment on USERGRID-951 at 8/27/15 5:40 PM:
-------------------------------------------------------------------

AND statements are joined with priority over OR statements in both 1.0 and 2.0. For example:

{code}where name = 'bob' or name = 'joe' and created = 1440697016{code}

breaks down to:

{code}where name = 'bob'
OR
where name = 'joe' and created = 1440697016{code}

To mitigate an issue where you need created to apply on both sides of the OR statement:

{code}where name = 'bob' and created = 1440697016
OR
where name = 'joe' and created = 1440697016{code}

Need to get this added to docs.


was (Author: brandonshelley):
AND statements are joined with priority over OR statements in both 1.0 and 2.0. For example:

{code}where name = 'bob' or name = 'joe' and created = 1440697016{code}

breaks down to:

{code}where name = 'bob'
OR
where name = 'joe' and created = 1440697016{code}

To mitigate an issue where you need created to apply on both sides of the OR statement:

{code}where name = 'bob' and created = 1440697016
OR
where name = 'joe' and created = 1440697016{code}

> Update documentation to reflect order of operations
> ---------------------------------------------------
>
>                 Key: USERGRID-951
>                 URL: https://issues.apache.org/jira/browse/USERGRID-951
>             Project: Usergrid
>          Issue Type: Story
>            Reporter: Jeffrey 
>            Assignee: Brandon Shelley
>
> For example, what is the result of "where A or B and C"?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)