Answered Search Filters Multiply in Multiple MIGX-DB [SOLVED]

☆ A M B ☆
350 Posts

boomerang Reply #1, 11 years, 11 months ago

Ok, I've gone through my code several times to try and figure this one out but so far, can't see the problem.

What I've created is one package which incorporates 4 different tables and then created a menu which shows those 4 different tables as individual tabs to allow adding/editing etc. I can add content, no problem and it appears in grid, however, when I add a filter for each page it causes a bit of an issue. Below is my schema along with the raw json for each table. The attached image shows the multiple search box problem!

<model package="publications" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
<object class="uk_newspapers" table="uk_newspapers" extends="xPDOSimpleObject">
<field key="newspaperTitle" dbtype="text" phptype="string" null="false" default=""/>
<field key="frequency" dbtype="varchar" precision="100" phptype="string" null="false" default=""/>
<field key="createdon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="editedon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deletedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="publishedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign"/>
<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
</object>
<object class="inter_newspapers" table="inter_newspapers" extends="xPDOSimpleObject">
<field key="title" dbtype="text" phptype="string" null="false" default=""/>
<field key="country" dbtype="text" phptype="string" null="false" default=""/>
<field key="language" dbtype="text" phptype="string" null="false" default=""/>
<field key="frequency" dbtype="varchar" precision="155" phptype="string" null="false" default=""/>
<field key="day" dbtype="varchar" precision="80" phptype="string" null="false" default=""/>
<field key="createdon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="editedon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deletedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="publishedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign"/>
<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/> 
</object> 
<object class="satellite" table="satellite" extends="xPDOSimpleObject">
<field key="satelliteTitle" dbtype="text" phptype="string" null="false" default=""/>
<field key="day" dbtype="varchar" precision="10" phptype="string" null="false" default=""/>
<field key="country" dbtype="text" phptype="string" null="false" default=""/>
<field key="language" dbtype="text" phptype="string" null="false" default=""/>
<field key="schedule" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
<field key="frequency" dbtype="varchar" precision="155" phptype="string" null="false" default=""/>
<field key="price" dbtype="varchar" precision="150" phptype="string" null="false" default=""/>
<field key="createdon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="editedon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deletedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="publishedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign"/>
<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/> 
</object> 
<object class="magazines" table="magazines" extends="xPDOSimpleObject">
<field key="magazineTitle" dbtype="text" phptype="string" null="false" default=""/>
<field key="frequency" dbtype="varchar" precision="155" phptype="string" null="false" default=""/>
<field key="day" dbtype="varchar" precision="100" phptype="string" null="false" default=""/>
<field key="type" dbtype="varchar" precision="100" phptype="string" null="false" default=""/>
<field key="language" dbtype="text" phptype="string" null="false" default=""/>
<field key="createdon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="editedon" dbtype="datetime" phptype="datetime" null="true"/>
<field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="deletedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
<field key="publishedon" dbtype="datetime" phptype="datetime" null="false"/>
<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0"/>
<aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign"/>
<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/> 
</object> 
</model>

And then the code for each of the tables.

