{"action":"closed","issue":{"url":"https://api.github.com/repos/raymanrt/orientqb/issues/1","labels_url":"https://api.github.com/repos/raymanrt/orientqb/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/raymanrt/orientqb/issues/1/comments","events_url":"https://api.github.com/repos/raymanrt/orientqb/issues/1/events","html_url":"https://github.com/raymanrt/orientqb/issues/1","id":62698521,"number":1,"title":"not function is not supported","user":{"login":"wouterv","id":616997,"avatar_url":"https://avatars.githubusercontent.com/u/616997?v=3","gravatar_id":"","url":"https://api.github.com/users/wouterv","html_url":"https://github.com/wouterv","followers_url":"https://api.github.com/users/wouterv/followers","following_url":"https://api.github.com/users/wouterv/following{/other_user}","gists_url":"https://api.github.com/users/wouterv/gists{/gist_id}","starred_url":"https://api.github.com/users/wouterv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wouterv/subscriptions","organizations_url":"https://api.github.com/users/wouterv/orgs","repos_url":"https://api.github.com/users/wouterv/repos","events_url":"https://api.github.com/users/wouterv/events{/privacy}","received_events_url":"https://api.github.com/users/wouterv/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"raymanrt","id":894308,"avatar_url":"https://avatars.githubusercontent.com/u/894308?v=3","gravatar_id":"","url":"https://api.github.com/users/raymanrt","html_url":"https://github.com/raymanrt","followers_url":"https://api.github.com/users/raymanrt/followers","following_url":"https://api.github.com/users/raymanrt/following{/other_user}","gists_url":"https://api.github.com/users/raymanrt/gists{/gist_id}","starred_url":"https://api.github.com/users/raymanrt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raymanrt/subscriptions","organizations_url":"https://api.github.com/users/raymanrt/orgs","repos_url":"https://api.github.com/users/raymanrt/repos","events_url":"https://api.github.com/users/raymanrt/events{/privacy}","received_events_url":"https://api.github.com/users/raymanrt/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-03-18T13:48:57Z","updated_at":"2015-04-07T21:04:20Z","closed_at":"2015-04-07T21:04:20Z","body":"The not() function implementation does not exist in orientdb. There is a keyword NOT that can be used, but looks like that it isnt implemented.\r\n\r\nWhen you try to use it using Clause.not(..) you get:\r\n\r\nCaused by: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #0: No function with name 'not', available names are : [outv,percentile,ifnull,both,count,last,set,traversedvertex,sum,bothv,date,shortestpath,mode,distinct,distance,document,if,gremlin,map,bothe,avg,dijkstra,min,coalesce,encode,max,traversedelement,eval,ine,list,variance,label,format,in,difference,median,decode,unionall,sysdate,intersect,inv,stddev,uuid,traversededge,first,oute,out]"}}