{"action":"created","issue":{"url":"https://api.github.com/repos/typeorm/typeorm/issues/3715","repository_url":"https://api.github.com/repos/typeorm/typeorm","labels_url":"https://api.github.com/repos/typeorm/typeorm/issues/3715/labels{/name}","comments_url":"https://api.github.com/repos/typeorm/typeorm/issues/3715/comments","events_url":"https://api.github.com/repos/typeorm/typeorm/issues/3715/events","html_url":"https://github.com/typeorm/typeorm/issues/3715","id":414455695,"node_id":"MDU6SXNzdWU0MTQ0NTU2OTU=","number":3715,"title":"queryBuilder: missing results when using leftJoinAndMapOne","user":{"login":"cvh23","id":31141078,"node_id":"MDQ6VXNlcjMxMTQxMDc4","avatar_url":"https://avatars1.githubusercontent.com/u/31141078?v=4","gravatar_id":"","url":"https://api.github.com/users/cvh23","html_url":"https://github.com/cvh23","followers_url":"https://api.github.com/users/cvh23/followers","following_url":"https://api.github.com/users/cvh23/following{/other_user}","gists_url":"https://api.github.com/users/cvh23/gists{/gist_id}","starred_url":"https://api.github.com/users/cvh23/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cvh23/subscriptions","organizations_url":"https://api.github.com/users/cvh23/orgs","repos_url":"https://api.github.com/users/cvh23/repos","events_url":"https://api.github.com/users/cvh23/events{/privacy}","received_events_url":"https://api.github.com/users/cvh23/received_events","type":"User","site_admin":false},"labels":[{"id":489019544,"node_id":"MDU6TGFiZWw0ODkwMTk1NDQ=","url":"https://api.github.com/repos/typeorm/typeorm/labels/needs%20more%20info","name":"needs more info","color":"bfd4f2","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-02-26T06:42:06Z","updated_at":"2019-04-20T22:44:45Z","closed_at":"2019-04-20T22:44:45Z","author_association":"NONE","body":"**Issue type:**\r\n\r\n[ ] question\r\n[] bug report\r\n[ ] feature request\r\n[X] documentation issue\r\n\r\n**Database system/driver:**\r\n\r\n[ ] `cordova`\r\n[ ] `mongodb`\r\n[ ] `mssql`\r\n[ ] `mysql` / `mariadb`\r\n[ ] `oracle`\r\n[X] `postgres`\r\n[ ] `sqlite`\r\n[ ] `sqljs`\r\n[ ] `react-native`\r\n[ ] `expo`\r\n\r\n**TypeORM version:**\r\n\r\n[ ] `latest`\r\n[ ] `@next`\r\n[X] `0.2.9`\r\n\r\n**Steps to reproduce or a small repository showing the problem:**\r\n\r\n```ts\r\n const qb = this.communicationListMemberRepository\r\n      .createQueryBuilder('communicationListMember')\r\n      .innerJoin('communicationListMember.communicationList', 'communicationList')\r\n      .leftJoinAndMapOne('communicationListMember.searchContact', qb2 => {\r\n        return this.buildSearchQuery(qb2, this.queryParams);\r\n      }, 'searchContact', '\"searchContact\".id = communicationListMember.contact.id');\r\n```\r\nThis is a mailing list subscriber table (communication list subscriber table) which join mailing list (communication list) table and then there should be a left join, from a dynamically generated query on contact data. The SQL generated by TypeORM is okay (I've tested it in postgres console), but the result of the left join sub query *searchContact* is not provided in the result object. Do you have any hints? Or more complex examples than in the docs?\r\n"},"comment":{"url":"https://api.github.com/repos/typeorm/typeorm/issues/comments/485189002","html_url":"https://github.com/typeorm/typeorm/issues/3715#issuecomment-485189002","issue_url":"https://api.github.com/repos/typeorm/typeorm/issues/3715","id":485189002,"node_id":"MDEyOklzc3VlQ29tbWVudDQ4NTE4OTAwMg==","user":{"login":"Kononnable","id":9082099,"node_id":"MDQ6VXNlcjkwODIwOTk=","avatar_url":"https://avatars2.githubusercontent.com/u/9082099?v=4","gravatar_id":"","url":"https://api.github.com/users/Kononnable","html_url":"https://github.com/Kononnable","followers_url":"https://api.github.com/users/Kononnable/followers","following_url":"https://api.github.com/users/Kononnable/following{/other_user}","gists_url":"https://api.github.com/users/Kononnable/gists{/gist_id}","starred_url":"https://api.github.com/users/Kononnable/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kononnable/subscriptions","organizations_url":"https://api.github.com/users/Kononnable/orgs","repos_url":"https://api.github.com/users/Kononnable/repos","events_url":"https://api.github.com/users/Kononnable/events{/privacy}","received_events_url":"https://api.github.com/users/Kononnable/received_events","type":"User","site_admin":false},"created_at":"2019-04-20T22:44:45Z","updated_at":"2019-04-20T22:44:45Z","author_association":"MEMBER","body":"Closing as no response from the author."}}
{"actor":{"display_login":"Kononnable"}}