{
  "formtabs":[
    {
      "MIGX_id":4,
      "caption":"UK Newspaper",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":10,
          "field":"newspaperTitle",
          "caption":"Newspaper Title",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":1
        },
        {
          "MIGX_id":11,
          "field":"frequency",
          "caption":"Frequency",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"Daily||Weekly||Monthly",
          "default":"Daily",
          "pos":2
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview",
  "columnbuttons":"update||duplicate||recall_remove_delete",
  "filters":[
    {
      "MIGX_id":2,
      "name":"search",
      "label":"Search",
      "emptytext":"",
      "type":"textbox",
      "getlistwhere":{
        "newspaperTitle:LIKE":"%[[+search]]%"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"Add Publications",
    "disable_add_item":"",
    "formcaption":"",
    "update_win_title":"",
    "win_id":"uk_newspapers",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "multiple_formtabs":"",
    "actionbuttonsperrow":4,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":1,
    "packageName":"publications",
    "classname":"uk_newspapers",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":"",
    "gridpagesize":"",
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"",
    "gridload_mode":1,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "cmpmaincaption":"Publications",
    "cmptabcaption":"UK Newspapers",
    "cmptabdescription":"Add, edit and manage titles of UK Newspapers",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":1,
      "header":"ID",
      "dataIndex":"id",
      "width":10,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":2,
      "header":"Newspaper Title",
      "dataIndex":"newspaperTitle",
      "width":50,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"this.renderRowActions",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":3,
      "header":"Frequency",
      "dataIndex":"frequency",
      "width":40,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":4,
      "header":"",
      "dataIndex":"deleted",
      "width":"",
      "sortable":"false",
      "show_in_grid":"0",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    }
  ]
}

{
  "formtabs":[
    {
      "MIGX_id":6,
      "caption":"International Newspapers",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":14,
          "field":"title",
          "caption":"Newspaper Title",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":1
        },
        {
          "MIGX_id":16,
          "field":"country",
          "caption":"Country",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":2
        },
        {
          "MIGX_id":17,
          "field":"language",
          "caption":"Language",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":3
        },
        {
          "MIGX_id":15,
          "field":"frequency",
          "caption":"Frequency",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"Monday to Sunday||Monday to Friday||Monday to Saturday||Sunday||Weekly",
          "default":"Monday to Sunday",
          "pos":4
        },
        {
          "MIGX_id":18,
          "field":"day",
          "caption":"Day",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":5
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview",
  "columnbuttons":"update||duplicate||recall_remove_delete",
  "filters":[
    {
      "MIGX_id":1,
      "name":"search",
      "label":"Search",
      "emptytext":"",
      "type":"textbox",
      "getlistwhere":{
        "title:LIKE":"%[[+search]]%"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"Add Publications",
    "disable_add_item":"",
    "formcaption":"",
    "update_win_title":"",
    "win_id":"inter_newspapers",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "multiple_formtabs":"",
    "actionbuttonsperrow":4,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":1,
    "packageName":"publications",
    "classname":"inter_newspapers",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":"",
    "gridpagesize":"",
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"",
    "gridload_mode":1,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "cmpmaincaption":"Publications",
    "cmptabcaption":"International Newspapers",
    "cmptabdescription":"Add, edit and manage titles of International Newspapers",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":1,
      "header":"ID",
      "dataIndex":"id",
      "width":10,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":2,
      "header":"Newspaper Title",
      "dataIndex":"title",
      "width":50,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"this.renderRowActions",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":5,
      "header":"Country",
      "dataIndex":"country",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":3,
      "header":"Frequency",
      "dataIndex":"frequency",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":6,
      "header":"Language",
      "dataIndex":"language",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":4,
      "header":"",
      "dataIndex":"deleted",
      "width":"",
      "sortable":"false",
      "show_in_grid":"0",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    }
  ]
}

{
  "formtabs":[
    {
      "MIGX_id":7,
      "caption":"Satellite Publications",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":19,
          "field":"satelliteTitle",
          "caption":"Satellite Publication",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":1
        },
        {
          "MIGX_id":23,
          "field":"day",
          "caption":"Day",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":2
        },
        {
          "MIGX_id":20,
          "field":"country",
          "caption":"Country",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":3
        },
        {
          "MIGX_id":21,
          "field":"language",
          "caption":"Language",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":4
        },
        {
          "MIGX_id":31,
          "field":"schedule",
          "caption":"Schedule",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":5
        },
        {
          "MIGX_id":22,
          "field":"frequency",
          "caption":"Frequency",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"Daily||Weekly||Monthly",
          "default":"Daily",
          "pos":6
        },
        {
          "MIGX_id":24,
          "field":"price",
          "caption":"Price",
          "description":"Just add figures, do not add \u00a3 sign",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":7
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview",
  "columnbuttons":"update||duplicate||recall_remove_delete",
  "filters":[
    {
      "MIGX_id":2,
      "name":"search",
      "label":"Search",
      "emptytext":"",
      "type":"textbox",
      "getlistwhere":{
        "satelliteTitle:LIKE":"%[[+search]]%"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"Add Publications",
    "disable_add_item":"",
    "formcaption":"",
    "update_win_title":"",
    "win_id":"satellite",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "multiple_formtabs":"",
    "actionbuttonsperrow":4,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":1,
    "packageName":"publications",
    "classname":"satellite",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":"",
    "gridpagesize":"",
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"",
    "gridload_mode":1,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "cmpmaincaption":"Publications",
    "cmptabcaption":"Satellite Publications",
    "cmptabdescription":"Add, edit and manage titles of Satellite Publications",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":1,
      "header":"ID",
      "dataIndex":"id",
      "width":10,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":2,
      "header":"Satellite Publication",
      "dataIndex":"satelliteTitle",
      "width":50,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"this.renderRowActions",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":5,
      "header":"Country",
      "dataIndex":"country",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":3,
      "header":"Frequency",
      "dataIndex":"frequency",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":6,
      "header":"Language",
      "dataIndex":"language",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":7,
      "header":"Price",
      "dataIndex":"price",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":4,
      "header":"",
      "dataIndex":"deleted",
      "width":"",
      "sortable":"false",
      "show_in_grid":"0",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    }
  ]
}

{
  "formtabs":[
    {
      "MIGX_id":8,
      "caption":"Magazines",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":25,
          "field":"magazineTitle",
          "caption":"Magazine Title",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":1
        },
        {
          "MIGX_id":29,
          "field":"frequency",
          "caption":"Frequency",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"Daily||Weekly||Monthly",
          "default":"Daily",
          "pos":2
        },
        {
          "MIGX_id":26,
          "field":"day",
          "caption":"Day Code",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":3
        },
        {
          "MIGX_id":27,
          "field":"type",
          "caption":"Type",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"None||Magazine||Newspaper",
          "default":"Magazine",
          "pos":4
        },
        {
          "MIGX_id":28,
          "field":"language",
          "caption":"Language",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "pos":5
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||duplicate||recall_remove_delete",
  "actionbuttons":"addItem||toggletrash||exportview",
  "columnbuttons":"update||duplicate||recall_remove_delete",
  "filters":[
    {
      "MIGX_id":1,
      "name":"search",
      "label":"Search",
      "emptytext":"",
      "type":"textbox",
      "getlistwhere":{
        "magazineTitle:LIKE":"%[[+search]]%"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"Add Publications",
    "disable_add_item":"",
    "formcaption":"",
    "update_win_title":"",
    "win_id":"magazines",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "multiple_formtabs":"",
    "actionbuttonsperrow":4,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":1,
    "packageName":"publications",
    "classname":"magazines",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":"",
    "gridpagesize":"",
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"",
    "gridload_mode":1,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "cmpmaincaption":"Publications",
    "cmptabcaption":"Magazines",
    "cmptabdescription":"Add, edit and manage titles of Magazines",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":1,
      "header":"ID",
      "dataIndex":"id",
      "width":10,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":2,
      "header":"Magazines",
      "dataIndex":"magazineTitle",
      "width":50,
      "sortable":"false",
      "show_in_grid":1,
      "renderer":"this.renderRowActions",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":""
    },
    {
      "MIGX_id":3,
      "header":"Frequency",
      "dataIndex":"frequency",
      "width":20,
      "sortable":"false",
      "show_in_grid":1,
      "renderer

This question has been answered by Bruno17. See the first response.

[ed. note: boomerang last edited this post 11 years, 11 months ago.]

Helen Warner
Number one pixel!
Proud to be linked with MODX at Crimson Pixel

- ☆ A M B ☆
- 350 Posts
boomerang Reply #2, 11 years, 11 months ago
I've also discovered this error when adding data to the tables
```
[2014-11-08 18:36:46] (ERROR @ /paas/c3661/www/core/components/migx/model/migx/migx.class.php : 1911) PHP warning: Invalid argument supplied for foreach()
```
And just to confirm version of MIGX is 2.8.1 and its being used in MODX 2.3.2 and developed on MODX Cloud.

Thank you! [ed. note: boomerang last edited this post 11 years, 11 months ago.]
Helen Warner
Number one pixel!
Proud to be linked with MODX at Crimson Pixel
discuss.answer
- 5,888 Posts
Bruno17 Reply #3, 11 years, 11 months ago

each filter needs to have another unique name, if used at the same time on different grids.
-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!
- 189 Posts
gissirob Reply #4, 11 years, 11 months ago

Hi Helen,

Obviously, without understanding the requirements of the system you're building it is probably a bit impolite to offer re-design suggestions but...

It seems to me that the four tables are very similar and could easily be rolled together into one with the addition of a couple of extra fields. This could save on the number of grids and input forms as well as simplifying your filtering and possibly other benefits down the road.

Or not...
- ☆ A M B ☆
- 350 Posts
boomerang Reply #5, 11 years, 11 months ago

Bruno - as ever - you're a legend! That solved the problem - easy when you know how. Many thanks for such a prompt response.

And gissirob can see why you'd suggest a possible redesign but whilst the tables seem very similar they actually require different data options which if were only in one table could lead to confusion for the client.

Also from the client's perspective handling the data input with four different tables will make their job easier
Helen Warner
Number one pixel!
Proud to be linked with MODX at Crimson Pixel