{"action":"created","issue":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/88","labels_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/88/labels{/name}","comments_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/88/comments","events_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/88/events","html_url":"https://github.com/Raizlabs/DBFlow/issues/88","id":58278332,"number":88,"title":"Combining AND & OR operations in parentheses ","user":{"login":"faifai21","id":4616968,"avatar_url":"https://avatars.githubusercontent.com/u/4616968?v=3","gravatar_id":"","url":"https://api.github.com/users/faifai21","html_url":"https://github.com/faifai21","followers_url":"https://api.github.com/users/faifai21/followers","following_url":"https://api.github.com/users/faifai21/following{/other_user}","gists_url":"https://api.github.com/users/faifai21/gists{/gist_id}","starred_url":"https://api.github.com/users/faifai21/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/faifai21/subscriptions","organizations_url":"https://api.github.com/users/faifai21/orgs","repos_url":"https://api.github.com/users/faifai21/repos","events_url":"https://api.github.com/users/faifai21/events{/privacy}","received_events_url":"https://api.github.com/users/faifai21/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Raizlabs/DBFlow/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/milestones/3","labels_url":"https://api.github.com/repos/Raizlabs/DBFlow/milestones/3/labels","id":975888,"number":3,"title":"1.6.0","description":null,"creator":{"login":"agrosner","id":2117859,"avatar_url":"https://avatars.githubusercontent.com/u/2117859?v=3","gravatar_id":"","url":"https://api.github.com/users/agrosner","html_url":"https://github.com/agrosner","followers_url":"https://api.github.com/users/agrosner/followers","following_url":"https://api.github.com/users/agrosner/following{/other_user}","gists_url":"https://api.github.com/users/agrosner/gists{/gist_id}","starred_url":"https://api.github.com/users/agrosner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agrosner/subscriptions","organizations_url":"https://api.github.com/users/agrosner/orgs","repos_url":"https://api.github.com/users/agrosner/repos","events_url":"https://api.github.com/users/agrosner/events{/privacy}","received_events_url":"https://api.github.com/users/agrosner/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":0,"state":"open","created_at":"2015-02-11T20:30:24Z","updated_at":"2015-02-19T23:03:42Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-02-19T22:09:56Z","updated_at":"2015-02-19T23:05:55Z","closed_at":null,"body":"I've been trying to execute the following query: SELECT * FROM Table WHERE loc_id = \"21\" AND (first_name LIKE '%adam%' OR last_name LIKE '%adam%').\r\n\r\nI can't seem to find any straight forward way to start a group in the Where class. Since the and() functions take either a Condition or build one from their parameters, I attempted passing in the clause within the parentheses to Condition.column() and setting the operator and value to an empty String, but that just resulted in DBFlow building the clause as an actual condition (by surrounding it in back ticks).\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/comments/75158260","html_url":"https://github.com/Raizlabs/DBFlow/issues/88#issuecomment-75158260","issue_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/88","id":75158260,"user":{"login":"agrosner","id":2117859,"avatar_url":"https://avatars.githubusercontent.com/u/2117859?v=3","gravatar_id":"","url":"https://api.github.com/users/agrosner","html_url":"https://github.com/agrosner","followers_url":"https://api.github.com/users/agrosner/followers","following_url":"https://api.github.com/users/agrosner/following{/other_user}","gists_url":"https://api.github.com/users/agrosner/gists{/gist_id}","starred_url":"https://api.github.com/users/agrosner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agrosner/subscriptions","organizations_url":"https://api.github.com/users/agrosner/orgs","repos_url":"https://api.github.com/users/agrosner/repos","events_url":"https://api.github.com/users/agrosner/events{/privacy}","received_events_url":"https://api.github.com/users/agrosner/received_events","type":"User","site_admin":false},"created_at":"2015-02-19T23:05:55Z","updated_at":"2015-02-19T23:05:55Z","body":"yeah this is sort of an enhancement I was going to do at some point. Not a bad idea. Also possibly add sub-queries too as a feature. Sort of related (http://www.tutorialspoint.com/sqlite/sqlite_sub_queries.htm)"}}