{"action":"created","issue":{"url":"https://api.github.com/repos/SEED-platform/seed/issues/550","repository_url":"https://api.github.com/repos/SEED-platform/seed","labels_url":"https://api.github.com/repos/SEED-platform/seed/issues/550/labels{/name}","comments_url":"https://api.github.com/repos/SEED-platform/seed/issues/550/comments","events_url":"https://api.github.com/repos/SEED-platform/seed/issues/550/events","html_url":"https://github.com/SEED-platform/seed/issues/550","id":121811752,"number":550,"title":"Help for filtering criteria expressions","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},"labels":[{"url":"https://api.github.com/repos/SEED-platform/seed/labels/2","name":"2","color":"fbca04"},{"url":"https://api.github.com/repos/SEED-platform/seed/labels/Filtering","name":"Filtering","color":"2fa4c1"},{"url":"https://api.github.com/repos/SEED-platform/seed/labels/GUI","name":"GUI","color":"f4d848"}],"state":"open","locked":false,"assignee":{"login":"danielmcquillen","id":119496,"avatar_url":"https://avatars.githubusercontent.com/u/119496?v=3","gravatar_id":"","url":"https://api.github.com/users/danielmcquillen","html_url":"https://github.com/danielmcquillen","followers_url":"https://api.github.com/users/danielmcquillen/followers","following_url":"https://api.github.com/users/danielmcquillen/following{/other_user}","gists_url":"https://api.github.com/users/danielmcquillen/gists{/gist_id}","starred_url":"https://api.github.com/users/danielmcquillen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielmcquillen/subscriptions","organizations_url":"https://api.github.com/users/danielmcquillen/orgs","repos_url":"https://api.github.com/users/danielmcquillen/repos","events_url":"https://api.github.com/users/danielmcquillen/events{/privacy}","received_events_url":"https://api.github.com/users/danielmcquillen/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/SEED-platform/seed/milestones/33","html_url":"https://github.com/SEED-platform/seed/milestones/March%202016%20Development","labels_url":"https://api.github.com/repos/SEED-platform/seed/milestones/33/labels","id":1559779,"number":33,"title":"March 2016 Development","description":"Work slated to be worked on in March 2016, either for an interim hot fix or for the June 2016 release","creator":{"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},"open_issues":17,"closed_issues":2,"state":"open","created_at":"2016-02-02T22:59:57Z","updated_at":"2016-02-17T22:28:35Z","due_on":"2016-03-31T07:00:00Z","closed_at":null},"comments":1,"created_at":"2015-12-11T23:25:44Z","updated_at":"2016-02-24T22:09:08Z","closed_at":null,"body":"We need to come up with some nice way in the GUI to show people how the filtering works, ie, the expressions (!\"\", \"\", > , quotes for exact match, etc). \r\n\r\nCould be a quick tool tip, could include a link to a web page or other document with more details (?)\r\n\r\n@danielmcquillen -- I am assigning this to you for the Feb release."},"comment":{"url":"https://api.github.com/repos/SEED-platform/seed/issues/comments/188473710","html_url":"https://github.com/SEED-platform/seed/issues/550#issuecomment-188473710","issue_url":"https://api.github.com/repos/SEED-platform/seed/issues/550","id":188473710,"user":{"login":"nllong","id":1907354,"avatar_url":"https://avatars.githubusercontent.com/u/1907354?v=3","gravatar_id":"","url":"https://api.github.com/users/nllong","html_url":"https://github.com/nllong","followers_url":"https://api.github.com/users/nllong/followers","following_url":"https://api.github.com/users/nllong/following{/other_user}","gists_url":"https://api.github.com/users/nllong/gists{/gist_id}","starred_url":"https://api.github.com/users/nllong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nllong/subscriptions","organizations_url":"https://api.github.com/users/nllong/orgs","repos_url":"https://api.github.com/users/nllong/repos","events_url":"https://api.github.com/users/nllong/events{/privacy}","received_events_url":"https://api.github.com/users/nllong/received_events","type":"User","site_admin":false},"created_at":"2016-02-24T22:09:08Z","updated_at":"2016-02-24T22:09:08Z","body":"@RDmitchell -- i don't think this error is the same. But if you map a field to a new name with a single quote it crashes the building search. I'm sure there are a few characters that will cause this to crash.\r\n\r\n```\r\nsyntax error at or near \"s\"\r\nLINE 1: ...\"active\" = true AND (LOWER((extra_data->>'Phylroy's Fun Fiel...\r\n```"}}