{"action":"created","issue":{"url":"https://api.github.com/repos/usbr/HdbPoet/issues/8","repository_url":"https://api.github.com/repos/usbr/HdbPoet","labels_url":"https://api.github.com/repos/usbr/HdbPoet/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/usbr/HdbPoet/issues/8/comments","events_url":"https://api.github.com/repos/usbr/HdbPoet/issues/8/events","html_url":"https://github.com/usbr/HdbPoet/issues/8","id":174567315,"number":8,"title":"Add a Pisces-style SQL viewer & command window as a new tab...","user":{"login":"tjrocha","id":8174126,"avatar_url":"https://avatars.githubusercontent.com/u/8174126?v=3","gravatar_id":"","url":"https://api.github.com/users/tjrocha","html_url":"https://github.com/tjrocha","followers_url":"https://api.github.com/users/tjrocha/followers","following_url":"https://api.github.com/users/tjrocha/following{/other_user}","gists_url":"https://api.github.com/users/tjrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/tjrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tjrocha/subscriptions","organizations_url":"https://api.github.com/users/tjrocha/orgs","repos_url":"https://api.github.com/users/tjrocha/repos","events_url":"https://api.github.com/users/tjrocha/events{/privacy}","received_events_url":"https://api.github.com/users/tjrocha/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/usbr/HdbPoet/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"tjrocha","id":8174126,"avatar_url":"https://avatars.githubusercontent.com/u/8174126?v=3","gravatar_id":"","url":"https://api.github.com/users/tjrocha","html_url":"https://github.com/tjrocha","followers_url":"https://api.github.com/users/tjrocha/followers","following_url":"https://api.github.com/users/tjrocha/following{/other_user}","gists_url":"https://api.github.com/users/tjrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/tjrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tjrocha/subscriptions","organizations_url":"https://api.github.com/users/tjrocha/orgs","repos_url":"https://api.github.com/users/tjrocha/repos","events_url":"https://api.github.com/users/tjrocha/events{/privacy}","received_events_url":"https://api.github.com/users/tjrocha/received_events","type":"User","site_admin":false},"assignees":[{"login":"tjrocha","id":8174126,"avatar_url":"https://avatars.githubusercontent.com/u/8174126?v=3","gravatar_id":"","url":"https://api.github.com/users/tjrocha","html_url":"https://github.com/tjrocha","followers_url":"https://api.github.com/users/tjrocha/followers","following_url":"https://api.github.com/users/tjrocha/following{/other_user}","gists_url":"https://api.github.com/users/tjrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/tjrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tjrocha/subscriptions","organizations_url":"https://api.github.com/users/tjrocha/orgs","repos_url":"https://api.github.com/users/tjrocha/repos","events_url":"https://api.github.com/users/tjrocha/events{/privacy}","received_events_url":"https://api.github.com/users/tjrocha/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2016-09-01T16:23:13Z","updated_at":"2016-09-06T18:28:13Z","closed_at":null,"body":"Request was made by the HDB User Group during their 2016 meeting that a way to directly run SQL and interact with HDB would be helpful for users with moderate to advanced SQL skill levels. \r\n\r\nI suggested that we can try to port over this functionality from Pisces with the modifications below. HDB Users were made aware that this will only be for read-only purposes and not for full CRUD functionality like the rest of POET.\r\n1. Add a side-menu with selectable SQL snippets to perform certain functions. Something like the Pisces equation within the Calculation Series builder but with pre-configured SQL commands. The intent is to have this section be modular so we can add other specialized SQL snippets as needed.\r\n2. Have this new tab only be visible based on access levels defined in the REF_USER_GROUPS table.\r\n\r\n![image](https://cloud.githubusercontent.com/assets/8174126/18174981/72406a20-7024-11e6-965a-7ff5f9189b5e.png)\r\n"},"comment":{"url":"https://api.github.com/repos/usbr/HdbPoet/issues/comments/245044224","html_url":"https://github.com/usbr/HdbPoet/issues/8#issuecomment-245044224","issue_url":"https://api.github.com/repos/usbr/HdbPoet/issues/8","id":245044224,"user":{"login":"tjrocha","id":8174126,"avatar_url":"https://avatars.githubusercontent.com/u/8174126?v=3","gravatar_id":"","url":"https://api.github.com/users/tjrocha","html_url":"https://github.com/tjrocha","followers_url":"https://api.github.com/users/tjrocha/followers","following_url":"https://api.github.com/users/tjrocha/following{/other_user}","gists_url":"https://api.github.com/users/tjrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/tjrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tjrocha/subscriptions","organizations_url":"https://api.github.com/users/tjrocha/orgs","repos_url":"https://api.github.com/users/tjrocha/repos","events_url":"https://api.github.com/users/tjrocha/events{/privacy}","received_events_url":"https://api.github.com/users/tjrocha/received_events","type":"User","site_admin":false},"created_at":"2016-09-06T18:28:13Z","updated_at":"2016-09-06T18:28:13Z","body":"Enhancement mock-up detailed in the attached PDF. This will be the final product that will be generated from this enhancement. \r\n\r\n[Proposed POET Enhancement.pdf](https://github.com/usbr/HdbPoet/files/457490/Proposed.POET.Enhancement.pdf)\r\n\r\n"}}
{"actor":{"display_login":"tjrocha"}}