MODX Community

[Migxdb] db-filters problem + nested db-filter comboboxes

Hi All,

I am building a cmp using migxdb in order to manage the Post Codes of Portugal. So far, so good, but I am facing a problem with migxdb db-filters.

It is stated that in order to have a successfull resetall button, the other boxes need to have a default value as seen and explained here:
https://forums.modx.com/thread/97925/migxdb-cmp-reset-filter-not-working
https://forums.modx.com/thread/101005/db-filters-resetall-button

The resetall works on the comboboxes, but not in text boxes.
Here is my code:

{
  "formtabs":[
    {
      "MIGX_id":2007,
      "caption":"CTT - C\u00f3digos Postais",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":11996,
          "field":"DD",
          "caption":"Distrito *",
          "description":"Campo Obrigat\u00f3rio - Distrito Associado",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "listWidth":"",
            "title":"",
            "typeAhead":"false",
            "typeAheadDelay":250,
            "listEmptyText":"",
            "stackItems":"false"
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"@SELECT '' AS `name` ,'' AS `id` UNION ALL (SELECT `DESIG` AS `name`,`DD` as `id` FROM `[[+PREFIX]]ctt_distritos` WHERE `published` = 1 and `deleted` = 0)",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":11997,
          "field":"CC",
          "caption":"Concelho *",
          "description":"Campo Obrigat\u00f3rio - Concelho Associado",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "listWidth":"",
            "title":"",
            "typeAhead":"false",
            "typeAheadDelay":250,
            "listEmptyText":"",
            "stackItems":"false"
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"@SELECT '' AS `name` ,'' AS `id` UNION ALL (SELECT `DESIG` AS `name`,`CC` as `id` FROM `[[+PREFIX]]ctt_concelhos` WHERE `published` = 1 and `deleted` = 0)",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":11998,
          "field":"LLLL",
          "caption":"C\u00f3digo da Localidade *",
          "description":"Campo Obrigat\u00f3rio - C\u00f3digo da Localidade",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        },
        {
          "MIGX_id":11999,
          "field":"LOCALIDADE",
          "caption":"Nome da Localidade *",
          "description":"Campo Obrigat\u00f3rio - Nome da Localidade",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":4
        },
        {
          "MIGX_id":12000,
          "field":"ART_COD",
          "caption":"C\u00f3digo da Art\u00e9ria",
          "description":"C\u00f3digo da Art\u00e9ria",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":5
        },
        {
          "MIGX_id":12001,
          "field":"ART_TIPO",
          "caption":"Tipo de Art\u00e9ria",
          "description":"Art\u00e9ria - Tipo (Rua, Praca, etc)",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":6
        },
        {
          "MIGX_id":12002,
          "field":"PRI_PREP",
          "caption":"Primeira preposi\u00e7\u00e3o",
          "description":"Primeira preposi\u00e7\u00e3o",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":7
        },
        {
          "MIGX_id":12003,
          "field":"ART_TITULO",
          "caption":"Titulo da Art\u00e9ria",
          "description":"Art\u00e9ria - Titulo (Doutor, Eng.\u00ba, Professor, etc)",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":8
        },
        {
          "MIGX_id":12004,
          "field":"SEG_PREP",
          "caption":"Segunda preposi\u00e7\u00e3o",
          "description":"Segunda preposi\u00e7\u00e3o",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":9
        },
        {
          "MIGX_id":12005,
          "field":"ART_DESIG",
          "caption":"Art\u00e9ria - Designa\u00e7\u00e3o",
          "description":"Art\u00e9ria - Designa\u00e7\u00e3o",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":10
        },
        {
          "MIGX_id":12006,
          "field":"ART_LOCAL",
          "caption":"Art\u00e9ria - Informa\u00e7\u00e3o do Local\/Zona",
          "description":"Art\u00e9ria - Informa\u00e7\u00e3o do Local\/Zona",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":11
        },
        {
          "MIGX_id":12007,
          "field":"TRO\u00c7O",
          "caption":"Descri\u00e7\u00e3o do tro\u00e7o",
          "description":"Descri\u00e7\u00e3o do tro\u00e7o",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":12
        },
        {
          "MIGX_id":12008,
          "field":"PORTA",
          "caption":"N\u00famero da porta do cliente",
          "description":"N\u00famero da porta do cliente (vazio para c\u00f3digos postais geogr\u00e1ficos - C\u00f3digo postal geogr\u00e1fico: quando o \u00faltimo digito do CP4 \u00e9 0 ou 5)",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":13
        },
        {
          "MIGX_id":12009,
          "field":"CLIENTE",
          "caption":"Nome do cliente",
          "description":"Nome do cliente (vazio para c\u00f3digos postais geogr\u00e1ficos - C\u00f3digo postal geogr\u00e1fico: quando o \u00faltimo digito do CP4 \u00e9 0 ou 5)",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":14
        },
        {
          "MIGX_id":12010,
          "field":"CP4",
          "caption":"N\u00fam. do c\u00f3digo postal *",
          "description":"Campo Obrigat\u00f3rio - N\u00famero do c\u00f3digo postal",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "maxLength":4,
            "minLength":4,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":15
        },
        {
          "MIGX_id":12011,
          "field":"CP3",
          "caption":"Extens\u00e3o do n\u00fam. do c\u00f3digo postal *",
          "description":"Campo Obrigat\u00f3rio - Extens\u00e3o do n\u00famero do c\u00f3digo postal",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "maxLength":3,
            "minLength":3,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":16
        },
        {
          "MIGX_id":12012,
          "field":"CPALF",
          "caption":"Designa\u00e7\u00e3o Postal *",
          "description":"Campo Obrigat\u00f3rio - Designa\u00e7\u00e3o Postal",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":17
        },
        {
          "MIGX_id":12013,
          "field":"published",
          "caption":"Dispon\u00edvel *",
          "description":"Marcador de disponibilidade. Este marcador ir\u00e1 mostrar ou ocultar o formador no site e na listagem de formadores nas datas dos cursos.\nAten\u00e7\u00e3o: Ao desactivar este formador, n\u00e3o ir\u00e1 invalidar datas que j\u00e1 foram ligadas a este formador.",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":{
            "allowBlank":"false",
            "listWidth":"",
            "title":"",
            "typeAhead":"false",
            "typeAheadDelay":250,
            "listEmptyText":"",
            "stackItems":true
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"N\u00e3o==0||Sim==1",
          "default":1,
          "useDefaultIfEmpty":1,
          "pos":18
        },
        {
          "MIGX_id":12014,
          "field":"deleted",
          "caption":"deleted",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"none",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"0",
          "useDefaultIfEmpty":1,
          "pos":19
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||publish||unpublish||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview||resetwinposition",
  "columnbuttons":"",
  "filters":[
    {
      "MIGX_id":1,
      "name":"ctt_codpostal_filter_distrito",
      "label":"Distrito",
      "emptytext":"-- Filtrar Distrito --",
      "type":"combobox",
      "getlistwhere":{
        "DD":"[[+ctt_codpostal_filter_distrito]]"
      },
      "getcomboprocessor":"getcombo",
      "combotextfield":"DESIG",
      "comboidfield":"DD",
      "combowhere":"published=1 AND deleted=0",
      "comboclassname":"CttDistritos",
      "combopackagename":"ctt",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"Distrito",
      "comboparent":"",
      "default":"all"
    },
    {
      "MIGX_id":2,
      "name":"ctt_codpostal_filter_concelho",
      "label":"Concelho",
      "emptytext":"-- Filtrar Concelho --",
      "type":"combobox",
      "getlistwhere":{
        "DD":"[[+ctt_codpostal_filter_distrito]]",
        "CC":"[[+ctt_codpostal_filter_concelho]]"
      },
      "getcomboprocessor":"getcombo",
      "combotextfield":"DESIG",
      "comboidfield":"CC",
      "combowhere":"published=1 AND deleted=0",
      "comboclassname":"CttConcelhos",
      "combopackagename":"ctt",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"Concelho",
      "comboparent":"ctt_codpostal_filter_distrito",
      "default":"all"
    },
    {
      "MIGX_id":3,
      "name":"ctt_codpostal_filter_cp4",
      "label":"CP4",
      "emptytext":"-- CP4 --",
      "type":"textbox",
      "getlistwhere":{
        "CP4":"[[+ctt_codpostal_filter_cp4]]"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":"_empty"
    },
    {
      "MIGX_id":4,
      "name":"ctt_codpostal_filter_cp3",
      "label":"CP3",
      "emptytext":"-- CP3 --",
      "type":"textbox",
      "getlistwhere":{
        "CP3":"[[+ctt_codpostal_filter_cp3]]"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":"_empty"
    },
    {
      "MIGX_id":5,
      "name":"ctt_codpostal_filter_reset",
      "label":"Reset",
      "emptytext":"",
      "type":"resetall",
      "getlistwhere":"",
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"Adicionar C\u00f3digo Postal",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"C\u00f3digo Postal - [[+CP4]]-[[+CP3]] [[+CPALF]]",
    "update_win_title":"Gerir C\u00f3digos Postais",
    "win_id":"ctt_codigos_postais",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "media_source_id":"",
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":5,
    "winbuttonslist":"cancel||done",
    "extrahandlers":"this.resetWinPosition||this.update||this.handleColumnSwitch||this.csvExport",
    "filtersperrow":5,
    "packageName":"ctt",
    "classname":"CttCodigosPostais",
    "task":"",
    "getlistsort":"pos",
    "getlistsortdir":"ASC",
    "sortconfig":"",
    "gridpagesize":50,
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"dragdrop",
    "gridload_mode":2,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"CTT - C\u00f3digos Postais",
    "cmptabcaption":"C\u00f3digos Postais",
    "cmptabdescription":"Gerir C\u00f3digos Postais",
    "cmptabcontroller":"ctt_codigos_postais",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":2,
      "header":"ID",
      "dataIndex":"id",
      "width":25,
      "sortable":true,
      "show_in_grid":0,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"Dist Cod",
      "dataIndex":"DD",
      "width":"",
      "sortable":1,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":23,
      "header":"Distrito",
      "dataIndex":"DD_DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderChunk",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"[[migxLoopCollection?\n&packageName=`ctt`\n&classname=`CttDistritos`\n&joins=``\n&where=`{\"DD\":\"[[+DD]]\"}`\n&tpl=`@CODE:[[+DESIG]]`\n&outputSeparator=``\n&debug=`0`]]",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":24,
      "header":"Conc Cod",
      "dataIndex":"CC",
      "width":"",
      "sortable":1,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"Concelho",
      "dataIndex":"CC_DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderChunk",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"[[migxLoopCollection?\n&packageName=`ctt`\n&classname=`CttConcelhos`\n&joins=``\n&where=`{\"DD\":\"[[+DD]]\",\"CC\":\"[[+CC]]\"}`\n&tpl=`@CODE:[[+DESIG]]`\n&outputSeparator=``\n&debug=`0`]]",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":20,
      "header":"Localidade",
      "dataIndex":"LOCALIDADE",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":4,
      "header":"Cod. Art\u00e9ria",
      "dataIndex":"ART_COD",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":5,
      "header":"Art. Tipo",
      "dataIndex":"ART_TIPO",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":6,
      "header":"1\u00aa Prep.",
      "dataIndex":"PRI_PREP",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":6,
      "header":"Art. Titulo",
      "dataIndex":"ART_TITULO",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":7,
      "header":"2\u00aa Prep.",
      "dataIndex":"SEG_PREP",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":8,
      "header":"Art. Desig.",
      "dataIndex":"ART_DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":9,
      "header":"Art. Local",
      "dataIndex":"ART_LOCAL",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":14,
      "header":"Tro\u00e7o",
      "dataIndex":"TRO\u00c7O",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":15,
      "header":"Porta",
      "dataIndex":"PORTA",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":16,
      "header":"Cliente",
      "dataIndex":"CLIENTE",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":17,
      "dataIndex":"CP4",
      "header":"CP4"
    },
    {
      "MIGX_id":18,
      "dataIndex":"CP3",
      "header":"CP3"
    },
    {
      "MIGX_id":19,
      "header":"Des. Postal",
      "dataIndex":"CPALF",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":10,
      "header":"Ordem",
      "dataIndex":"pos",
      "width":30,
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":11,
      "header":"Activo",
      "dataIndex":"published",
      "width":45,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderSwitchStatusOptions",
      "clickaction":"switchOption",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":[
        {
          "MIGX_id":1,
          "name":"unpublished",
          "use_as_fallback":1,
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        },
        {
          "MIGX_id":2,
          "name":"published",
          "use_as_fallback":"",
          "value":1,
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_ticked.png"
        },
        {
          "MIGX_id":3,
          "name":"unpublished",
          "use_as_fallback":"",
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        }
      ],
      "editor":""
    },
    {
      "MIGX_id":12,
      "header":"deleted",
      "dataIndex":"deleted",
      "width":"",
      "sortable":true,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ],
  "category":""
}

What am I doing wrong?

On top of this, how can I have combobox 2 depend on combobox 1 selection? I tried to use comboparent but without success as well.

Thanks all in advance

1 Like

Hi all,

Any clues, please? :slight_smile: thanks in advance

1 Like

Hi All,

No clues? :frowning:

1 Like

I’m busy currently, but will look at it soon

1 Like

Hi Bruno,

Many thanks. No problem. I will wait. Many thanks for your time

1 Like

Hi Bruno,

Please don’t forget about my post, please :smile:
Thanks again

2 Likes

Do you have your xPDO - schema for me, so I can try to reproduce your setup

1 Like

Sure I do!
Let me just reach my PC so I can send it over to you.
In 2 hours should be possible for me.

Many thanks in advance!

1 Like

Sorry Bruno, some unpredictable personal things just popped up and I couldn’t share the details.
Tomorrow I will have time for sure.
Sorry for the delay and thanks again.

1 Like

Hi Bruno,

Sorry for the delay.
So here it is.

Database schema:


<?xml version="1.0" encoding="UTF-8"?>
<model package="inscricoes_online" baseClass="xPDOObject" platform="mysql" defaultEngine="InnoDB" phpdoc-package="inscricoes_online" version="1.1">
	<object class="InscricoesCttDistritos" table="ctt_distritos" extends="xPDOSimpleObject">
		<field key="DD" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="DESIG" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		
		<field key="pos" dbtype="int" precision="11" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		
		<composite alias="Concelhos" class="InscricoesCttConcelhos" local="DD" foreign="DD" cardinality="many" owner="local" />
		
		<index alias="DD" name="DD" primary="false" unique="false" type="BTREE">
            <column key="DD" length="" collation="A" null="false" />
        </index>
		<index alias="DESIG" name="DESIG" primary="false" unique="false" type="BTREE">
            <column key="DESIG" length="" collation="A" null="false" />
        </index>
	</object>
	<object class="InscricoesCttConcelhos" table="ctt_concelhos" extends="xPDOSimpleObject">
		<field key="DD" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="CC" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="DESIG" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		
		<field key="pos" dbtype="int" precision="11" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		
		<aggregate alias="DistritoDoConcelho" class="InscricoesCttDistritos" local="DD" foreign="DD" cardinality="one" owner="foreign" />
		<composite alias="CodigosPostais" class="InscricoesCttCodigosPostais" local="CC" foreign="CC" cardinality="many" owner="local" />
		
		<index alias="DD" name="DD" primary="false" unique="false" type="BTREE">
            <column key="DD" length="" collation="A" null="false" />
        </index>
		<index alias="CC" name="CC" primary="false" unique="false" type="BTREE">
            <column key="CC" length="" collation="A" null="false" />
        </index>
		<index alias="DESIG" name="DESIG" primary="false" unique="false" type="BTREE">
            <column key="DESIG" length="" collation="A" null="false" />
        </index>
	</object>
	<object class="InscricoesCttCodigosPostais" table="ctt_codigos_postais" extends="xPDOSimpleObject">
		<field key="DD" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="CC" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="LLLL" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="LOCALIDADE" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="ART_COD" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="ART_TIPO" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="PRI_PREP" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="ART_TITULO" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="SEG_PREP" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="ART_DESIG" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="ART_LOCAL" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="TROÇO" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="PORTA" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="CLIENTE" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="CP4" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="CP3" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		<field key="CPALF" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
		
		<field key="pos" dbtype="int" precision="11" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		
		<aggregate alias="Distrito" class="InscricoesCttDistritos" local="DD" foreign="DD" cardinality="one" owner="foreign" />
		<aggregate alias="Concelho" class="InscricoesCttConcelhos" local="CC" foreign="CC" cardinality="one" owner="foreign" />
		
		<index alias="DD" name="DD" primary="false" unique="false" type="BTREE">
            <column key="DD" length="" collation="A" null="false" />
        </index>
		<index alias="CC" name="CC" primary="false" unique="false" type="BTREE">
            <column key="CC" length="" collation="A" null="false" />
        </index>
		<index alias="CP4" name="CP4" primary="false" unique="false" type="BTREE">
            <column key="CP4" length="" collation="A" null="false" />
        </index>
		<index alias="CP3" name="CP3" primary="false" unique="false" type="BTREE">
            <column key="CP3" length="" collation="A" null="false" />
        </index>
	</object>
</model>

Config file for Districts:


{
  "formtabs":[
    {
      "MIGX_id":2005,
      "caption":"CTT - Districts",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":11987,
          "field":"DD",
          "caption":"District code *",
          "description":"Mandatory - District Code",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":11988,
          "field":"DESIG",
          "caption":"Designation *",
          "description":"Mandatory - District Designation",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":11989,
          "field":"published",
          "caption":"Available *",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":{
            "allowBlank":"false",
            "listWidth":"",
            "title":"",
            "typeAhead":"false",
            "typeAheadDelay":250,
            "listEmptyText":"",
            "stackItems":true
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"No==0||Yes==1",
          "default":1,
          "useDefaultIfEmpty":1,
          "pos":3
        },
        {
          "MIGX_id":11990,
          "field":"deleted",
          "caption":"deleted",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"none",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"0",
          "useDefaultIfEmpty":1,
          "pos":4
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||publish||unpublish||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview||resetwinposition",
  "columnbuttons":"",
  "filters":"",
  "extended":{
    "migx_add":"Add District",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"District - [[+DESIG]]",
    "update_win_title":"Manage Districts",
    "win_id":"ctt_distritos",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "media_source_id":"",
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":5,
    "winbuttonslist":"cancel||done",
    "extrahandlers":"this.resetWinPosition||this.update||this.handleColumnSwitch||this.csvExport",
    "filtersperrow":4,
    "packageName":"inscricoes",
    "classname":"InscricoesCttDistritos",
    "task":"",
    "getlistsort":"pos",
    "getlistsortdir":"ASC",
    "sortconfig":"",
    "gridpagesize":50,
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"dragdrop",
    "gridload_mode":2,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"CTT - Postal Codes",
    "cmptabcaption":"Districts",
    "cmptabdescription":"Manage Districts",
    "cmptabcontroller":"ctt_distritos",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":2,
      "header":"ID",
      "dataIndex":"id",
      "width":25,
      "sortable":true,
      "show_in_grid":0,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"District Code",
      "dataIndex":"DD",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":4,
      "header":"Designation",
      "dataIndex":"DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":10,
      "header":"Position",
      "dataIndex":"pos",
      "width":30,
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":7,
      "header":"Published",
      "dataIndex":"published",
      "width":45,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderSwitchStatusOptions",
      "clickaction":"switchOption",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":[
        {
          "MIGX_id":1,
          "name":"unpublished",
          "use_as_fallback":1,
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        },
        {
          "MIGX_id":2,
          "name":"published",
          "use_as_fallback":"",
          "value":1,
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_ticked.png"
        },
        {
          "MIGX_id":3,
          "name":"unpublished",
          "use_as_fallback":"",
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        }
      ],
      "editor":""
    },
    {
      "MIGX_id":8,
      "header":"deleted",
      "dataIndex":"deleted",
      "width":"",
      "sortable":true,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ],
  "category":""
}

Config for Counties:


{
  "formtabs":[
    {
      "MIGX_id":2015,
      "caption":"CTT - Counties",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":12120,
          "field":"CC",
          "caption":"County Code *",
          "description":"Mandatory - County Code",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":12121,
          "field":"DD",
          "caption":"District *",
          "description":"Mandatory - Linked District Code",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "listWidth":"",
            "title":"",
            "typeAhead":"false",
            "typeAheadDelay":250,
            "listEmptyText":"",
            "stackItems":"false"
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"@SELECT '' AS `name` ,'' AS `id` UNION ALL (SELECT `DESIG` AS `name`,`DD` as `id` FROM `[[+PREFIX]]ctt_distritos` WHERE `published` = 1 and `deleted` = 0)",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":12122,
          "field":"DESIG",
          "caption":"Designation *",
          "description":"Mandatory - District Designation",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        },
        {
          "MIGX_id":12123,
          "field":"published",
          "caption":"Published *",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":{
            "allowBlank":"false",
            "listWidth":"",
            "title":"",
            "typeAhead":"false",
            "typeAheadDelay":250,
            "listEmptyText":"",
            "stackItems":true
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"No==0||Yes==1",
          "default":1,
          "useDefaultIfEmpty":1,
          "pos":4
        },
        {
          "MIGX_id":12124,
          "field":"deleted",
          "caption":"deleted",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"none",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"0",
          "useDefaultIfEmpty":1,
          "pos":5
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||publish||unpublish||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview||resetwinposition",
  "columnbuttons":"",
  "filters":[
    {
      "MIGX_id":1,
      "name":"ctt_concelho_filter_distrito",
      "label":"District",
      "emptytext":"-- Filter District --",
      "type":"combobox",
      "getlistwhere":{
        "DD":"[[+ctt_concelho_filter_distrito]]"
      },
      "getcomboprocessor":"getcombo",
      "combotextfield":"DESIG",
      "comboidfield":"DD",
      "combowhere":"published=1 AND deleted=0",
      "comboclassname":"InscricoesCttDistritos",
      "combopackagename":"inscricoes",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":"all"
    }
  ],
  "extended":{
    "migx_add":"Add County",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"County - [[+DESIG]]",
    "update_win_title":"Manage Counties",
    "win_id":"ctt_concelhos",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "media_source_id":"",
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":5,
    "winbuttonslist":"cancel||done",
    "extrahandlers":"this.resetWinPosition||this.update||this.handleColumnSwitch||this.csvExport",
    "filtersperrow":4,
    "packageName":"inscricoes",
    "classname":"InscricoesCttConcelhos",
    "task":"",
    "getlistsort":"pos",
    "getlistsortdir":"ASC",
    "sortconfig":"",
    "gridpagesize":50,
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"dragdrop",
    "gridload_mode":2,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"CTT - Postal Codes",
    "cmptabcaption":"Counties",
    "cmptabdescription":"Manage Counties",
    "cmptabcontroller":"ctt_concelhos",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":2,
      "header":"ID",
      "dataIndex":"id",
      "width":25,
      "sortable":true,
      "show_in_grid":0,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"District",
      "dataIndex":"DD",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderChunk",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"[[migxLoopCollection?\n&packageName=`inscricoes`\n&classname=`InscricoesCttConcelhos`\n&joins=`[{\"alias\":\"DistritoDoConcelho\"}]`\n&where=`{\"id\":\"[[+id]]\"}`\n&tpl=`@CODE:[[+DistritoDoConcelho_DESIG]]`\n&outputSeparator=``\n&debug=`0`]]",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":4,
      "header":"County Code",
      "dataIndex":"CC",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":5,
      "header":"Designation",
      "dataIndex":"DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":6,
      "header":"Position",
      "dataIndex":"pos",
      "width":30,
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":7,
      "header":"Published",
      "dataIndex":"published",
      "width":45,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderSwitchStatusOptions",
      "clickaction":"switchOption",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":[
        {
          "MIGX_id":1,
          "name":"unpublished",
          "use_as_fallback":1,
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        },
        {
          "MIGX_id":2,
          "name":"published",
          "use_as_fallback":"",
          "value":1,
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_ticked.png"
        },
        {
          "MIGX_id":3,
          "name":"unpublished",
          "use_as_fallback":"",
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        }
      ],
      "editor":""
    },
    {
      "MIGX_id":8,
      "header":"deleted",
      "dataIndex":"deleted",
      "width":"",
      "sortable":true,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ],
  "category":""
}

1 Like

Config for Postal Codes (this is where I have the filters, and if I add the reset button, it won’t work):


{
  "formtabs":[
    {
      "MIGX_id":2016,
      "caption":"CTT - Postal Codes",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":12125,
          "field":"DD",
          "caption":"District *",
          "description":"Mandatory - Linked District",
          "description_is_code":"0",
          "inputTV":"CttDistritos",
          "inputTVtype":"",
          "validation":"required",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":12126,
          "field":"CC",
          "caption":"County *",
          "description":"Mandatory - Linked County",
          "description_is_code":"0",
          "inputTV":"CttConcelhos",
          "inputTVtype":"",
          "validation":"required",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":12127,
          "field":"LLLL",
          "caption":"Locale Code *",
          "description":"Mandatory - Locale Code",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        },
        {
          "MIGX_id":12128,
          "field":"LOCALIDADE",
          "caption":"Locale Name *",
          "description":"Mandatory - Locale Name",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":"false",
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":4
        },
        {
          "MIGX_id":12129,
          "field":"ART_COD",
          "caption":"Road Code",
          "description":"Road Code",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":5
        },
        {
          "MIGX_id":12130,
          "field":"ART_TIPO",
          "caption":"Road Type",
          "description":"Road Type - Street, Square, etc",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":6
        },
        {
          "MIGX_id":12131,
          "field":"PRI_PREP",
          "caption":"First preposition",
          "description":"First preposition",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":7
        },
        {
          "MIGX_id":12132,
          "field":"ART_TITULO",
          "caption":"Road title",
          "description":"Road Title - Doctor, Professor, etc)",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":8
        },
        {
          "MIGX_id":12133,
          "field":"SEG_PREP",
          "caption":"Second preposition",
          "description":"Second preposition",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":9
        },
        {
          "MIGX_id":12134,
          "field":"ART_DESIG",
          "caption":"Road - Designation",
          "description":"Road - Designation",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":10
        },
        {
          "MIGX_id":12135,
          "field":"ART_LOCAL",
          "caption":"Road - Local\/Zone Information",
          "description":"Road - Local/Zone Information",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":11
        },
        {
          "MIGX_id":12136,
          "field":"TRO\u00c7O",
          "caption":"Path",
          "description":"Path description",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":12
        },
        {
          "MIGX_id":12137,
          "field":"PORTA",
          "caption":"Customer door number",
          "description":"Customer door number",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":13
        },
        {
          "MIGX_id":12138,
          "field":"CLIENTE",
          "caption":"Customer Name",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":0,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":14
        },
        {
          "MIGX_id":12139,
          "field":"CP4",
          "caption":"Postal Code Number *",
          "description":"Mandatory",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "maxLength":4,
            "minLength":4,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":15
        },
        {
          "MIGX_id":12140,
          "field":"CP3",
          "caption":"Postal Code extension *",
          "description":"Mandatory",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "maxLength":3,
            "minLength":3,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":16
        },
        {
          "MIGX_id":12141,
          "field":"CPALF",
          "caption":"Postal Designation *",
          "description":"Mandatory",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"text",
          "validation":"required",
          "configs":{
            "allowBlank":true,
            "maxLength":255,
            "minLength":1,
            "regex":"",
            "regexText":""
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":17
        },
        {
          "MIGX_id":12142,
          "field":"published",
          "caption":"Published *",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":{
            "allowBlank":"false",
            "listWidth":"",
            "title":"",
            "typeAhead":"false",
            "typeAheadDelay":250,
            "listEmptyText":"",
            "stackItems":true
          },
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"No==0||Yes==1",
          "default":1,
          "useDefaultIfEmpty":1,
          "pos":18
        },
        {
          "MIGX_id":12143,
          "field":"deleted",
          "caption":"deleted",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"none",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"0",
          "useDefaultIfEmpty":1,
          "pos":19
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||publish||unpublish||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview||resetwinposition",
  "columnbuttons":"",
  "filters":[
   {
      "MIGX_id":1,
      "name":"ctt_codpostal_filter_distrito",
      "label":"Distrito",
      "emptytext":"-- Filtrar Distrito --",
      "type":"combobox",
      "getlistwhere":{
        "DD":"[[+ctt_codpostal_filter_distrito]]"
      },
      "getcomboprocessor":"getcombo",
      "combotextfield":"DESIG",
      "comboidfield":"DD",
      "combowhere":"published=1 AND deleted=0",
      "comboclassname":"CttDistritos",
      "combopackagename":"ctt",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"Distrito",
      "comboparent":"",
      "default":"all"
    },
    {
      "MIGX_id":2,
      "name":"ctt_codpostal_filter_concelho",
      "label":"Concelho",
      "emptytext":"-- Filtrar Concelho --",
      "type":"combobox",
      "getlistwhere":{
        "DD":"[[+ctt_codpostal_filter_distrito]]",
        "CC":"[[+ctt_codpostal_filter_concelho]]"
      },
      "getcomboprocessor":"getcombo",
      "combotextfield":"DESIG",
      "comboidfield":"CC",
      "combowhere":"published=1 AND deleted=0",
      "comboclassname":"CttConcelhos",
      "combopackagename":"ctt",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"Concelho",
      "comboparent":"ctt_codpostal_filter_distrito",
      "default":"all"
    },
    {
      "MIGX_id":3,
      "name":"ctt_codpostal_filter_cp4",
      "label":"CP4",
      "emptytext":"-- CP4 --",
      "type":"textbox",
      "getlistwhere":{
        "CP4":"[[+ctt_codpostal_filter_cp4]]"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":"_empty"
    },
    {
      "MIGX_id":4,
      "name":"ctt_codpostal_filter_cp3",
      "label":"CP3",
      "emptytext":"-- CP3 --",
      "type":"textbox",
      "getlistwhere":{
        "CP3":"[[+ctt_codpostal_filter_cp3]]"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":"_empty"
    },
    {
      "MIGX_id":5,
      "name":"ctt_codpostal_filter_reset",
      "label":"Reset",
      "emptytext":"",
      "type":"resetall",
      "getlistwhere":"",
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"Add Postal Code",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"Postal Code - [[+CP4]]-[[+CP3]] [[+CPALF]]",
    "update_win_title":"Manage postal Codes",
    "win_id":"ctt_codigos_postais",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "media_source_id":"",
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":5,
    "winbuttonslist":"cancel||done",
    "extrahandlers":"this.resetWinPosition||this.update||this.handleColumnSwitch||this.csvExport",
    "filtersperrow":5,
    "packageName":"inscricoes",
    "classname":"InscricoesCttCodigosPostais",
    "task":"",
    "getlistsort":"pos",
    "getlistsortdir":"ASC",
    "sortconfig":"",
    "gridpagesize":50,
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"dragdrop",
    "gridload_mode":2,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"CTT - Postal Codes",
    "cmptabcaption":"Postal Codes",
    "cmptabdescription":"Manage Postal Codes",
    "cmptabcontroller":"ctt_codigos_postais",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":2,
      "header":"ID",
      "dataIndex":"id",
      "width":25,
      "sortable":true,
      "show_in_grid":0,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"Dist Cod",
      "dataIndex":"DD",
      "width":"",
      "sortable":1,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":23,
      "header":"Distrito",
      "dataIndex":"DD_DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderChunk",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"[[migxLoopCollection?\n&packageName=`inscricoes`\n&classname=`InscricoesCttDistritos`\n&joins=``\n&where=`{\"DD\":\"[[+DD]]\"}`\n&tpl=`@CODE:[[+DESIG]]`\n&outputSeparator=``\n&debug=`0`]]",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":24,
      "header":"Conc Cod",
      "dataIndex":"CC",
      "width":"",
      "sortable":1,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"Concelho",
      "dataIndex":"CC_DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderChunk",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"[[migxLoopCollection?\n&packageName=`inscricoes`\n&classname=`InscricoesCttConcelhos`\n&joins=``\n&where=`{\"DD\":\"[[+DD]]\",\"CC\":\"[[+CC]]\"}`\n&tpl=`@CODE:[[+DESIG]]`\n&outputSeparator=``\n&debug=`0`]]",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":20,
      "header":"Localidade",
      "dataIndex":"LOCALIDADE",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":4,
      "header":"Cod. Art\u00e9ria",
      "dataIndex":"ART_COD",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":5,
      "header":"Art. Tipo",
      "dataIndex":"ART_TIPO",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":6,
      "header":"1\u00aa Prep.",
      "dataIndex":"PRI_PREP",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":6,
      "header":"Art. Titulo",
      "dataIndex":"ART_TITULO",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":7,
      "header":"2\u00aa Prep.",
      "dataIndex":"SEG_PREP",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":8,
      "header":"Art. Desig.",
      "dataIndex":"ART_DESIG",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":9,
      "header":"Art. Local",
      "dataIndex":"ART_LOCAL",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":14,
      "header":"Tro\u00e7o",
      "dataIndex":"TRO\u00c7O",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":15,
      "header":"Porta",
      "dataIndex":"PORTA",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":16,
      "header":"Cliente",
      "dataIndex":"CLIENTE",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":17,
      "dataIndex":"CP4",
      "header":"CP4"
    },
    {
      "MIGX_id":18,
      "dataIndex":"CP3",
      "header":"CP3"
    },
    {
      "MIGX_id":19,
      "header":"Des. Postal",
      "dataIndex":"CPALF",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":10,
      "header":"Ordem",
      "dataIndex":"pos",
      "width":30,
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":11,
      "header":"Activo",
      "dataIndex":"published",
      "width":45,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderSwitchStatusOptions",
      "clickaction":"switchOption",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":[
        {
          "MIGX_id":1,
          "name":"unpublished",
          "use_as_fallback":1,
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        },
        {
          "MIGX_id":2,
          "name":"published",
          "use_as_fallback":"",
          "value":1,
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_ticked.png"
        },
        {
          "MIGX_id":3,
          "name":"unpublished",
          "use_as_fallback":"",
          "value":"0",
          "clickaction":"switchOption",
          "handler":"",
          "image":"assets\/components\/migx\/style\/images\/cb_empty.png"
        }
      ],
      "editor":""
    },
    {
      "MIGX_id":12,
      "header":"deleted",
      "dataIndex":"deleted",
      "width":"",
      "sortable":true,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ],
  "category":""
}

Many thanks in advance for the help.

1 Like

Hi @bruno17,

Sorry for insisting. Can I ask your help when you have some free time? :slight_smile:

Thanks again

I can’t reproduce your setup, because of missing informations. Seems there is a second package in play.
I would need the setup of this package (schema and configs), too.

Strange. This works alone on its own package.
I will try it on a fresh install of modx and migx and try to understand what’s happening.

Did you get any error?

in the filters, you have ctt as a package name

You are right, sorry.
The package name should be “inscricoes_online” as per the schema I shared:

<model package="inscricoes_online" baseClass="xPDOObject" platform="mysql" defaultEngine="InnoDB" phpdoc-package="inscricoes_online" version="1.1">

My apologies…

ok, seems you posted some wrong configs then. For example CttDistritos should be InscricoesCttDistritos, right?

Yes, exactly, sorry :disappointed:

I will review it for you.