{"action":"closed","issue":{"url":"https://api.github.com/repos/strongloop/loopback-connector-mongodb/issues/107","labels_url":"https://api.github.com/repos/strongloop/loopback-connector-mongodb/issues/107/labels{/name}","comments_url":"https://api.github.com/repos/strongloop/loopback-connector-mongodb/issues/107/comments","events_url":"https://api.github.com/repos/strongloop/loopback-connector-mongodb/issues/107/events","html_url":"https://github.com/strongloop/loopback-connector-mongodb/issues/107","id":60364782,"number":107,"title":"Depth issue when using complex queries with mongo db operators.","user":{"login":"shyambalu-sellaco","id":10223787,"avatar_url":"https://avatars.githubusercontent.com/u/10223787?v=3","gravatar_id":"","url":"https://api.github.com/users/shyambalu-sellaco","html_url":"https://github.com/shyambalu-sellaco","followers_url":"https://api.github.com/users/shyambalu-sellaco/followers","following_url":"https://api.github.com/users/shyambalu-sellaco/following{/other_user}","gists_url":"https://api.github.com/users/shyambalu-sellaco/gists{/gist_id}","starred_url":"https://api.github.com/users/shyambalu-sellaco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shyambalu-sellaco/subscriptions","organizations_url":"https://api.github.com/users/shyambalu-sellaco/orgs","repos_url":"https://api.github.com/users/shyambalu-sellaco/repos","events_url":"https://api.github.com/users/shyambalu-sellaco/events{/privacy}","received_events_url":"https://api.github.com/users/shyambalu-sellaco/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-09T15:55:36Z","updated_at":"2015-03-09T22:58:34Z","closed_at":"2015-03-09T22:58:34Z","body":"Range queries are not supported, have to do more verbose. But in general more than one level of depth is not supported for complex queries, using mongodb operators.\r\n\r\n```\r\n{\"where\":{\"financials.revenue\":{\"gt\":60,\"lt\":245}}\r\n```\r\nOnly the `gt` arrives at the database. It has to be translated to \r\n\r\n```\r\n{\"where\":{\"and\": [{\"financials.revenue\":{\"gt\":60}}, {\"financials.revenue\":{\"lt\":245}}]}}\r\n```"}}