{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/5549","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5549/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5549/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5549/events","html_url":"https://github.com/CartoDB/cartodb/issues/5549","id":106769308,"number":5549,"title":"Applied view not saved","user":{"login":"peterdesmet","id":600993,"avatar_url":"https://avatars.githubusercontent.com/u/600993?v=3","gravatar_id":"","url":"https://api.github.com/users/peterdesmet","html_url":"https://github.com/peterdesmet","followers_url":"https://api.github.com/users/peterdesmet/followers","following_url":"https://api.github.com/users/peterdesmet/following{/other_user}","gists_url":"https://api.github.com/users/peterdesmet/gists{/gist_id}","starred_url":"https://api.github.com/users/peterdesmet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterdesmet/subscriptions","organizations_url":"https://api.github.com/users/peterdesmet/orgs","repos_url":"https://api.github.com/users/peterdesmet/repos","events_url":"https://api.github.com/users/peterdesmet/events{/privacy}","received_events_url":"https://api.github.com/users/peterdesmet/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CartoDB/cartodb/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-09-16T13:03:14Z","updated_at":"2015-09-18T08:44:02Z","closed_at":null,"body":"I'm giving a [CartoDB course](http://lifewatch.inbo.be/blog/posts/cartodb-tracking-data-tutorial.html) and one of the participants had the following issue:\r\n\r\n1. Create a category map of tiger occurrences, with category = sex of the individual\r\n2. Since the column `sex` contained mixed case and empty values, we applied the following SQL: `SELECT *, lower(sex) as sex2 FROM dataset WHERE sex != ''`\r\n3. Use `sex2` as the field for the category map\r\n4. Navigate to the dashboard\r\n5. Reopen the map\r\n6. The green \"query applied\" bar was visible, but in the SQL editor window, only the default SQL was present and the map had reverted to a simple, non-category map.\r\n\r\nReapplying or reloading did not solve this bug and it was present in Chrome and Firefox. However, if you clicked \"create dataset from this view\", the applied query was still used."},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/141383275","html_url":"https://github.com/CartoDB/cartodb/issues/5549#issuecomment-141383275","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/5549","id":141383275,"user":{"login":"xavijam","id":132146,"avatar_url":"https://avatars.githubusercontent.com/u/132146?v=3","gravatar_id":"","url":"https://api.github.com/users/xavijam","html_url":"https://github.com/xavijam","followers_url":"https://api.github.com/users/xavijam/followers","following_url":"https://api.github.com/users/xavijam/following{/other_user}","gists_url":"https://api.github.com/users/xavijam/gists{/gist_id}","starred_url":"https://api.github.com/users/xavijam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xavijam/subscriptions","organizations_url":"https://api.github.com/users/xavijam/orgs","repos_url":"https://api.github.com/users/xavijam/repos","events_url":"https://api.github.com/users/xavijam/events{/privacy}","received_events_url":"https://api.github.com/users/xavijam/received_events","type":"User","site_admin":false},"created_at":"2015-09-18T08:44:02Z","updated_at":"2015-09-18T08:44:02Z","body":"Hey Peter!\r\nThis was happening applying the style over the dataset or using that dataset as a layer in a map?\r\n"}}