I made this map a CartoDB map to to show the countries that have banned their citizens working as maids in the Gulf states, I also want to show the Gulf states as one colour.

I created this SQL query for the world borders layer, the one you make available for use to all CartoDB users, in my map:

SELECT * FROM world_borders where name in ('Nepal', 'Kenya','Syrian Arab Republic','Pakistan','Bangladesh')

However, whenever I exit the map to the dashboard and then enter it again for editing, it defaults back to this query:

SELECT * FROM world_borders WHERE name ILIKE '%syria%'

This is a query which came from a filter I had applied in the past. Is the filter over riding the query somehow? I checked to make sure the filter was cleared. I have a free account. SQL queries seem to still be allowed for this level of account. What am I doing wrong? Additionally, how do I add/delete fields from the world borders table I've imported into my map?



If you want to clear the querys, you need to click on the option "clear view" in the green bar that appears in the data view: See image attachment:

enter image description here

About your second question (adding/deleting fields from tables), you need to click on the option "Add column". It is at the right menu (in Data View), the last option. I attach an image too: Adding columns


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.