[MGNLUI-8573] App column filtering by mgnl:lastModifiedBy doesn't return any results for partial matches Created: 12/Dec/23  Updated: 12/Dec/23

Status: Open
Project: Magnolia UI
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Neutral
Reporter: Roman Kovařík Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Σ Remaining Estimate: Not Specified Remaining Estimate: Not Specified
Σ Time Spent: Not Specified Time Spent: Not Specified
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Issue Links:
Cloners
clones MGNLUI-8568 App column filtering by mgnl:tags pro... Open
causality
caused by MGNLUI-7739 System properties and non string valu... Closed
Sub-Tasks:
Key
Summary
Type
Status
Assignee
MGNLUI-8574 Implementation Sub-task To Do  
MGNLUI-8575 Review Sub-task To Do  
MGNLUI-8576 Pre-Integration QA Sub-task To Do  
Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Date of First Response:

 Description   

Steps to reproduce

  1. To enable filtering by tags:
  2. Go to http://localhost:8080/magnoliaAuthor/.magnolia/admincentral#app:resources:browser;/pages-content-tags-integration/decorations/pages-app/apps/pages-app.subApps.browser.yaml::
  3. Click edit
  4. Add to the mgnl:tags column config: 
              columns: 
                modifiedBy: &modifiedBy
                  name: mgnl:lastModifiedBy
                  filterComponent:
                    $type: textField
  1. Click Save.
  2. Go to http://localhost:8080/magnoliaAuthor/.magnolia/admincentral#app:pages-app:browser;/travel::
  3. Starting writing into the new column filter text field the word "superuser"

Expected results

The results are visible while writing.

Actual results

The results are not visible until whole name is written.

Workaround

Modify this line in JcrQueryBuilder like:

(!filterKey.startsWith(MGNL_PREFIX) || filterKey.endsWith("By")) &&

and this line like:

if ((filterKey.startsWith(MGNL_PREFIX) && !filterKey.endsWith("By")) || !(filterValue instanceof String)) {
    return JCR_OPERATOR_EQUAL_TO;
}

Development notes

For performance reasons, EQUAL operator is used since MGNLUI-7739 for all mgnl: properties.

System properties referencing user names might still benefit from LIKE operator though.


Generated at Mon Feb 12 09:56:24 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.