{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5451","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5451/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5451/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5451/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5451","id":121525933,"number":5451,"title":"Filtering on edge property returns NO results","user":{"login":"grachit","id":3464075,"avatar_url":"https://avatars.githubusercontent.com/u/3464075?v=3","gravatar_id":"","url":"https://api.github.com/users/grachit","html_url":"https://github.com/grachit","followers_url":"https://api.github.com/users/grachit/followers","following_url":"https://api.github.com/users/grachit/following{/other_user}","gists_url":"https://api.github.com/users/grachit/gists{/gist_id}","starred_url":"https://api.github.com/users/grachit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grachit/subscriptions","organizations_url":"https://api.github.com/users/grachit/orgs","repos_url":"https://api.github.com/users/grachit/repos","events_url":"https://api.github.com/users/grachit/events{/privacy}","received_events_url":"https://api.github.com/users/grachit/received_events","type":"User","site_admin":false},"labels":[],"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":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.1.x%20(next%20hotfix)","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64/labels","id":1282180,"number":64,"title":"2.1.x (next hotfix)","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":149,"closed_issues":1,"state":"open","created_at":"2015-08-31T15:18:49Z","updated_at":"2015-12-11T10:57:25Z","due_on":null,"closed_at":null},"comments":6,"created_at":"2015-12-10T16:31:49Z","updated_at":"2015-12-11T16:39:18Z","closed_at":null,"body":"using orient db 2.1.6\n\nRunning following query returns no result:\n```sql\nselect expand(out(\"RUNS_ON\").in(\"EXECUTED_ON\")[JobSubmitted between '2015-12-09 00:00:00' and '2015-12-09 23:59:59']) from JOBS WHERE JobID = '3'\n```\n\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/163985595","html_url":"https://github.com/orientechnologies/orientdb/issues/5451#issuecomment-163985595","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5451","id":163985595,"user":{"login":"grachit","id":3464075,"avatar_url":"https://avatars.githubusercontent.com/u/3464075?v=3","gravatar_id":"","url":"https://api.github.com/users/grachit","html_url":"https://github.com/grachit","followers_url":"https://api.github.com/users/grachit/followers","following_url":"https://api.github.com/users/grachit/following{/other_user}","gists_url":"https://api.github.com/users/grachit/gists{/gist_id}","starred_url":"https://api.github.com/users/grachit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grachit/subscriptions","organizations_url":"https://api.github.com/users/grachit/orgs","repos_url":"https://api.github.com/users/grachit/repos","events_url":"https://api.github.com/users/grachit/events{/privacy}","received_events_url":"https://api.github.com/users/grachit/received_events","type":"User","site_admin":false},"created_at":"2015-12-11T16:39:18Z","updated_at":"2015-12-11T16:39:18Z","body":"RUNS_ON is a edge running out from JOBS to another vertex (Lets say A). A has in edge called EXECUTED_ON. and this in edge has property called JobSubmitted.\r\n\r\nwhat's the difference between in() and inE()?\r\n\r\nIt looks like between  or > do not work.\r\n\r\nonly = is working:\r\nselect expand(out(\"RUNS_ON\").inE(\"EXECUTED_ON\")[JobSubmitted = '2015-12-09 01:54:47.667'  ].outV()) from JOBS WHERE JobID = '3'\r\n"}}