Create db-filter by nested migx-tv values? Quotes problem!

7 Posts

chrncr Reply #1, 10 years, 8 months ago

I have this migx-tv "prices" (here go values):

[{"MIGX_id":"1","factory_name":"\"Seems\" to be working{}22","product_unit":"g.","product_price":"100","product_discount":"","product_availability":""}{"MIGX_id":"2","factory_name":"Name two{}16","product_unit":"g.","product_price":"","product_discount":"","product_availability":""}]

So I filter items from custom package with this filter:

"filters":[
    {
      "MIGX_id":1,
      "name":"byfactory",
      "label":"Factory",
      "emptytext":"Select one",
      "type":"combobox",
      "getlistwhere":{
        "prices:like":"%[[+byfactory]]%"
      },
      "getcomboprocessor":"factoriescombo",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    }
  ]

factoriescombo is custom processor, which outputs combobox width combo_id like this "Name two{}16".

Filter works, but..
It outputs nothing, when factory_name in prices tv and/or combo_id have quotes inside!

For example, I select in my combo value with combo_id equal \"Seems\" to be working{}22 an filter outputs 0 items.

How can I fix this issue?

- 5,888 Posts
Bruno17 Reply #2, 10 years, 8 months ago

would you like to show me the code of your combobox-processor and all other code, which I need to reproduce the issue?
-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

7 Posts

chrncr Reply #3, 10 years, 8 months ago

here is products config

{
  "formtabs":[
    {
      "MIGX_id":1,
      "caption":"Products",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":9,
          "field":"image",
          "caption":"Image",
          "description":"",
          "description_is_code":"0",
          "inputTV":"image",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":[
            {
              "MIGX_id":1,
              "context":"mgr",
              "sourceid":2
            }
          ],
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":1,
          "field":"pagetitle",
          "caption":"Name",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":20,
          "field":"weight",
          "caption":"Weight",
          "description":"",
          "description_is_code":"0",
          "inputTV":"weight",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        },
        {
          "MIGX_id":2,
          "field":"introtext",
          "caption":"Short desc",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"textarea",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":4
        },
        {
          "MIGX_id":21,
          "field":"haserror",
          "caption":"Has this item error?",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"checkbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"Yes==1||No==0",
          "default":"0",
          "useDefaultIfEmpty":1,
          "pos":5
        },
        {
          "MIGX_id":7,
          "field":"alias",
          "caption":"URL alias",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":6
        },
        {
          "MIGX_id":8,
          "field":"template",
          "caption":"Template",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":2,
          "useDefaultIfEmpty":1,
          "pos":7
        }
      ],
      "pos":1
    },
    {
      "MIGX_id":3,
      "caption":"Prices",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":3,
          "field":"prices",
          "caption":"Prices list",
          "description":"",
          "description_is_code":"0",
          "inputTV":"prices",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        }
      ],
      "pos":2
    },
    {
      "MIGX_id":5,
      "caption":"Full desc",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":10,
          "field":"content",
          "caption":"Full desc",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"richtext",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        }
      ],
      "pos":3
    }
  ],
  "contextmenus":"update||duplicate||publish||unpublish||recall_remove_delete||remove",
  "actionbuttons":"addItem||bulk||toggletrash",
  "columnbuttons":"",
  "filters":[
    {
      "MIGX_id":1,
      "name":"search",
      "label":"Search",
      "emptytext":"input here",
      "type":"textbox",
      "getlistwhere":{
        "pagetitle:LIKE":"%[[+search]]%"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    },
    {
      "MIGX_id":3,
      "name":"hazerror",
      "label":"Items with errors",
      "emptytext":"all",
      "type":"combobox",
      "getlistwhere":{
        "haserror":"[[+hazerror]]"
      },
      "getcomboprocessor":"geterroredcombo12",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    },
    {
      "MIGX_id":2,
      "name":"byfactory",
      "label":"By factory",
      "emptytext":"select factory",
      "type":"combobox",
      "getlistwhere":{
        "prices:like":"%[[+byfactory]]%"
      },
      "getcomboprocessor":"factoriescombo",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"Products",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"[[+pagetitle]]",
    "update_win_title":"Products",
    "win_id":"",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":5,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":4,
    "packageName":"shop",
    "classname":"ShopContent",
    "task":"",
    "getlistsort":"id",
    "getlistsortdir":"desc",
    "sortconfig":"",
    "gridpagesize":100,
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"",
    "gridload_mode":2,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"products",
    "cmptabcaption":"Products",
    "cmptabdescription":"Cmp desc",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":1,
      "header":"ID",
      "dataIndex":"id",
      "width":50,
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":5,
      "header":"Image",
      "dataIndex":"image",
      "width":150,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderImage",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":2,
      "header":"Name",
      "dataIndex":"pagetitle",
      "width":200,
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":"this.textEditor"
    },
    {
      "MIGX_id":6,
      "header":"Prices",
      "dataIndex":"prices",
      "width":150,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":7,
      "header":"Has error?",
      "dataIndex":"haserror",
      "width":120,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderChunk",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"[[!If?\n   &subject=`[[+haserror]]`\n   &operator=`>`\n   &operand=`0`\n   &then=`\u0414\u0430`\n   &else=`\u041d\u0435\u0442`\n]]",
      "renderoptions":"",
      "editor":"this.listboxEditor"
    }
  ]
}

