{"action":"created","issue":{"url":"https://api.github.com/repos/mbdavid/LiteDB/issues/191","repository_url":"https://api.github.com/repos/mbdavid/LiteDB","labels_url":"https://api.github.com/repos/mbdavid/LiteDB/issues/191/labels{/name}","comments_url":"https://api.github.com/repos/mbdavid/LiteDB/issues/191/comments","events_url":"https://api.github.com/repos/mbdavid/LiteDB/issues/191/events","html_url":"https://github.com/mbdavid/LiteDB/issues/191","id":164611141,"number":191,"title":"How to include/fetch nested data when using a query?","user":{"login":"MacDennis76","id":6223582,"avatar_url":"https://avatars.githubusercontent.com/u/6223582?v=3","gravatar_id":"","url":"https://api.github.com/users/MacDennis76","html_url":"https://github.com/MacDennis76","followers_url":"https://api.github.com/users/MacDennis76/followers","following_url":"https://api.github.com/users/MacDennis76/following{/other_user}","gists_url":"https://api.github.com/users/MacDennis76/gists{/gist_id}","starred_url":"https://api.github.com/users/MacDennis76/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MacDennis76/subscriptions","organizations_url":"https://api.github.com/users/MacDennis76/orgs","repos_url":"https://api.github.com/users/MacDennis76/repos","events_url":"https://api.github.com/users/MacDennis76/events{/privacy}","received_events_url":"https://api.github.com/users/MacDennis76/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-08T20:34:31Z","updated_at":"2016-07-09T18:14:06Z","closed_at":null,"body":"Hello,\r\n\r\nI am using version v.2.0.0-rc. I am trying to figure out how to fetch a deeply nested structure from the database by using a Find query.\r\n\r\nLet's say this is the structure of the data ..\r\nOrder > OrderLines > Product\r\nHow to retrieve a particular order which includes all orderlines and all product data? Basically, all nested data.\r\n\r\nLooking at the most recent code I can only include one level deep? Like ..\r\nvar orders = collection.Include(x => x.OrderLines).Find(x => (x.OrderNumber == orderno));\r\n\r\nThis fetches all data of the order and the orderlines but not of the product. \r\nIs this possible?\r\n\r\nWith kind regards,\r\nDennis Velthuis\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/mbdavid/LiteDB/issues/comments/231547866","html_url":"https://github.com/mbdavid/LiteDB/issues/191#issuecomment-231547866","issue_url":"https://api.github.com/repos/mbdavid/LiteDB/issues/191","id":231547866,"user":{"login":"mbdavid","id":1137197,"avatar_url":"https://avatars.githubusercontent.com/u/1137197?v=3","gravatar_id":"","url":"https://api.github.com/users/mbdavid","html_url":"https://github.com/mbdavid","followers_url":"https://api.github.com/users/mbdavid/followers","following_url":"https://api.github.com/users/mbdavid/following{/other_user}","gists_url":"https://api.github.com/users/mbdavid/gists{/gist_id}","starred_url":"https://api.github.com/users/mbdavid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbdavid/subscriptions","organizations_url":"https://api.github.com/users/mbdavid/orgs","repos_url":"https://api.github.com/users/mbdavid/repos","events_url":"https://api.github.com/users/mbdavid/events{/privacy}","received_events_url":"https://api.github.com/users/mbdavid/received_events","type":"User","site_admin":false},"created_at":"2016-07-09T18:14:06Z","updated_at":"2016-07-09T18:14:06Z","body":"Hi @MacDennis76, by now it's not possible, but take a look on this solution (i didn't test yet).\r\n\r\nhttps://github.com/mbdavid/LiteDB/issues/149"}}
{"actor":{"display_login":"mbdavid"}}