{"action":"created","issue":{"url":"https://api.github.com/repos/ox-it/ords/issues/763","repository_url":"https://api.github.com/repos/ox-it/ords","labels_url":"https://api.github.com/repos/ox-it/ords/issues/763/labels{/name}","comments_url":"https://api.github.com/repos/ox-it/ords/issues/763/comments","events_url":"https://api.github.com/repos/ox-it/ords/issues/763/events","html_url":"https://github.com/ox-it/ords/issues/763","id":133203436,"number":763,"title":"Advice relating to WHERE statements is misleading","user":{"login":"jajwilson","id":11886974,"avatar_url":"https://avatars.githubusercontent.com/u/11886974?v=3","gravatar_id":"","url":"https://api.github.com/users/jajwilson","html_url":"https://github.com/jajwilson","followers_url":"https://api.github.com/users/jajwilson/followers","following_url":"https://api.github.com/users/jajwilson/following{/other_user}","gists_url":"https://api.github.com/users/jajwilson/gists{/gist_id}","starred_url":"https://api.github.com/users/jajwilson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jajwilson/subscriptions","organizations_url":"https://api.github.com/users/jajwilson/orgs","repos_url":"https://api.github.com/users/jajwilson/repos","events_url":"https://api.github.com/users/jajwilson/events{/privacy}","received_events_url":"https://api.github.com/users/jajwilson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ox-it/ords/labels/Meriel%20Patrick","name":"Meriel Patrick","color":"2309a7"},{"url":"https://api.github.com/repos/ox-it/ords/labels/Priority-High","name":"Priority-High","color":"eb6420"}],"state":"closed","locked":false,"assignee":{"login":"MerielP","id":13660306,"avatar_url":"https://avatars.githubusercontent.com/u/13660306?v=3","gravatar_id":"","url":"https://api.github.com/users/MerielP","html_url":"https://github.com/MerielP","followers_url":"https://api.github.com/users/MerielP/followers","following_url":"https://api.github.com/users/MerielP/following{/other_user}","gists_url":"https://api.github.com/users/MerielP/gists{/gist_id}","starred_url":"https://api.github.com/users/MerielP/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MerielP/subscriptions","organizations_url":"https://api.github.com/users/MerielP/orgs","repos_url":"https://api.github.com/users/MerielP/repos","events_url":"https://api.github.com/users/MerielP/events{/privacy}","received_events_url":"https://api.github.com/users/MerielP/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2016-02-12T10:25:49Z","updated_at":"2016-02-15T18:16:38Z","closed_at":"2016-02-15T18:16:38Z","body":"At present, when a user enters the SQL for a WHERE statement they need to enclose the field name the are referencing in double quotes (or at least they need to do this if the field name contains any upper-case characters). This is not clear from the accompanying instruction, however.\r\n\r\nThe current instruction is:\r\n\"(Optional) WHERE statements are used to specify that only records meeting certain criteria should be included. Enclose text strings in 'single quotes'. \r\nSee the ORDS documentation or the W3Schools SQL tutorial for more about WHERE clauses.\"\r\n\r\nThe \"Enclose text strings in 'single quotes'\" instruction should be extended to include, \" and field names in \"double quotes\".\""},"comment":{"url":"https://api.github.com/repos/ox-it/ords/issues/comments/184332878","html_url":"https://github.com/ox-it/ords/issues/763#issuecomment-184332878","issue_url":"https://api.github.com/repos/ox-it/ords/issues/763","id":184332878,"user":{"login":"MerielP","id":13660306,"avatar_url":"https://avatars.githubusercontent.com/u/13660306?v=3","gravatar_id":"","url":"https://api.github.com/users/MerielP","html_url":"https://github.com/MerielP","followers_url":"https://api.github.com/users/MerielP/followers","following_url":"https://api.github.com/users/MerielP/following{/other_user}","gists_url":"https://api.github.com/users/MerielP/gists{/gist_id}","starred_url":"https://api.github.com/users/MerielP/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MerielP/subscriptions","organizations_url":"https://api.github.com/users/MerielP/orgs","repos_url":"https://api.github.com/users/MerielP/repos","events_url":"https://api.github.com/users/MerielP/events{/privacy}","received_events_url":"https://api.github.com/users/MerielP/received_events","type":"User","site_admin":false},"created_at":"2016-02-15T18:16:38Z","updated_at":"2016-02-15T18:16:38Z","body":"Done. I've also added an extra sentence to the ORDS documentation clarifying this."}}