{"action":"closed","issue":{"url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/211","labels_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/211/labels{/name}","comments_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/211/comments","events_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/211/events","html_url":"https://github.com/aspnetboilerplate/aspnetboilerplate/issues/211","id":48911921,"number":211,"title":"ABP.Zero: IRepository<AbpUser> too restrictive","user":{"login":"johnwmcintosh","id":4561377,"avatar_url":"https://avatars.githubusercontent.com/u/4561377?v=3","gravatar_id":"","url":"https://api.github.com/users/johnwmcintosh","html_url":"https://github.com/johnwmcintosh","followers_url":"https://api.github.com/users/johnwmcintosh/followers","following_url":"https://api.github.com/users/johnwmcintosh/following{/other_user}","gists_url":"https://api.github.com/users/johnwmcintosh/gists{/gist_id}","starred_url":"https://api.github.com/users/johnwmcintosh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnwmcintosh/subscriptions","organizations_url":"https://api.github.com/users/johnwmcintosh/orgs","repos_url":"https://api.github.com/users/johnwmcintosh/repos","events_url":"https://api.github.com/users/johnwmcintosh/events{/privacy}","received_events_url":"https://api.github.com/users/johnwmcintosh/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/labels/question","name":"question","color":"bbbbbb"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2014-11-15T15:26:04Z","updated_at":"2015-03-02T17:53:03Z","closed_at":"2015-03-02T17:53:03Z","body":"When calling GetAll(), I noticed that **WHERE [Var_3].[IsDeleted] = 0** is automatically appended to the query sent to [dbo].[AbpUsers]. This means I can't write any query against the repository that will return the \"deleted\" users. I would rather control that condition myself.\r\n\r\nHere's why: Until ABP.Zero supports an Role by Organization notion, I have to maintain a parallel User table that I keep in sync with AbpUsers. My User table has navigation properties to my Organization and Role tables. My system, like ABP.Zero, uses soft-deletes. But if a user is reactivated in my user table, I have to also \"undelete\" it from AbpUsers."}}