{"action":"created","issue":{"url":"https://api.github.com/repos/requery/requery/issues/45","repository_url":"https://api.github.com/repos/requery/requery","labels_url":"https://api.github.com/repos/requery/requery/issues/45/labels{/name}","comments_url":"https://api.github.com/repos/requery/requery/issues/45/comments","events_url":"https://api.github.com/repos/requery/requery/issues/45/events","html_url":"https://github.com/requery/requery/issues/45","id":141221327,"number":45,"title":"Add sample project","user":{"login":"hotchemi","id":471318,"avatar_url":"https://avatars.githubusercontent.com/u/471318?v=3","gravatar_id":"","url":"https://api.github.com/users/hotchemi","html_url":"https://github.com/hotchemi","followers_url":"https://api.github.com/users/hotchemi/followers","following_url":"https://api.github.com/users/hotchemi/following{/other_user}","gists_url":"https://api.github.com/users/hotchemi/gists{/gist_id}","starred_url":"https://api.github.com/users/hotchemi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hotchemi/subscriptions","organizations_url":"https://api.github.com/users/hotchemi/orgs","repos_url":"https://api.github.com/users/hotchemi/repos","events_url":"https://api.github.com/users/hotchemi/events{/privacy}","received_events_url":"https://api.github.com/users/hotchemi/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/requery/requery/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-03-16T09:50:33Z","updated_at":"2016-03-19T03:24:08Z","closed_at":null,"body":"Do you have any plan to add sample project which shows sample usage?"},"comment":{"url":"https://api.github.com/repos/requery/requery/issues/comments/198626168","html_url":"https://github.com/requery/requery/issues/45#issuecomment-198626168","issue_url":"https://api.github.com/repos/requery/requery/issues/45","id":198626168,"user":{"login":"npurushe","id":4143434,"avatar_url":"https://avatars.githubusercontent.com/u/4143434?v=3","gravatar_id":"","url":"https://api.github.com/users/npurushe","html_url":"https://github.com/npurushe","followers_url":"https://api.github.com/users/npurushe/followers","following_url":"https://api.github.com/users/npurushe/following{/other_user}","gists_url":"https://api.github.com/users/npurushe/gists{/gist_id}","starred_url":"https://api.github.com/users/npurushe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/npurushe/subscriptions","organizations_url":"https://api.github.com/users/npurushe/orgs","repos_url":"https://api.github.com/users/npurushe/repos","events_url":"https://api.github.com/users/npurushe/events{/privacy}","received_events_url":"https://api.github.com/users/npurushe/received_events","type":"User","site_admin":false},"created_at":"2016-03-19T03:24:08Z","updated_at":"2016-03-19T03:24:08Z","body":"I have added a set of example queries in the [wiki](https://github.com/requery/requery/wiki/Query-examples). For your case because you are quering a foreign key reference that is currently not exposed as a queryable attribute. That should have been documented but it was in progress and the change is now committed https://github.com/requery/requery/commit/92a4fa238610b61e86a91f35505e63f9519bce22. With the change it would be something like:\r\n\r\n`data.select(Pay.class).where(Pay.WORKER.eq(worker)).orderBy(Pay.DATE.desc()).get()`\r\n\r\nIf you have any questions let me know"}}