Summary
I set up textfilter for a search function in the MIGX grid, else a combobox for a category filter, but neither works (for me).
Step to reproduce
For example, for the textfilter DB-Filter:-
filter Name: textfilter
Filter Type: textbox
getList-where: {“name LIKE”. “%[[+textfilter]]%”}
As I understand those are the only required settings in a MIGX config.
Observed behavior
Submitting a search string refreshes the grid but there is no filtering nor any change to the grid.
No logs and the connector receives “success: true”.
Expected behavior
I’d expect to see the grid return only those entries that include a matching or near-matching string.
Is this me doing something wrong? I can’t find similar problems so, if so, I apologise for being a dolt. This wasn’t working on my dev site so I put together a vanilla installation and the problem is the same.
Environment
MODX 3.1.1-pl with MIGX 3.0.5-beta
… vanilla install, username owns files not www-data
nginx/1.27.4
mysql 15.1 Distrib 10.6.21-MariaDB, for debian-linux-gnu (x86_64)
PHP 7.4.33
MIGX config
{
"formtabs":[
{
"MIGX_id":1,
"MIGXtype":"formtab",
"MIGXtyperender":"<h3>formtab<\/h3>",
"caption":"New Formtab",
"print_before_tabs":1,
"fields":[
{
"MIGX_id":1,
"MIGXtype":"field",
"MIGXtyperender":"<h3>...field<\/h3>",
"field":"name",
"caption":"Name",
"description":"",
"description_is_code":"0",
"inputTV":"",
"inputTVtype":"",
"validation":"",
"configs":"",
"restrictive_condition":"",
"display":"",
"sourceFrom":"config",
"sources":"",
"inputOptionValues":"",
"default":"",
"useDefaultIfEmpty":"0",
"MIGXlayoutid":0,
"MIGXcolumnid":0,
"MIGXcolumnwidth":0,
"MIGXcolumnminwidth":"",
"MIGXcolumnstyle":"",
"MIGXcolumncaption":"",
"MIGXlayoutstyle":"",
"MIGXlayoutcaption":"",
"pos":1
},
{
"MIGX_id":2,
"MIGXtype":"field",
"MIGXtyperender":"<h3>...field<\/h3>",
"field":"image",
"caption":"Image",
"description":"",
"description_is_code":"0",
"inputTV":"",
"inputTVtype":"image",
"validation":"",
"configs":"",
"restrictive_condition":"",
"display":"",
"sourceFrom":"config",
"sources":"",
"inputOptionValues":"",
"default":"",
"useDefaultIfEmpty":"0",
"MIGXlayoutid":0,
"MIGXcolumnid":0,
"MIGXcolumnwidth":0,
"MIGXcolumnminwidth":"",
"MIGXcolumnstyle":"",
"MIGXcolumncaption":"",
"MIGXlayoutstyle":"",
"MIGXlayoutcaption":"",
"pos":2
}
],
"pos":1
}
],
"contextmenus":"update||duplicate||remove",
"actionbuttons":"addItem||bulk",
"columnbuttons":"",
"filters":[
{
"MIGX_id":1,
"name":"textfilter",
"label":"Test Search",
"emptytext":"search...",
"type":"textbox",
"getlistwhere":"{\"name LIKE\". \"%[[+textfilter]]%\"}",
"getcomboprocessor":"",
"combotextfield":"",
"comboidfield":"",
"combowhere":"",
"comboclassname":"",
"combopackagename":"",
"combo_use_custom_prefix":"0",
"comboprefix":"",
"combojoins":"",
"comboparent":"",
"default":""
}
],
"extended":{
"migx_add":"",
"disable_add_item":"",
"add_items_directly":"",
"formcaption":"",
"update_win_title":"",
"win_id":"mxcontent",
"maxRecords":"",
"addNewItemAt":"top",
"media_source_id":"",
"multiple_formtabs":"",
"multiple_formtabs_label":"",
"multiple_formtabs_field":"",
"multiple_formtabs_optionstext":"",
"multiple_formtabs_optionsvalue":"",
"hide_actionscolumn":"",
"actionbuttonsperrow":4,
"winbuttonslist":"",
"extrahandlers":"",
"filtersperrow":4,
"packageName":"mxcontent",
"classname":"Mxcontent\\Model\\mxContentItem",
"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",
"getlistselectfields":"",
"getlistspecialfields":"",
"getlistwhere":"",
"getlistgroupby":"",
"joins":"",
"hooksnippets":"",
"cmpmaincaption":"Manage mxContent",
"cmptabcaption":"mxContent",
"cmptabdescription":"Have a play here in the sandbox",
"cmptabcontroller":"",
"winbuttons":"",
"onsubmitsuccess":"",
"submitparams":""
},
"permissions":{
"apiaccess":"",
"view":"",
"list":"",
"save":"",
"create":"",
"remove":"",
"delete":"",
"publish":"",
"unpublish":"",
"viewdeleted":"",
"viewunpublished":""
},
"fieldpermissions":"",
"columns":[
{
"MIGX_id":2,
"dataIndex":"id",
"header":"id"
},
{
"MIGX_id":3,
"header":"name",
"dataIndex":"name",
"width":"",
"sortable":true,
"show_in_grid":1,
"customrenderer":"",
"renderer":"",
"clickaction":"",
"selectorconfig":"",
"renderchunktpl":"",
"renderoptions":"",
"editor":"this.textEditor"
},
{
"MIGX_id":4,
"dataIndex":"image",
"header":"image"
}
],
"category":""
}