{"action":"created","issue":{"url":"https://api.github.com/repos/restsql/restsql/issues/74","repository_url":"https://api.github.com/repos/restsql/restsql","labels_url":"https://api.github.com/repos/restsql/restsql/issues/74/labels{/name}","comments_url":"https://api.github.com/repos/restsql/restsql/issues/74/comments","events_url":"https://api.github.com/repos/restsql/restsql/issues/74/events","html_url":"https://github.com/restsql/restsql/pull/74","id":166623376,"number":74,"title":"Added negative _LIMIT to select backwards!","user":{"login":"kolchagov","id":7883745,"avatar_url":"https://avatars.githubusercontent.com/u/7883745?v=3","gravatar_id":"","url":"https://api.github.com/users/kolchagov","html_url":"https://github.com/kolchagov","followers_url":"https://api.github.com/users/kolchagov/followers","following_url":"https://api.github.com/users/kolchagov/following{/other_user}","gists_url":"https://api.github.com/users/kolchagov/gists{/gist_id}","starred_url":"https://api.github.com/users/kolchagov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kolchagov/subscriptions","organizations_url":"https://api.github.com/users/kolchagov/orgs","repos_url":"https://api.github.com/users/kolchagov/repos","events_url":"https://api.github.com/users/kolchagov/events{/privacy}","received_events_url":"https://api.github.com/users/kolchagov/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2016-07-20T16:22:10Z","updated_at":"2016-07-31T19:26:50Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/restsql/restsql/pulls/74","html_url":"https://github.com/restsql/restsql/pull/74","diff_url":"https://github.com/restsql/restsql/pull/74.diff","patch_url":"https://github.com/restsql/restsql/pull/74.patch"},"body":"Hi, as I'm using Netbeans, there are many auto-generated config files (I'm not sure if they are really needed, but...). \r\nThe actual change is in  src/org/restsql/core/impl/AbstractSqlBuilder.java\r\nwhen negative _LIMIT parameter is given, the sort order is changed to DESC, so we can query data at the end of the table (for example if we query for a max value of a column)"},"comment":{"url":"https://api.github.com/repos/restsql/restsql/issues/comments/236451418","html_url":"https://github.com/restsql/restsql/pull/74#issuecomment-236451418","issue_url":"https://api.github.com/repos/restsql/restsql/issues/74","id":236451418,"user":{"login":"restsql","id":783722,"avatar_url":"https://avatars.githubusercontent.com/u/783722?v=3","gravatar_id":"","url":"https://api.github.com/users/restsql","html_url":"https://github.com/restsql","followers_url":"https://api.github.com/users/restsql/followers","following_url":"https://api.github.com/users/restsql/following{/other_user}","gists_url":"https://api.github.com/users/restsql/gists{/gist_id}","starred_url":"https://api.github.com/users/restsql/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/restsql/subscriptions","organizations_url":"https://api.github.com/users/restsql/orgs","repos_url":"https://api.github.com/users/restsql/repos","events_url":"https://api.github.com/users/restsql/events{/privacy}","received_events_url":"https://api.github.com/users/restsql/received_events","type":"User","site_admin":false},"created_at":"2016-07-31T19:26:50Z","updated_at":"2016-07-31T19:26:50Z","body":"Oh okay. It's not a MySQL feature. It's a workaround for the missing order by support. Current ordering is always by the PK ascending. \r\n\r\nI think we should consider instead adding first class support for order by to the framework. The http interface could be something like:\r\n\r\n     GET /res/{resourceName}?_orderby={column1,column2,...}&order={ASC,DESC}&...\r\n\r\nThe limit/offset behavior is optionally applied."}}
{"actor":{"display_login":"restsql"}}