{"action":"closed","issue":{"url":"https://api.github.com/repos/pvginkel/NHibernate.OData/issues/25","labels_url":"https://api.github.com/repos/pvginkel/NHibernate.OData/issues/25/labels{/name}","comments_url":"https://api.github.com/repos/pvginkel/NHibernate.OData/issues/25/comments","events_url":"https://api.github.com/repos/pvginkel/NHibernate.OData/issues/25/events","html_url":"https://github.com/pvginkel/NHibernate.OData/issues/25","id":119360335,"number":25,"title":"Query is not supported with substringof and 3 or more clauses","user":{"login":"rodrigosendin","id":3009125,"avatar_url":"https://avatars.githubusercontent.com/u/3009125?v=3","gravatar_id":"","url":"https://api.github.com/users/rodrigosendin","html_url":"https://github.com/rodrigosendin","followers_url":"https://api.github.com/users/rodrigosendin/followers","following_url":"https://api.github.com/users/rodrigosendin/following{/other_user}","gists_url":"https://api.github.com/users/rodrigosendin/gists{/gist_id}","starred_url":"https://api.github.com/users/rodrigosendin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rodrigosendin/subscriptions","organizations_url":"https://api.github.com/users/rodrigosendin/orgs","repos_url":"https://api.github.com/users/rodrigosendin/repos","events_url":"https://api.github.com/users/rodrigosendin/events{/privacy}","received_events_url":"https://api.github.com/users/rodrigosendin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-29T13:28:17Z","updated_at":"2015-12-05T14:15:21Z","closed_at":"2015-12-05T14:15:21Z","body":"Hi, \r\n\r\nI'm getting a \"Query is not supported\" exception when I try to make an odata query using substringof and 3 or more clauses. See this sample:\r\n\r\nvar result = session.ODataQuery<Beneficiario>(\"$filter=(DataNascimento eq datetime'1981-03-13T00:00:00' and substringof('Saurin',Nome) and substringof('21906522863',Cpf) and Id eq 55800)\")                            .List<Beneficiario>();\r\n\r\nThe exception is:\r\n\r\nQuery is not supported\r\n   em NHibernate.OData.QueryVisitorBase`1.LogicalExpression(LogicalExpression expression)\r\n   em NHibernate.OData.CriterionVisitor.ComparisonExpression(ComparisonExpression expression)\r\n   em NHibernate.OData.CriterionVisitor.LogicalExpression(LogicalExpression expression)\r\n   em NHibernate.OData.CriterionVisitor.LogicalExpression(LogicalExpression expression)\r\n   em NHibernate.OData.ODataExpression.ProcessFilter(String value)\r\n   em NHibernate.OData.ODataExpression.ProcessQueryStringPart(String key, String value)\r\n   em NHibernate.OData.ODataExpression.ParseQueryString(String queryString)\r\n   em NHibernate.OData.ODataContext.ODataQuery(ISession session, Type persistentClass, String queryString, ODataParserConfiguration configuration)\r\n   em NHibernate.OData.ODataParser.ODataQuery[T](ISession session, String queryString)\r\n   em Ancode.Med.Testes.TesteOData.ConsultaComfiltro() na C:\\TFSAncode\\Ancode.Med\\src\\Ancode.Med\\Ancode.Med.Testes\\TesteOData.cs:linha 76\r\n\r\nThanks\r\n"}}