{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5608","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5608/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5608/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5608/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5608","id":127478323,"number":5608,"title":"Selecting all vertices connected by and edge  to another specific list of vertices","user":{"login":"shyamchandranmec","id":4659735,"avatar_url":"https://avatars.githubusercontent.com/u/4659735?v=3","gravatar_id":"","url":"https://api.github.com/users/shyamchandranmec","html_url":"https://github.com/shyamchandranmec","followers_url":"https://api.github.com/users/shyamchandranmec/followers","following_url":"https://api.github.com/users/shyamchandranmec/following{/other_user}","gists_url":"https://api.github.com/users/shyamchandranmec/gists{/gist_id}","starred_url":"https://api.github.com/users/shyamchandranmec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shyamchandranmec/subscriptions","organizations_url":"https://api.github.com/users/shyamchandranmec/orgs","repos_url":"https://api.github.com/users/shyamchandranmec/repos","events_url":"https://api.github.com/users/shyamchandranmec/events{/privacy}","received_events_url":"https://api.github.com/users/shyamchandranmec/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2016-01-19T16:01:02Z","updated_at":"2016-01-21T14:03:11Z","closed_at":null,"body":"select expand( in('BELONGS_TO') ) from\r\n(select expand(out('follows'))  from User where @rid = #13:0 )\r\n\r\nThis query returns posts from all pages followed by a user\r\nUser ->(follows)->Page\r\nPost->(belongs_to)Page\r\n\r\neach post falls-into a category as well\r\n\r\nI need to filter the same output based on multiple categories.\r\nsomething like this\r\n\r\nselect expand( in('BELONGS_TO') AND OUT(\"FALLS_INTO\") in [\"#32:0\",\"#32:1] ) from\r\n(select expand(out('follows'))  from User where @rid = #13:0 )"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/173578096","html_url":"https://github.com/orientechnologies/orientdb/issues/5608#issuecomment-173578096","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5608","id":173578096,"user":{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false},"created_at":"2016-01-21T14:03:10Z","updated_at":"2016-01-21T14:03:10Z","body":"Hi @shyamchandranmec \n\nI think the right query should be something like:\n\n```\n\nselect expand(out('BELONGS_TO')) \nfrom (\n    select expand(out('follows')) from User where @rid = #13:0 \n) WHERE\nOUT(\"FALLS_INTO\") in [#32:0, #32:1] \n```\n\nThanks\n\nLuigi"}}