{"action":"opened","issue":{"url":"https://api.github.com/repos/icatproject/topcat/issues/75","labels_url":"https://api.github.com/repos/icatproject/topcat/issues/75/labels{/name}","comments_url":"https://api.github.com/repos/icatproject/topcat/issues/75/comments","events_url":"https://api.github.com/repos/icatproject/topcat/issues/75/events","html_url":"https://github.com/icatproject/topcat/issues/75","id":89227784,"number":75,"title":"Grid filtering","user":{"login":"wayne-chung","id":12646305,"avatar_url":"https://avatars.githubusercontent.com/u/12646305?v=3","gravatar_id":"","url":"https://api.github.com/users/wayne-chung","html_url":"https://github.com/wayne-chung","followers_url":"https://api.github.com/users/wayne-chung/followers","following_url":"https://api.github.com/users/wayne-chung/following{/other_user}","gists_url":"https://api.github.com/users/wayne-chung/gists{/gist_id}","starred_url":"https://api.github.com/users/wayne-chung/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wayne-chung/subscriptions","organizations_url":"https://api.github.com/users/wayne-chung/orgs","repos_url":"https://api.github.com/users/wayne-chung/repos","events_url":"https://api.github.com/users/wayne-chung/events{/privacy}","received_events_url":"https://api.github.com/users/wayne-chung/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/icatproject/topcat/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/icatproject/topcat/labels/TopCAT%20v2","name":"TopCAT v2","color":"0052cc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-06-18T08:07:14Z","updated_at":"2015-06-18T08:07:14Z","closed_at":null,"body":"Grid filtering not working as it should. Filtering it done on the RESTAPI using JPQL query WHERE UPPER(ins.name) LIKE '%term%'. This is not correct as ui-grid uses a multipe columns ui interface.\r\n\r\nThere is also a problem sorting by date as a LIKE query cannot be used and the ICAT RESTAPI expects the date format to be in the format {ts 2011-01-15 00:00:00}\r\n"}}