Changing SQL is not Updating Visual

[Quelyn]

I am working to build out my dashboard, and somethings are easier for me to do in the SQL view, while other are easier for me in the Visual view. However, when I go into SQL and add something, for example maybe changing from this: 

 AND `Issue`.`issue_type` IN ('Bug',

                               'Story',

                               'Task')

to this: 

AND `Issue`.`issue_type` IN ('Content Request',

                               'Feature Request',

                               'Problem')

I will hit "Run Query" and even "Save to Dashboard", but when I reopen the chart the default visual options are reverted back, and when I click SQL they're now in sync with what the Visual had before I made the change. 

Is there a way to alter the SQL, then go back to the Visual tab and ask it to update based on the changes? 

[Tracy Chow · Accepted solution]

Hi @Quelyn,

Making changes and executing the query in visual mode updates the query in SQL mode, but this isn’t true for the reverse—making changes and executing the query in SQL mode doesn’t affect what’s shown in visual mode.

This is because you can do more complex things in SQL mode (e.g., window functions, subqueries) that aren't supported in visual mode.

Whatever mode you're in when you hit "Run query" and save will be the version that runs.

I hope this clarifies things!