{"action":"created","issue":{"url":"https://api.github.com/repos/tigrang/cakephp-datatable/issues/66","repository_url":"https://api.github.com/repos/tigrang/cakephp-datatable","labels_url":"https://api.github.com/repos/tigrang/cakephp-datatable/issues/66/labels{/name}","comments_url":"https://api.github.com/repos/tigrang/cakephp-datatable/issues/66/comments","events_url":"https://api.github.com/repos/tigrang/cakephp-datatable/issues/66/events","html_url":"https://github.com/tigrang/cakephp-datatable/issues/66","id":91756287,"number":66,"title":"Range filters","user":{"login":"fr0z3nfyr","id":5248866,"avatar_url":"https://avatars.githubusercontent.com/u/5248866?v=3","gravatar_id":"","url":"https://api.github.com/users/fr0z3nfyr","html_url":"https://github.com/fr0z3nfyr","followers_url":"https://api.github.com/users/fr0z3nfyr/followers","following_url":"https://api.github.com/users/fr0z3nfyr/following{/other_user}","gists_url":"https://api.github.com/users/fr0z3nfyr/gists{/gist_id}","starred_url":"https://api.github.com/users/fr0z3nfyr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fr0z3nfyr/subscriptions","organizations_url":"https://api.github.com/users/fr0z3nfyr/orgs","repos_url":"https://api.github.com/users/fr0z3nfyr/repos","events_url":"https://api.github.com/users/fr0z3nfyr/events{/privacy}","received_events_url":"https://api.github.com/users/fr0z3nfyr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-06-29T09:39:44Z","updated_at":"2016-04-04T16:22:05Z","closed_at":null,"body":"How can I get range filters to work? I have two inputs for a column to do a range search, see image for sample. when I check in console, i get `sSearch_0`, `sSearch_1`, `sSearch_2`, `sSearch_3` in config. \r\n\r\nOne, why is `sSearch3` required if there is no search on the last column. I think I have to check DT also to see if that is a mandate.\r\nTwo, I'm using YADCF for column filtering, so for the range filter, the searched range returns 0 rows. Probably, the query to DB is being passed incorrectly. How can I fix this? I'm supposing that the range filters for dates will also misbehave, I haven't tested.\r\n![sample](https://cloud.githubusercontent.com/assets/5248866/8402707/5913921e-1e5b-11e5-9009-20548b4a4154.png)\r\n"},"comment":{"url":"https://api.github.com/repos/tigrang/cakephp-datatable/issues/comments/205374821","html_url":"https://github.com/tigrang/cakephp-datatable/issues/66#issuecomment-205374821","issue_url":"https://api.github.com/repos/tigrang/cakephp-datatable/issues/66","id":205374821,"user":{"login":"tigrang","id":921680,"avatar_url":"https://avatars.githubusercontent.com/u/921680?v=3","gravatar_id":"","url":"https://api.github.com/users/tigrang","html_url":"https://github.com/tigrang","followers_url":"https://api.github.com/users/tigrang/followers","following_url":"https://api.github.com/users/tigrang/following{/other_user}","gists_url":"https://api.github.com/users/tigrang/gists{/gist_id}","starred_url":"https://api.github.com/users/tigrang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tigrang/subscriptions","organizations_url":"https://api.github.com/users/tigrang/orgs","repos_url":"https://api.github.com/users/tigrang/repos","events_url":"https://api.github.com/users/tigrang/events{/privacy}","received_events_url":"https://api.github.com/users/tigrang/received_events","type":"User","site_admin":false},"created_at":"2016-04-04T16:22:05Z","updated_at":"2016-04-04T16:22:05Z","body":"@destinydriven check this gist out for an exmaple. https://gist.github.com/tigrang/e6b9d53a407280f791f3abceea285394"}}