{"action":"closed","issue":{"url":"https://api.github.com/repos/Stuart-campbell/RushOrm/issues/61","labels_url":"https://api.github.com/repos/Stuart-campbell/RushOrm/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/Stuart-campbell/RushOrm/issues/61/comments","events_url":"https://api.github.com/repos/Stuart-campbell/RushOrm/issues/61/events","html_url":"https://github.com/Stuart-campbell/RushOrm/issues/61","id":96932502,"number":61,"title":"Return rows from a child table that aren't connected to a parent?","user":{"login":"ggunders","id":13426442,"avatar_url":"https://avatars.githubusercontent.com/u/13426442?v=3","gravatar_id":"","url":"https://api.github.com/users/ggunders","html_url":"https://github.com/ggunders","followers_url":"https://api.github.com/users/ggunders/followers","following_url":"https://api.github.com/users/ggunders/following{/other_user}","gists_url":"https://api.github.com/users/ggunders/gists{/gist_id}","starred_url":"https://api.github.com/users/ggunders/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ggunders/subscriptions","organizations_url":"https://api.github.com/users/ggunders/orgs","repos_url":"https://api.github.com/users/ggunders/repos","events_url":"https://api.github.com/users/ggunders/events{/privacy}","received_events_url":"https://api.github.com/users/ggunders/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2015-07-24T00:21:08Z","updated_at":"2015-08-04T20:10:18Z","closed_at":"2015-08-04T20:10:18Z","body":"Lets say i have a data model like this:\r\n\r\n    public class woman{\r\n    private String name;\r\n    private Breast left_breast;\r\n    private Breast right_breast;\r\n    ... more (_id), etc\r\n    }\r\n\r\n    public Breast{\r\n    private String size;\r\n    private String Manufacturer;\r\n    private String fillType;\r\n    .... more (_id), etc\r\n    }\r\n\r\nThe server feeds the app women with breasts, where woman and breasts have a unique server ID(not shown). in some parts of the app, i want to show the woman with the correct breasts. but in another part of the app i want to just show breasts. \r\n\r\nbreasts are child elements of women, but are also loaded independently from the server so that all the breast types are viewable on the app.\r\n\r\nwhen i do RushSearch.find(Breast.class) i get lots of duplicates because breasts are loaded by the parent and seperately from the server sync service.\r\n\r\nhow can i just get a unique list of breasts, is there a way to do a RushSearch().whereParentless() - something that gives me all the breasts that arent connected to a woman/parent? maybe i want a unique android spinner of all the breast types.\r\n\r\nor should i be loading the breasts table first, then load the woman table and do a lookup on every woman object that comes in from the network service and find the breast child element first, assign it to the woman object and save it? \r\n\r\nif two women have the exact same breasts, should they both be connected to the same child element or should i be creating duplicate breast child elements.\r\n\r\nbased on the response to this post, ill get into adding a Man class with the need for those Breast child element.  - thx Kardashians\r\n\r\n"}}