{"action":"opened","issue":{"url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/485","labels_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/485/labels{/name}","comments_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/485/comments","events_url":"https://api.github.com/repos/ebean-orm/avaje-ebeanorm/issues/485/events","html_url":"https://github.com/ebean-orm/avaje-ebeanorm/issues/485","id":120850378,"number":485,"title":"@SoftDelete with join to nullable relation ... can filter out row from result","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":null,"comments":0,"created_at":"2015-12-07T19:38:17Z","updated_at":"2015-12-07T19:38:17Z","closed_at":null,"body":"```java\r\n\r\n@Entity\r\npublic class Tenant {\r\n\r\n   @Id\r\n   private UUID id;\r\n\r\n   @ManyToOne\r\n   private Tenant parent;\r\n\r\n   @Column\r\n   private String name;\r\n\r\n   ...\r\n\r\n   @SoftDelete\r\n   private boolean deleted;\r\n\r\n   @Version\r\n   private Long version;\r\n\r\n    ...\r\n}\r\n\r\n```\r\n\r\n\r\n```sql\r\n\r\nselect t0.id c0, t0.name c2, t0.deleted c14, t0.version c15\r\nfrom tenants t0 \r\n  left outer join tenants t2 on t2.id = t0.parent_id  \r\nwhere t0.id = '4b5e5c55-7aea-48e4-9287-d63b36457c51' and t0.deleted=0 and t2.deleted=0 order by t0.id; \r\n\r\n```"}}