{"action":"opened","issue":{"url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/601","repository_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm","labels_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/601/labels{/name}","comments_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/601/comments","events_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/601/events","html_url":"https://github.com/ebean-orm/avaje-ebeanorm/issues/601","id":140639266,"number":601,"title":"Second Nested filterMany not executed but joined","user":{"login":"rbygrave","id":208973,"avatar_url":"https://avatars.githubusercontent.com/u/208973?v=3","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"rbygrave","id":208973,"avatar_url":"https://avatars.githubusercontent.com/u/208973?v=3","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/milestones/81","html_url":"https://github.com/ebean-orm/avaje-ebeanorm/milestones/7.2.1","labels_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/milestones/81/labels","id":1614048,"number":81,"title":"7.2.1","description":"","creator":{"login":"rbygrave","id":208973,"avatar_url":"https://avatars.githubusercontent.com/u/208973?v=3","gravatar_id":"","url":"https://api.github.com/users/rbygrave","html_url":"https://github.com/rbygrave","followers_url":"https://api.github.com/users/rbygrave/followers","following_url":"https://api.github.com/users/rbygrave/following{/other_user}","gists_url":"https://api.github.com/users/rbygrave/gists{/gist_id}","starred_url":"https://api.github.com/users/rbygrave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbygrave/subscriptions","organizations_url":"https://api.github.com/users/rbygrave/orgs","repos_url":"https://api.github.com/users/rbygrave/repos","events_url":"https://api.github.com/users/rbygrave/events{/privacy}","received_events_url":"https://api.github.com/users/rbygrave/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":14,"state":"open","created_at":"2016-03-01T04:36:29Z","updated_at":"2016-03-14T10:51:54Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-03-14T10:51:54Z","updated_at":"2016-03-14T10:51:54Z","closed_at":null,"body":"So in this example\r\n\r\n```java\r\n\r\n    Ebean.find(Customer.class)\r\n        .filterMany(\"contacts\").isNotNull(\"firstName\")\r\n        .filterMany(\"contacts.notes\").istartsWith(\"title\", \"foo\")\r\n        .findList();\r\n```\r\n\r\nThe issue is that the contacts.notes filterMany is sort of 'lost' and contact.notes just gets fetch joined instead.  The expected/correct behavior is the contacts.notes is a separate query with the title startsWith foo expression.\r\n"}}