{"action":"created","issue":{"url":"https://api.github.com/repos/antillas21/ajax-datatables-rails/issues/167","repository_url":"https://api.github.com/repos/antillas21/ajax-datatables-rails","labels_url":"https://api.github.com/repos/antillas21/ajax-datatables-rails/issues/167/labels{/name}","comments_url":"https://api.github.com/repos/antillas21/ajax-datatables-rails/issues/167/comments","events_url":"https://api.github.com/repos/antillas21/ajax-datatables-rails/issues/167/events","html_url":"https://github.com/antillas21/ajax-datatables-rails/issues/167","id":172125955,"number":167,"title":"Unsortable / Unsearchable columns definition","user":{"login":"cdekker","id":1729963,"avatar_url":"https://avatars.githubusercontent.com/u/1729963?v=3","gravatar_id":"","url":"https://api.github.com/users/cdekker","html_url":"https://github.com/cdekker","followers_url":"https://api.github.com/users/cdekker/followers","following_url":"https://api.github.com/users/cdekker/following{/other_user}","gists_url":"https://api.github.com/users/cdekker/gists{/gist_id}","starred_url":"https://api.github.com/users/cdekker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdekker/subscriptions","organizations_url":"https://api.github.com/users/cdekker/orgs","repos_url":"https://api.github.com/users/cdekker/repos","events_url":"https://api.github.com/users/cdekker/events{/privacy}","received_events_url":"https://api.github.com/users/cdekker/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":17,"created_at":"2016-08-19T12:58:48Z","updated_at":"2016-08-24T17:21:11Z","closed_at":"2016-08-22T08:54:35Z","body":"I feel this is quite trivial, but both in the master branch and 0.4.0 branch I cant seem to figure out how to exclude columns from being sortable and/or searchable.\r\n\r\nLets say I have 4 columns: \r\nCity.name, City.status, City.latitude, City.longitude\r\n(`status` is simply an image_tag with a color coded icon)\r\n\r\nI want only the `name` column searchable\r\nI want only the `name`, `latitude` and `longitude` columns sortable\r\n\r\nHow would I do this in both the master branch or 0.4.0 branch? Or is this simply unsupported  functionality?\r\n\r\nCurrently if I click on a column that is not represented in the `@sortable_columns` it will generate an empty `ORDER BY` clause resulting in a MySQL syntax error."},"comment":{"url":"https://api.github.com/repos/antillas21/ajax-datatables-rails/issues/comments/242143161","html_url":"https://github.com/antillas21/ajax-datatables-rails/issues/167#issuecomment-242143161","issue_url":"https://api.github.com/repos/antillas21/ajax-datatables-rails/issues/167","id":242143161,"user":{"login":"ajahongir","id":625014,"avatar_url":"https://avatars.githubusercontent.com/u/625014?v=3","gravatar_id":"","url":"https://api.github.com/users/ajahongir","html_url":"https://github.com/ajahongir","followers_url":"https://api.github.com/users/ajahongir/followers","following_url":"https://api.github.com/users/ajahongir/following{/other_user}","gists_url":"https://api.github.com/users/ajahongir/gists{/gist_id}","starred_url":"https://api.github.com/users/ajahongir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajahongir/subscriptions","organizations_url":"https://api.github.com/users/ajahongir/orgs","repos_url":"https://api.github.com/users/ajahongir/repos","events_url":"https://api.github.com/users/ajahongir/events{/privacy}","received_events_url":"https://api.github.com/users/ajahongir/received_events","type":"User","site_admin":false},"created_at":"2016-08-24T17:21:11Z","updated_at":"2016-08-24T17:21:11Z","body":">options[:columns] is undefined. (It might be helpful if columns method checked for the existence before using.)\r\n\r\ncan you show your params(which coming from datatable.js)? I gues you have problem with defining Datatable.js. May be because in how-to I used coffeescript. btw you can compare your params and params in how-to."}}
{"actor":{"display_login":"ajahongir"}}