SHOW WIDGETS WHERE Name LIKE filter returns no results

[retran]

Description

SHOW WIDGETS WHERE Name LIKE '%button%' returns "No widgets found" even when matching widgets exist in the project.

Reproduction

SHOW WIDGETS;
-- Returns many widgets including buttons

SHOW WIDGETS WHERE Name LIKE '%button%';
-- Returns "No widgets found"

Environment

• mxcli: v0.7.0-257-ga07e7e0
• Project: EnquiriesManagement (Mendix 11.8.0)

Related

• docs: add manual test case documentation for all MDL command areas #386 (page test 4.3)

[github-actions]

Issue Triage

Summary:
The SHOW WIDGETS WHERE Name LIKE '%button%' command returns “No widgets found” even though matching widgets exist in the project.

Checklist for bug report completeness

Required info	Present?	Details
mxcli version	✅	v0.7.0-257-ga07e7e0
Mendix version	✅	11.8.0
Scenario (what was tried)	✅	Running the SQL‑like SHOW WIDGETS WHERE … command
Expected output	✅	Should list widgets whose names contain “button”
Experienced output	✅	Returns “No widgets found”
AI bug report (mxcli diag --bundle or session log)	❌	Not included

Missing information:
Please provide the diagnostic bundle or at least the session log from running mxcli diag --bundle (or the relevant log output) so we can investigate the filtering issue further. Thank you!

---

Automated triage via OpenRouter — workflow source

[retran]

Reproducing test cases: page-test-cases.md §4.3

[ako]

Fixed in 28ecac1 — the visitor was setting Operator = "LIKE" (upper-case) but the executor compared against "like" (lower-case), so the LIKE branch was never taken and all filtered queries silently fell back to equality checks.

---

Note on preferred filtering approach

SHOW WIDGETS WHERE is the only SHOW command with a WHERE clause. For richer filtering on any document type, the preferred approach is to query the catalog tables directly using standard SQL:

-- widgets matching a name pattern
select Name, WidgetType, Folder from Catalog.Widgets where Name like '%button%';

-- microflows in a specific module
select Name, ModuleName from Catalog.Microflows where ModuleName = 'MyModule';

-- pages whose name contains a keyword
select Name, Folder from Catalog.Pages where Name like '%Overview%';

SELECT ... FROM CATALOG.* supports full SQL — WHERE, LIKE, ORDER BY, LIMIT, etc. — and covers all document types. Run show catalog tables to see what's available.