here is "factories" config

{
  "formtabs":[
    {
      "MIGX_id":4,
      "caption":"Factory parameters",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":4,
          "field":"pagetitle",
          "caption":"Factory name",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":18,
          "field":"factory_yurname",
          "caption":"Yrname",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":19,
          "field":"factory_address",
          "caption":"Full factory address",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        },
        {
          "MIGX_id":16,
          "field":"city",
          "caption":"City",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":4
        },
        {
          "MIGX_id":11,
          "field":"factory_link",
          "caption":"UNUSED",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":5
        },
        {
          "MIGX_id":17,
          "field":"pricelist_link",
          "caption":"Pricelist link",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":6
        },
        {
          "MIGX_id":15,
          "field":"phones",
          "caption":"Phones",
          "description":"",
          "description_is_code":"0",
          "inputTV":"factoryphones",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":7
        },
        {
          "MIGX_id":13,
          "field":"introtext",
          "caption":"Description",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"textarea",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":8
        },
        {
          "MIGX_id":14,
          "field":"content",
          "caption":"Description full",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"richtext",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":9
        },
        {
          "MIGX_id":5,
          "field":"alias",
          "caption":"Alias",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":10
        },
        {
          "MIGX_id":12,
          "field":"template",
          "caption":"Template",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":6,
          "useDefaultIfEmpty":"0",
          "pos":11
        }
      ],
      "pos":1
    }
  ],
  "contextmenus":"update||remove",
  "actionbuttons":"addItem||bulk||toggletrash",
  "columnbuttons":"",
  "filters":"",
  "extended":{
    "migx_add":"Add new factory",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"[[+pagetitle]]",
    "update_win_title":"Factory",
    "win_id":"",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":4,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":4,
    "packageName":"factories",
    "classname":"StoreFactories",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":"",
    "gridpagesize":100,
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"",
    "gridload_mode":2,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"",
    "cmptabcaption":"",
    "cmptabdescription":"",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "columns":[
    {
      "MIGX_id":3,
      "header":"ID",
      "dataIndex":"id",
      "width":50,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":2,
      "header":"Name",
      "dataIndex":"pagetitle",
      "width":200,
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":1,
      "header":"City",
      "dataIndex":"city",
      "width":200,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":4,
      "header":"Alias",
      "dataIndex":"alias",
      "width":"",
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ]
}

factoriescombo processor:

<?php
 
$config = $modx->migx->customconfigs;
$emtpytext = 'Any factory';
$options = array();
$options[] = array('combo_name' => $emtpytext, 'combo_id' => '{');

$factories_collection = $modx->runSnippet('migxLoopCollection',array(
   'classname' => 'ShopFactories',
   'packageName' => 'factories',
   'tpl' => '@CODE:[[+pagetitle]]==[[+pagetitle]]{}[[+id]]',
   'outputSeparator' => '||'
    ));
    
$factories_options = explode('||',$factories_collection);

foreach ($factories_options as $f_option) {
    $f_option_departed = explode('==',$f_option);
    $options[] = array('combo_name' => $f_option_departed[0], 'combo_id' => $f_option_departed[1]);
}
 
$count = count($options);
return $this->outputArray($options, $count);

?>

and there are xml-schema for products

<?xml version="1.0" encoding="UTF-8"?>
<model package="shop" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
    <object class="ShopContent" table="shop_content" extends="xPDOSimpleObject">
	<field key="resource_id" dbtype="int" precision="10" phptype="int" null="false" index="index" />
	<field key="pagetitle" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="fulltext" indexgrp="shop_content_ft_idx" />
	<field key="longtitle" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="fulltext" indexgrp="shop_content_ft_idx"  />
	<field key="alias" dbtype="varchar" precision="255" phptype="string" null="true" default="" index="index" />
	<field key="deleted" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="deletedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="introtext" dbtype="text" phptype="string" null="true" index="fulltext" indexgrp="shop_content_ft_idx" />
	<field key="content" dbtype="mediumtext" phptype="string" null="true" index="fulltext" indexgrp="shop_content_ft_idx" />
	<field key="template" dbtype="int" precision="10" phptype="integer" null="false" default="2" />
	<field key="menuindex" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="editedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="createdon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="publishedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="unpublishedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="boolean" null="false" default="0" index="index" />
	<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="hidemenu" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" index="index" />
	<field key="image" dbtype="varchar" precision="255" null="true" default="" />
	<field key="prices" dbtype="mediumtext" phptype="string" null="true" default="" />
	<field key="weight" dbtype="float" phptype="float" null="true" default="0" />
	<field key="haserror" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="true" default="0" />

	<index alias="resource_id" name="resource_id" primary="false" unique="false" type="BTREE">
            <column key="resource_id" length="" collation="A" null="true" />
        </index>
	<index alias="alias" name="alias" primary="false" unique="false" type="BTREE">
            <column key="alias" length="" collation="A" null="true" />
        </index>
        <index alias="published" name="published" primary="false" unique="false" type="BTREE">
            <column key="published" length="" collation="A" null="false" />
        </index>
	<index alias="hidemenu" name="hidemenu" primary="false" unique="false" type="BTREE">
            <column key="hidemenu" length="" collation="A" null="false" />
        </index>
	
	<index alias="shop_content_ft_idx" name="shop_content_ft_idx" primary="false" unique="false" type="FULLTEXT">
            <column key="pagetitle" length="" collation="A" null="false" />
            <column key="longtitle" length="" collation="A" null="false" />
            <column key="introtext" length="" collation="A" null="true" />
            <column key="content" length="" collation="A" null="true" />
        </index>
	
    </object>
</model>

xml schema for factories

<?xml version="1.0" encoding="UTF-8"?>
<model package="factories" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
    <object class="ShopFactories" table="shop_factories" extends="xPDOSimpleObject">
	<field key="resource_id" dbtype="int" precision="10" phptype="int" null="false" index="index" />
	<field key="pagetitle" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="fulltext" indexgrp="shop_factories_ft_idx" />
	<field key="longtitle" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="fulltext" indexgrp="shop_factories_ft_idx"  />
	<field key="alias" dbtype="varchar" precision="255" phptype="string" null="true" default="" index="index" />
	<field key="deleted" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="deletedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="introtext" dbtype="text" phptype="string" null="true" index="fulltext" indexgrp="shop_factories_ft_idx" />
	<field key="content" dbtype="mediumtext" phptype="string" null="true" index="fulltext" indexgrp="shop_factories_ft_idx" />
	<field key="template" dbtype="int" precision="10" phptype="integer" null="false" default="6" />
	<field key="menuindex" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="editedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="createdon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="publishedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="unpublishedon" dbtype="int" precision="20" phptype="timestamp" null="false" default="0" />
	<field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="boolean" null="false" default="0" index="index" />
	<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
	<field key="hidemenu" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" index="index" />
	
	<field key="image" dbtype="varchar" precision="255" null="true" default="" />
	<field key="city" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
	<field key="factory_link" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
	<field key="pricelist_link" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
	<field key="phones" dbtype="mediumtext" phptype="string" null="true" default="" />
	<field key="factory_yurname" dbtype="varchar" precision="255" phptype="string" null="true" default="" />
	<field key="factory_adress" dbtype="varchar" precision="255" phptype="string" null="true" default="" />

	<index alias="resource_id" name="resource_id" primary="false" unique="false" type="BTREE">
            <column key="resource_id" length="" collation="A" null="true" />
        </index>
	<index alias="alias" name="alias" primary="false" unique="false" type="BTREE">
            <column key="alias" length="" collation="A" null="true" />
        </index>
        <index alias="published" name="published" primary="false" unique="false" type="BTREE">
            <column key="published" length="" collation="A" null="false" />
        </index>
	<index alias="hidemenu" name="hidemenu" primary="false" unique="false" type="BTREE">
            <column key="hidemenu" length="" collation="A" null="false" />
        </index>
	
	<index alias="shop_factories_ft_idx" name="shop_factories_ft_idx" primary="false" unique="false" type="FULLTEXT">
            <column key="pagetitle" length="" collation="A" null="false" />
            <column key="longtitle" length="" collation="A" null="false" />
            <column key="introtext" length="" collation="A" null="true" />
            <column key="content" length="" collation="A" null="true" />
        </index>
	
    </object>
</model>

prices migx-tv tabs

[
{"caption":"Prices","fields": [
{"field":"factory_name",
"caption":"Fc name",
"inputTVtype":"listbox",
"inputOptionValues":"@CHUNK getFactoriesList"
},{
"field":"product_unit",
"caption":"Unit"
},{
"field":"product_price",
"caption":"Price"
},{
"field":"product_discount",
"caption":"Discount"
},{
"field":"product_availability",
"caption":"Availability",
"inputTV":"availability"
}
]
}]

prices migx-tv columns

[
{"header": "Fc name", "width": "160", "sortable": "true", "dataIndex": "factory_name"},
{"header": "Unit", "width": "40", "sortable": "false", "dataIndex": "product_unit"},
{"header": "Price", "width": "50", "sortable": "false", "dataIndex": "product_price", "editor": "this.textEditor"},
{"header": "Discount", "width": "60", "sortable": "false", "dataIndex": "product_discount"},
{"header": "Avaliability", "width": "80", "sortable": "false", "dataIndex": "product_availability"}
]

I hope this is enough for reproducing the issue.

Simple schema for this issue:

2 packages;

1 filter for package1 with processor, which makes combobox from values (package2);

Filtering value in package1 is migx-tv value, which is stored in package1's table (not in tmplvar_contentvalues);

In this migx-tv value one of grid items stores value from package2, which is need to be compared in filter.