{"action":"created","issue":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/1693","repository_url":"https://api.github.com/repos/arangodb/arangodb","labels_url":"https://api.github.com/repos/arangodb/arangodb/issues/1693/labels{/name}","comments_url":"https://api.github.com/repos/arangodb/arangodb/issues/1693/comments","events_url":"https://api.github.com/repos/arangodb/arangodb/issues/1693/events","html_url":"https://github.com/arangodb/arangodb/issues/1693","id":129901550,"number":1693,"title":"AQL Editor improvement suggestions","user":{"login":"pekeler","id":42363,"avatar_url":"https://avatars.githubusercontent.com/u/42363?v=3","gravatar_id":"","url":"https://api.github.com/users/pekeler","html_url":"https://github.com/pekeler","followers_url":"https://api.github.com/users/pekeler/followers","following_url":"https://api.github.com/users/pekeler/following{/other_user}","gists_url":"https://api.github.com/users/pekeler/gists{/gist_id}","starred_url":"https://api.github.com/users/pekeler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pekeler/subscriptions","organizations_url":"https://api.github.com/users/pekeler/orgs","repos_url":"https://api.github.com/users/pekeler/repos","events_url":"https://api.github.com/users/pekeler/events{/privacy}","received_events_url":"https://api.github.com/users/pekeler/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/arangodb/arangodb/labels/3_Feature","name":"3_Feature","color":"02e10c"},{"url":"https://api.github.com/repos/arangodb/arangodb/labels/front-end","name":"front-end","color":"02d7e1"}],"state":"open","locked":false,"assignee":{"login":"hkernbach","id":1244163,"avatar_url":"https://avatars.githubusercontent.com/u/1244163?v=3","gravatar_id":"","url":"https://api.github.com/users/hkernbach","html_url":"https://github.com/hkernbach","followers_url":"https://api.github.com/users/hkernbach/followers","following_url":"https://api.github.com/users/hkernbach/following{/other_user}","gists_url":"https://api.github.com/users/hkernbach/gists{/gist_id}","starred_url":"https://api.github.com/users/hkernbach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hkernbach/subscriptions","organizations_url":"https://api.github.com/users/hkernbach/orgs","repos_url":"https://api.github.com/users/hkernbach/repos","events_url":"https://api.github.com/users/hkernbach/events{/privacy}","received_events_url":"https://api.github.com/users/hkernbach/received_events","type":"User","site_admin":false},"milestone":null,"comments":6,"created_at":"2016-01-29T22:35:21Z","updated_at":"2016-03-05T07:08:25Z","closed_at":null,"body":"Some ideas that IMO would make the AQL Editor in Aardvark more user friendly:\r\n\r\n1. Navigating between Query and Result tabs is cumbersome. Get rid of the Result tab and show the result below the text area on the Query tab, limiting the visible max-height of the editor to perhaps 50% of the browser height.\r\n2. Allow me to execute queries right on the My Queries tab, again with results visible on same tab.\r\n3. Perhaps have another \"Example Queries\" tab with pre-populated common generic examples I could select as a starting point for creating my own queries.\r\n4. Allow me to enter more than one query in the Query editor, separated by newline, to be executed sequentially. For example, I'd have one query that updates something in my collection, another update query that changes something else in the same collection, followed by a query that shows me all documents in that collection so I can visually verify that the updates worked as intended. Entering these 3 queries together matches my workflow better, and is also closer to how other DBMSs work.\r\n5. Following up on the last point: add an Execute As Transaction button.\r\n6. On the Query tab, somewhere show a list of all my collections in small font size so I can copy-paste them. I don't always remember their name and navigating between Collections and AQL Editor is slowing me down.\r\n7. Auto complete in the editor for keywords, collection names, and previously declared variables :)\r\n8. Live parsing as I type, showing me right away if my AQL would be invalid, ideally by underlining or highlighting the invalid parts.\r\n\r\nI realize that some of these are a \"bit\" more difficult to realize :)\r\n"},"comment":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/comments/192600752","html_url":"https://github.com/arangodb/arangodb/issues/1693#issuecomment-192600752","issue_url":"https://api.github.com/repos/arangodb/arangodb/issues/1693","id":192600752,"user":{"login":"baslr","id":1494154,"avatar_url":"https://avatars.githubusercontent.com/u/1494154?v=3","gravatar_id":"","url":"https://api.github.com/users/baslr","html_url":"https://github.com/baslr","followers_url":"https://api.github.com/users/baslr/followers","following_url":"https://api.github.com/users/baslr/following{/other_user}","gists_url":"https://api.github.com/users/baslr/gists{/gist_id}","starred_url":"https://api.github.com/users/baslr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/baslr/subscriptions","organizations_url":"https://api.github.com/users/baslr/orgs","repos_url":"https://api.github.com/users/baslr/repos","events_url":"https://api.github.com/users/baslr/events{/privacy}","received_events_url":"https://api.github.com/users/baslr/received_events","type":"User","site_admin":false},"created_at":"2016-03-05T07:08:25Z","updated_at":"2016-03-05T07:08:25Z","body":"poc preview for 1, 2, 4, 6 and 8 https://www.youtube.com/watch?v=yvivD_w0HQM\r\nyou can try it out at [DUOUNO/ArangoDB-view](https://github.com/DUOUNO/ArangoDB-view) as a foxx app."}}