MIGX filters aren't filtering: textfilter & combobox

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":""
}

This syntax seems to be wrong. I believe it should be JSON.
Does it work when you use {"name:LIKE":"%[[+textfilter]]%"}?

1 Like

Sir, you are correct.

Actually, I was taking instruction from your fine video:-

I’ll reference this thread there.

Thank you Harry, for all your tutoring. I’m loving MODX and MIGX, only wish I’d been using this fabulous platform years ago (instead of WordPress!)

Thank you.

2 Likes

This topic was automatically closed 2 days after discussion ended and a solution was marked. New replies are no longer allowed. You can open a new topic by clicking the link icon below the original post or solution and selecting “+ New Topic”.