{"action":"created","issue":{"url":"https://api.github.com/repos/EASOL/easol/issues/266","repository_url":"https://api.github.com/repos/EASOL/easol","labels_url":"https://api.github.com/repos/EASOL/easol/issues/266/labels{/name}","comments_url":"https://api.github.com/repos/EASOL/easol/issues/266/comments","events_url":"https://api.github.com/repos/EASOL/easol/issues/266/events","html_url":"https://github.com/EASOL/easol/issues/266","id":133771245,"number":266,"title":"Flex Reports V2","user":{"login":"regiscamimura","id":2001291,"avatar_url":"https://avatars.githubusercontent.com/u/2001291?v=3","gravatar_id":"","url":"https://api.github.com/users/regiscamimura","html_url":"https://github.com/regiscamimura","followers_url":"https://api.github.com/users/regiscamimura/followers","following_url":"https://api.github.com/users/regiscamimura/following{/other_user}","gists_url":"https://api.github.com/users/regiscamimura/gists{/gist_id}","starred_url":"https://api.github.com/users/regiscamimura/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/regiscamimura/subscriptions","organizations_url":"https://api.github.com/users/regiscamimura/orgs","repos_url":"https://api.github.com/users/regiscamimura/repos","events_url":"https://api.github.com/users/regiscamimura/events{/privacy}","received_events_url":"https://api.github.com/users/regiscamimura/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"regiscamimura","id":2001291,"avatar_url":"https://avatars.githubusercontent.com/u/2001291?v=3","gravatar_id":"","url":"https://api.github.com/users/regiscamimura","html_url":"https://github.com/regiscamimura","followers_url":"https://api.github.com/users/regiscamimura/followers","following_url":"https://api.github.com/users/regiscamimura/following{/other_user}","gists_url":"https://api.github.com/users/regiscamimura/gists{/gist_id}","starred_url":"https://api.github.com/users/regiscamimura/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/regiscamimura/subscriptions","organizations_url":"https://api.github.com/users/regiscamimura/orgs","repos_url":"https://api.github.com/users/regiscamimura/repos","events_url":"https://api.github.com/users/regiscamimura/events{/privacy}","received_events_url":"https://api.github.com/users/regiscamimura/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/EASOL/easol/milestones/9","html_url":"https://github.com/EASOL/easol/milestones/Acceptance%20Testing%20needed","labels_url":"https://api.github.com/repos/EASOL/easol/milestones/9/labels","id":1281079,"number":9,"title":"Acceptance Testing needed","description":"","creator":{"login":"edgarf","id":5213372,"avatar_url":"https://avatars.githubusercontent.com/u/5213372?v=3","gravatar_id":"","url":"https://api.github.com/users/edgarf","html_url":"https://github.com/edgarf","followers_url":"https://api.github.com/users/edgarf/followers","following_url":"https://api.github.com/users/edgarf/following{/other_user}","gists_url":"https://api.github.com/users/edgarf/gists{/gist_id}","starred_url":"https://api.github.com/users/edgarf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edgarf/subscriptions","organizations_url":"https://api.github.com/users/edgarf/orgs","repos_url":"https://api.github.com/users/edgarf/repos","events_url":"https://api.github.com/users/edgarf/events{/privacy}","received_events_url":"https://api.github.com/users/edgarf/received_events","type":"User","site_admin":false},"open_issues":16,"closed_issues":35,"state":"open","created_at":"2015-08-31T03:40:11Z","updated_at":"2016-03-02T19:47:39Z","due_on":null,"closed_at":null},"comments":13,"created_at":"2016-02-15T17:20:37Z","updated_at":"2016-03-03T21:05:02Z","closed_at":null,"body":"Specs here: https://docs.google.com/document/d/1jkLYY2cybDFep6p5SCj6PC7Y2VI71qCXUy4wWszDwXQ/edit#heading=h.2eu7nmuhg0gg\r\n\r\n\r\n- [x] 1. Flex Report add/edit form: Section for chart bars/slices definitions\r\n- [x] - Create database table to store data - 1h\r\n- [x] - Create named bars/slices, create JS to add items on the fly - 7h\r\n- [x] - Color picker is postponed to a second phase\r\ntotal: 8h\r\n\r\n- [x] 2. Flex Reports presentation\r\n- [x] - Create logic to group and sum data based on the result set for named columns - 8h\r\n- [x] - Create similar logic for dynamic columns - 8h\r\n- [x] - Create functions so a click on a bar/slice in the chart filters the table below - 6h\r\n- [x] - Add a feature so a click on a bar/slice highlights it - 2h\r\n- [x] - Removal of Easol_widget for filters - 4h\r\ntotal: 28h\r\n\r\n- [x] 3. Colors\r\n- [x] - Implement color picker in add/edit form - 6h\r\n- [x] - Implement the colors in flex report presentation - 8h\r\ntotal: 14h\r\n\r\n\r\n------\r\nAdditional @regiscamimura  - I have noticed that we yet don't have \"reset\" function on chart view (once you select a bar chart - then we need a way to see a full list again)"},"comment":{"url":"https://api.github.com/repos/EASOL/easol/issues/comments/191962275","html_url":"https://github.com/EASOL/easol/issues/266#issuecomment-191962275","issue_url":"https://api.github.com/repos/EASOL/easol/issues/266","id":191962275,"user":{"login":"regiscamimura","id":2001291,"avatar_url":"https://avatars.githubusercontent.com/u/2001291?v=3","gravatar_id":"","url":"https://api.github.com/users/regiscamimura","html_url":"https://github.com/regiscamimura","followers_url":"https://api.github.com/users/regiscamimura/followers","following_url":"https://api.github.com/users/regiscamimura/following{/other_user}","gists_url":"https://api.github.com/users/regiscamimura/gists{/gist_id}","starred_url":"https://api.github.com/users/regiscamimura/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/regiscamimura/subscriptions","organizations_url":"https://api.github.com/users/regiscamimura/orgs","repos_url":"https://api.github.com/users/regiscamimura/repos","events_url":"https://api.github.com/users/regiscamimura/events{/privacy}","received_events_url":"https://api.github.com/users/regiscamimura/received_events","type":"User","site_admin":false},"created_at":"2016-03-03T21:05:02Z","updated_at":"2016-03-03T21:05:02Z","body":"@edgarf I got the error for saving the report to table, but I couldn't reproduce the other errors. I tried with my local database and also with the remote dev database. I see the filters working fine and the query you posted works fine too. Have you updated the database with the file ./sql/mssql/266-report-chart-table.sql?\r\n\r\nAnyway, can you please send me an export of the report that is failing?\r\n\r\nRegarding the preview feature, yes, I need to get back and implement the changes to it. It does NOT have the filters implemented neither. I'm assuming it's ok to work on that and get preview update, is that correct?"}}