ALTER TABLE `selectzona` CHANGE `zonaOperativa` `zonaOperativa` VARCHAR(11) NOT NULL; 
 
   INSERT INTO selectzona (`dZonaOperativa`,`ambito`,`dAmbito`,`delegacion`,`dDelegacion`,`zonaOperativa`,`areaOperativa`,`dAreaOperativa`,`centro`,`dCentro`,`sociedad`)     SELECT 'BCN+AMB',`ambito`,`dAmbito`,`delegacion`,`dDelegacion`,`zonaOperativa`,`areaOperativa`,`dAreaOperativa`,`centro`,`dCentro`,`sociedad`     FROM selectzona WHERE dZonaOperativa = 'Z.BCN' OR dZonaOperativa = 'Z.AREA METROPOLITANA';


UPDATE selectzona SET zonaOperativa = 'Z001' WHERE dZonaOperativa = 'BCN+AMB';

ADD FILTER: https://v2api.frotcom.com/v2/vehicleFilters/edit?api_key={{tokenFrotcom}}

{
    "name":"Z001 - BCN+AMB",
    "freeFields1": [

        {
            "name": "2000",
            "selected": true
        },
        {
            "name": "2004",
            "selected": true
        },
        {
            "name": "2005",
            "selected": true
        },
        {
            "name": "2006",
            "selected": true
        },
                {
            "name": "2010",
            "selected": true
        },
        {
            "name": "2015",
            "selected": true
        },
        {
            "name": "2016",
            "selected": true
        },
                {
            "name": "2017",
            "selected": true
        },
        {
            "name": "2018",
            "selected": true
        },
        {
            "name": "2020",
            "selected": true
        },
                {
            "name": "2025",
            "selected": true
        },
        {
            "name": "2030",
            "selected": true
        },
        {
            "name": "2035",
            "selected": true
        },
                {
            "name": "2040",
            "selected": true
        },
        {
            "name": "2045",
            "selected": true
        },
                {
            "name": "2056",
            "selected": true
        },
                {
            "name": "2070",
            "selected": true
        },
                {
            "name": "2072",
            "selected": true
        },
                {
            "name": "2077",
            "selected": true
        },
                {
            "name": "2082",
            "selected": true
        },
                {
            "name": "2087",
            "selected": true
        },
                {
            "name": "2090",
            "selected": true
        },
                {
            "name": "2097",
            "selected": true
        }
    ]
}