{"action":"created","issue":{"url":"https://api.github.com/repos/IgnitedDatatables/Ignited-Datatables/issues/103","labels_url":"https://api.github.com/repos/IgnitedDatatables/Ignited-Datatables/issues/103/labels{/name}","comments_url":"https://api.github.com/repos/IgnitedDatatables/Ignited-Datatables/issues/103/comments","events_url":"https://api.github.com/repos/IgnitedDatatables/Ignited-Datatables/issues/103/events","html_url":"https://github.com/IgnitedDatatables/Ignited-Datatables/issues/103","id":112106188,"number":103,"title":"How to make searching, filter and paging into server side ?","user":{"login":"moschel26","id":15192821,"avatar_url":"https://avatars.githubusercontent.com/u/15192821?v=3","gravatar_id":"","url":"https://api.github.com/users/moschel26","html_url":"https://github.com/moschel26","followers_url":"https://api.github.com/users/moschel26/followers","following_url":"https://api.github.com/users/moschel26/following{/other_user}","gists_url":"https://api.github.com/users/moschel26/gists{/gist_id}","starred_url":"https://api.github.com/users/moschel26/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moschel26/subscriptions","organizations_url":"https://api.github.com/users/moschel26/orgs","repos_url":"https://api.github.com/users/moschel26/repos","events_url":"https://api.github.com/users/moschel26/events{/privacy}","received_events_url":"https://api.github.com/users/moschel26/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-10-19T09:25:39Z","updated_at":"2015-10-22T23:25:43Z","closed_at":null,"body":"My application use CodeIgniter.\r\n\r\nLibrary that I use is Ignited-datatables Library.\r\n\r\nMy controller is like this :\r\n\r\npublic function get_book()\r\n{\r\n    $this->datatables->select('id, hotel, city, country, region')\r\n                ->unset_column('id')\r\n                ->from('hotel_book')\r\n    echo $this->datatables->generate('json', '');\r\n}\r\n\r\nMy HTML is like this:\r\n\r\n                    <table id=\"example\">\r\n                        <thead>\r\n                          <tr>                         \r\n                            <th>Hotel</th>\r\n                            <th>City</th>\r\n                            <th>Country</th>\r\n                            <th>Region</th>                                                   \r\n                          </tr>\r\n                        </thead>\r\n                    </table>\r\n\r\nMy Javascript is like this: \r\n\r\n            var table = $('#example').dataTable( {\r\n\r\n\r\n                \"order\": [[ 1, \"asc\" ]],\r\n\r\n                \"aoColumnDefs\": [\r\n                    { 'bSortable': false, 'aTargets': [ 3 ]},\r\n                    { 'bSearchable': true }\r\n                ],\r\n                \"Processing\": true,\r\n                \"ServerSide\": true,\r\n                \"sAjaxSource\": '<?php echo site_url(); ?>book/get_book',\r\n                \"bJQueryUI\": true,\r\n                \"sPaginationType\": \"full_numbers\",\r\n                \"iDisplayStart \":20,\r\n                \"oLanguage\": {\r\n                \"sProcessing\": \"<img src='<?php echo base_url(); ?>assets/images/ajax-loader_dark.gif'>\"\r\n                },      \r\n\r\n                \"columns\": [\r\n                        { \"data\": \"hotel\" },\r\n                        { \"data\": \"city\" },\r\n                        { \"data\": \"country\" },\r\n                        { \"data\": \"region\" }\r\n                ],  \r\n\r\n                'fnServerData': function(sSource, aoData, fnCallback)\r\n                {\r\n                    $.ajax\r\n                    ({\r\n                        'dataType': 'json',\r\n                        'type'    : 'POST',\r\n                        'url'     : sSource,\r\n                        'data'    : aoData,\r\n                        'success' : fnCallback\r\n                    });\r\n                }\r\n            } );\r\n\r\n\r\nThank you."},"comment":{"url":"https://api.github.com/repos/IgnitedDatatables/Ignited-Datatables/issues/comments/150382925","html_url":"https://github.com/IgnitedDatatables/Ignited-Datatables/issues/103#issuecomment-150382925","issue_url":"https://api.github.com/repos/IgnitedDatatables/Ignited-Datatables/issues/103","id":150382925,"user":{"login":"moschel26","id":15192821,"avatar_url":"https://avatars.githubusercontent.com/u/15192821?v=3","gravatar_id":"","url":"https://api.github.com/users/moschel26","html_url":"https://github.com/moschel26","followers_url":"https://api.github.com/users/moschel26/followers","following_url":"https://api.github.com/users/moschel26/following{/other_user}","gists_url":"https://api.github.com/users/moschel26/gists{/gist_id}","starred_url":"https://api.github.com/users/moschel26/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moschel26/subscriptions","organizations_url":"https://api.github.com/users/moschel26/orgs","repos_url":"https://api.github.com/users/moschel26/repos","events_url":"https://api.github.com/users/moschel26/events{/privacy}","received_events_url":"https://api.github.com/users/moschel26/received_events","type":"User","site_admin":false},"created_at":"2015-10-22T23:25:43Z","updated_at":"2015-10-22T23:25:43Z","body":"It is not working. I tried searching, but was not successful.\r\nController  : http://pastebin.com/5kyxBryx\r\nJavascript : http://pastebin.com/7ULQNHYc"}}