{"action":"created","issue":{"url":"https://api.github.com/repos/wenzhixin/bootstrap-table/issues/533","labels_url":"https://api.github.com/repos/wenzhixin/bootstrap-table/issues/533/labels{/name}","comments_url":"https://api.github.com/repos/wenzhixin/bootstrap-table/issues/533/comments","events_url":"https://api.github.com/repos/wenzhixin/bootstrap-table/issues/533/events","html_url":"https://github.com/wenzhixin/bootstrap-table/issues/533","id":57602215,"number":533,"title":"both search and column sort enabled but not working","user":{"login":"tamirh67","id":2130099,"avatar_url":"https://avatars.githubusercontent.com/u/2130099?v=3","gravatar_id":"","url":"https://api.github.com/users/tamirh67","html_url":"https://github.com/tamirh67","followers_url":"https://api.github.com/users/tamirh67/followers","following_url":"https://api.github.com/users/tamirh67/following{/other_user}","gists_url":"https://api.github.com/users/tamirh67/gists{/gist_id}","starred_url":"https://api.github.com/users/tamirh67/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tamirh67/subscriptions","organizations_url":"https://api.github.com/users/tamirh67/orgs","repos_url":"https://api.github.com/users/tamirh67/repos","events_url":"https://api.github.com/users/tamirh67/events{/privacy}","received_events_url":"https://api.github.com/users/tamirh67/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-02-13T14:06:24Z","updated_at":"2015-03-13T11:42:21Z","closed_at":null,"body":"I get the full list everytime, unsorted...anyone has an idea why?\r\n\r\nhere is a row from the data (fake data ofcourse)\r\n{\"id\":54,\"customer_id\":1,\"first_name\":\"Larry\",\"last_name\":\"Smith\",\"mobile_phone\":\"1 765 483 4832\",\"work_phone\":\"1 232 320 8822\",\"home_phone\":\"1 768 938 3211\",\"email1\":\"Larry@larry.com\",\"email2\":\"\",\"fax\":\"\",\"address1\":\"brook boulevard 240\",\"address2\":\"\",\"city\":\"Boston\",\"state\":\"MA\",\"country\":\"United States\",\"zipcode\":\"76543\",\"itin\":\"3092384234\",\"drivers_license\":\"\",\"website\":null,\"birth_date\":\"1965-01-05\",\"notes\":null,\"created_at\":\"2015-01-16 17:50:27\",\"updated_at\":\"2015-01-16 17:50:27\",\"profilePictID\":0,\"middle_name\":\"\",\"company\":null,\"displayName\":null,\"openingBalance\":null,\"since\":null,\"facebook\":null,\"linkedin\":null,\"OID\":5,\"ReportingDatePref\":0,\"PaymentMethodPref\":0,\"PaymentPrefDate\":0}"},"comment":{"url":"https://api.github.com/repos/wenzhixin/bootstrap-table/issues/comments/78932613","html_url":"https://github.com/wenzhixin/bootstrap-table/issues/533#issuecomment-78932613","issue_url":"https://api.github.com/repos/wenzhixin/bootstrap-table/issues/533","id":78932613,"user":{"login":"x3uqm4","id":920044,"avatar_url":"https://avatars.githubusercontent.com/u/920044?v=3","gravatar_id":"","url":"https://api.github.com/users/x3uqm4","html_url":"https://github.com/x3uqm4","followers_url":"https://api.github.com/users/x3uqm4/followers","following_url":"https://api.github.com/users/x3uqm4/following{/other_user}","gists_url":"https://api.github.com/users/x3uqm4/gists{/gist_id}","starred_url":"https://api.github.com/users/x3uqm4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/x3uqm4/subscriptions","organizations_url":"https://api.github.com/users/x3uqm4/orgs","repos_url":"https://api.github.com/users/x3uqm4/repos","events_url":"https://api.github.com/users/x3uqm4/events{/privacy}","received_events_url":"https://api.github.com/users/x3uqm4/received_events","type":"User","site_admin":false},"created_at":"2015-03-13T11:42:21Z","updated_at":"2015-03-13T11:42:21Z","body":"I have same issue.\r\n\r\nJSON Data:\r\n{\"total\":\"3\",\"rows\":[{\"id\":\"2\",\"ad_soyad\":\"Burak Hurata\",\"tcno\":\"11111111111\",\"firma\":\"Nokvir Yaz\\u0131l\\u0131m\",\"santiye\":\"Eski\\u015fehir\",\"sorumlu\":\"Alper\",\"gorev\":\"SEO\",\"kan_grubu\":\"B RH(-)\",\"tel_no\":\"053333333333\",\"giris_tarih\":\"2015-03-13\",\"cikis_tarih\":\"\",\"ozluk_url\":\"..\\/img\\/ozluk\\/5182_burakhurata_ozluk_4.jpg\",\"saglik_url\":\"..\\/img\\/sagliktetkik\\/5985_burakhurata_sagliktetkik_10962249_10204893265684951_530266068_n.jpg\",\"isg_url\":\"..\\/img\\/isg\\/7269_burakhurata_igs_10962249_10204893265684951_530266068_n.jpg\",\"saglik_tarih\":\"2015-03-13\",\"resim_url\":\"..\\/img\\/fotograflar\\/5969_burakhurata_foto_10962249_10204893265684951_530266068_n.jpg\",\"aktif\":\"0\"},{\"id\":\"6\",\"ad_soyad\":\"Alper Sapan\",\"tcno\":\"12345678911\",\"firma\":\"Nokvir Yaz\\u0131l\\u0131m\",\"santiye\":\"Yaz\\u0131l\\u0131m\",\"sorumlu\":\"Burak Hurata\",\"gorev\":\"PHP Developer\",\"kan_grubu\":\"0 RH(+)\",\"tel_no\":\"05396972833\",\"giris_tarih\":\"2015-03-27\",\"cikis_tarih\":\"2015-03-09\",\"ozluk_url\":\"..\\/img\\/ozluk\\/4852_alpersapan_ozluk_10935612_1607718906106138_714285264_o.jpg\",\"saglik_url\":\"..\\/img\\/sagliktetkik\\/561_alpersapan_sagliktetkik_10935612_1607718906106138_714285264_o.jpg\",\"isg_url\":\"..\\/img\\/isg\\/9279_alpersapan_igs_10935612_1607718906106138_714285264_o.jpg\",\"saglik_tarih\":\"2015-03-12\",\"resim_url\":\"..\\/img\\/fotograflar\\/1150_alpersapan_foto_10935612_1607718906106138_714285264_o.jpg\",\"aktif\":\"1\"},{\"id\":\"7\",\"ad_soyad\":\"Atakan \",\"tcno\":\"12345678911\",\"firma\":\"Nokvir Yaz\\u0131l\\u0131m\",\"santiye\":\"Grafik\",\"sorumlu\":\"Burak Hurata\",\"gorev\":\"Grafik \",\"kan_grubu\":\"0 RH(+)\",\"tel_no\":\"1451564564564\",\"giris_tarih\":\"2015-04-04\",\"cikis_tarih\":\"2015-04-25\",\"ozluk_url\":\"..\\/img\\/ozluk\\/2759_atakan_ozluk_10935612_1607718906106138_714285264_o.jpg\",\"saglik_url\":\"..\\/img\\/sagliktetkik\\/9895_atakan_sagliktetkik_10935612_1607718906106138_714285264_o.jpg\",\"isg_url\":\"..\\/img\\/isg\\/5544_atakan_igs_10935612_1607718906106138_714285264_o.jpg\",\"saglik_tarih\":\"2015-03-10\",\"resim_url\":\"..\\/img\\/fotograflar\\/1344_atakan_foto_10935612_1607718906106138_714285264_o.jpg\",\"aktif\":\"1\"}]}\r\n\r\njson.php:\r\n$calisanlar = SQL::query(\"SELECT * FROM calisanlar\");\r\n$count= SQL::getVar(\"SELECT COUNT(id) FROM calisanlar\");\r\n$result= $calisanlar->fetchAll();\r\n$test= array(\r\n    'total' => $count, \r\n    'rows' => $result,\r\n    );\r\n\r\necho json_encode($test);\r\n\r\nand main.php\r\n\r\n<?php\r\n$limit = $_GET['limit'];\r\n$offset = $_GET['offset'];\r\n?>\r\n\r\n<table id=\"table\" \r\n           data-toggle=\"table\" \r\n           data-toolbar=\"#toolbar\" \r\n           data-search=\"true\" \r\n           data-show-refresh=\"true\" \r\n           data-show-toggle=\"true\" \r\n           data-show-columns=\"true\" \r\n           data-show-export=\"true\" \r\n           data-show-pagination-switch=\"true\" \r\n           data-pagination=\"true\" \r\n           data-side-pagination=\"server\" \r\n           data-url=\"json.php\">\r\n        <thead>\r\n        <tr>\r\n        \t<th data-field=\"id\" data-sortable=\"true\">#</th>\r\n        \t<th data-field=\"ad_soyad\" data-sortable=\"true\">Ad Soyad</th>\r\n        \t<th data-field=\"tcno\" data-sortable=\"true\">TC Kimlik No</th>\r\n        \t<th data-field=\"firma\" data-sortable=\"true\">Firma</th>\r\n        \t<th data-field=\"santiye\" data-sortable=\"true\">Şantiye</th>\r\n        \t<th data-field=\"sorumlu\" data-sortable=\"true\">Sorumlu</th>\r\n        \t<th data-field=\"sorumlu\" data-sortable=\"true\">Görev</th>\r\n        \t<th data-field=\"kan_grubu\" data-sortable=\"true\">Kan Grubu</th>\r\n        \t<th data-field=\"giris_tarih\" data-sortable=\"true\">Giriş Tarihi</th>\r\n        \t<th data-field=\"cikis_tarih\" data-sortable=\"true\">Çıkış tarihi</th>\r\n        \t<th data-field=\"saglik_tarih\" data-sortable=\"true\">Sağlık Raporu Tarihi</th>\r\n        \t<th data-field=\"aktif\" data-sortable=\"true\">Durum</th>\r\n        \t<?php if (session::getSession(\"nvfw_yetki\") >= 2) echo \"<th data-field=\\\"operate\\\"\r\n                data-formatter=\\\"operateFormatter\\\"\r\n                data-events=\\\"operateEvents\\\">İşlem</th>\"; ?>\r\n        </tr>\r\n        </thead>\r\n    </table>\r\n\r\n\r\n    <script>\r\n    var $table = $('#table'),\r\n        $remove = $('#remove');\r\n    $(function () {\r\n        $table.on('check.bs.table uncheck.bs.table check-all.bs.table uncheck-all.bs.table', function () {\r\n            $remove.prop('disabled', !$table.bootstrapTable('getSelections').length);\r\n        });\r\n        $remove.click(function () {\r\n            var ids = $.map($table.bootstrapTable('getSelections'), function (row) {\r\n                return row.id\r\n            });\r\n            $table.bootstrapTable('remove', {\r\n                field: 'id',\r\n                values: ids\r\n            });\r\n            $remove.prop('disabled', true);\r\n        });\r\n    });\r\n    function operateFormatter(value, row, index) {\r\n        return [\r\n            '   <a href=\"calisanislem.php?id=' + row.id + '&islem=duzenle\"><span class=\"glyphicon glyphicon-pencil\"></span></a>',\r\n            '   <a href=\"calisanislem.php?id=' + row.id + '&islem=sil\" onclick=\"return confirm(\\' ' + row.id + ' numaralı personel silinsin mi? \\')\"><span class=\"glyphicon glyphicon-trash\"></span></a>',\r\n        ].join('');\r\n    }\r\n</script>\r\n\r\n\r\nheader.php includes this;\r\n\r\n<script src=\"http://code.jquery.com/jquery-1.10.2.js\"></script>\r\n<script src=\"../js/bootstrap.min.js\"></script>\r\n<script src=\"../js/bootstrap-table.js\"></script>\r\n<script src=\"../js/extensions/filter/bootstrap-table-filter.js\"></script>\r\n<script src=\"../js/extensions/sorting/bootstrap-table_natural-sorting.js\"></script>"}}