{"action":"created","issue":{"url":"https://api.github.com/repos/SEED-platform/seed/issues/486","labels_url":"https://api.github.com/repos/SEED-platform/seed/issues/486/labels{/name}","comments_url":"https://api.github.com/repos/SEED-platform/seed/issues/486/comments","events_url":"https://api.github.com/repos/SEED-platform/seed/issues/486/events","html_url":"https://github.com/SEED-platform/seed/pull/486","id":117899439,"number":486,"title":"Piper/issue 367 expression based filtering of numeric columns","user":{"login":"pipermerriam","id":824194,"avatar_url":"https://avatars.githubusercontent.com/u/824194?v=3","gravatar_id":"","url":"https://api.github.com/users/pipermerriam","html_url":"https://github.com/pipermerriam","followers_url":"https://api.github.com/users/pipermerriam/followers","following_url":"https://api.github.com/users/pipermerriam/following{/other_user}","gists_url":"https://api.github.com/users/pipermerriam/gists{/gist_id}","starred_url":"https://api.github.com/users/pipermerriam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pipermerriam/subscriptions","organizations_url":"https://api.github.com/users/pipermerriam/orgs","repos_url":"https://api.github.com/users/pipermerriam/repos","events_url":"https://api.github.com/users/pipermerriam/events{/privacy}","received_events_url":"https://api.github.com/users/pipermerriam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-11-19T20:20:47Z","updated_at":"2015-11-19T21:14:40Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/SEED-platform/seed/pulls/486","html_url":"https://github.com/SEED-platform/seed/pull/486","diff_url":"https://github.com/SEED-platform/seed/pull/486.diff","patch_url":"https://github.com/SEED-platform/seed/pull/486.patch"},"body":"Implements feature for #367 \r\n\r\n### What was wrong?\r\n\r\nNumeric field filtering was restricted to a min/max style filtering.  This interface was not powerful enough to serve the needs of users.\r\n\r\n### How was it fixed?\r\n\r\nImplemented expression based filtering.  The filter field is now a single field that can parse a number of expression formats.\r\n\r\nAn expression is one of the following operators.\r\n\r\n* `=`, `==` equality\r\n* `!=`, `!`, `<>` inequality\r\n* `<`, `<=` less than and less than or equal to\r\n* `>`, `>=` greater than and greater than or equal to\r\n\r\nFollowed by either a numeric value or the string 'null'\r\n\r\n> `null` can only be used with the equality or inequality operators.\r\n\r\nThe filtering field accepts multiple expressions separated by a comma.  Intermixed whitespace is stripped and ignored.\r\n\r\n### What this does not implement (yet)\r\n\r\n- [ ] help text of any kind in the interface to inform users on how to use this feature.\r\n\r\nI spent some time trying to fit this into the interface with little luck.  The area available is extremely limited. It seems like it will take a small paragraph and a few examples to satisfactorily explain this feature.  Here is the text I would use.\r\n\r\n```\r\nYou may use complex expressions to filter this field.  An expression is one of the following operators followed by a number or the string 'null'.  (null can only be used with equality and inequality operators).\r\n\r\nOperators: =, ==, !=, !, <>, <, <=, >, >=\r\n\r\nMultiple expressions should be separated by commas.\r\n\r\nExamples:\r\n- \">100\"  greater than 100\r\n- \">1984,<1990 greater than 1984 and less than 1990\r\n- \"!null, !0\" not null and not equal to 0\r\n```\r\n\r\n#### Cute animal picture"},"comment":{"url":"https://api.github.com/repos/SEED-platform/seed/issues/comments/158200131","html_url":"https://github.com/SEED-platform/seed/pull/486#issuecomment-158200131","issue_url":"https://api.github.com/repos/SEED-platform/seed/issues/486","id":158200131,"user":{"login":"RDmitchell","id":6314950,"avatar_url":"https://avatars.githubusercontent.com/u/6314950?v=3","gravatar_id":"","url":"https://api.github.com/users/RDmitchell","html_url":"https://github.com/RDmitchell","followers_url":"https://api.github.com/users/RDmitchell/followers","following_url":"https://api.github.com/users/RDmitchell/following{/other_user}","gists_url":"https://api.github.com/users/RDmitchell/gists{/gist_id}","starred_url":"https://api.github.com/users/RDmitchell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RDmitchell/subscriptions","organizations_url":"https://api.github.com/users/RDmitchell/orgs","repos_url":"https://api.github.com/users/RDmitchell/repos","events_url":"https://api.github.com/users/RDmitchell/events{/privacy}","received_events_url":"https://api.github.com/users/RDmitchell/received_events","type":"User","site_admin":false},"created_at":"2015-11-19T21:14:40Z","updated_at":"2015-11-19T21:14:40Z","body":"That's fine. We can deal with it later. Thanks !"}}