{"action":"opened","issue":{"url":"https://api.github.com/repos/marcelgwerder/laravel-api-handler/issues/24","repository_url":"https://api.github.com/repos/marcelgwerder/laravel-api-handler","labels_url":"https://api.github.com/repos/marcelgwerder/laravel-api-handler/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/marcelgwerder/laravel-api-handler/issues/24/comments","events_url":"https://api.github.com/repos/marcelgwerder/laravel-api-handler/issues/24/events","html_url":"https://github.com/marcelgwerder/laravel-api-handler/issues/24","id":164246959,"number":24,"title":"Predefined filter partially not working ?","user":{"login":"baumelt","id":20333818,"avatar_url":"https://avatars.githubusercontent.com/u/20333818?v=3","gravatar_id":"","url":"https://api.github.com/users/baumelt","html_url":"https://github.com/baumelt","followers_url":"https://api.github.com/users/baumelt/followers","following_url":"https://api.github.com/users/baumelt/following{/other_user}","gists_url":"https://api.github.com/users/baumelt/gists{/gist_id}","starred_url":"https://api.github.com/users/baumelt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/baumelt/subscriptions","organizations_url":"https://api.github.com/users/baumelt/orgs","repos_url":"https://api.github.com/users/baumelt/repos","events_url":"https://api.github.com/users/baumelt/events{/privacy}","received_events_url":"https://api.github.com/users/baumelt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-07T07:33:14Z","updated_at":"2016-07-07T07:33:14Z","closed_at":null,"body":"Hey there.\r\nI'm new to Laravel (5.1) and the whole plugin stuff and would appreciate a little help. :)\r\n\r\nFollowing the instructions i got the ApiHandler to work with regular parameters and its awesome, but some of the predefined functions throw sql erros since they seem to be interpreted as table columns.\r\n\r\nSpecifically `_sort`, `_with`, `_offset` don't seem to work, while `_limit` and `_q` for example work as intended.\r\nI didn't change anything in the 'config/apihandler.php', prefix is still '_' and i added `@Relation` annotations to the needed relation as described. Do i have to register these params anywhere?\r\n\r\nError when using sort: `/api/posts?_sort=name`\r\n```\r\nQueryException in Connection.php line 664:\r\nSQLSTATE[42S22]: Column not found: Unknown column '_sort' in 'where clause' (SQL: select * from `posts` where `posts`.`deleted_at` is null and `_sort` = name order by `name` asc)\r\n```\r\n\r\nError when using sort: `/api/posts?_with=name`\r\n```\r\nQueryException in Connection.php line 664:\r\nSQLSTATE[42S22]: Column not found: Unknown column '_with' in 'where clause' (SQL: select * from `posts` where `posts`.`deleted_at` is null and `_with` = user)\r\n```\r\n\r\nAny ideas what i am missing, or where to look for the source of failure would be highly appreciated! :)\r\n"}}
{"actor":{"display_login":"baumelt"}}