[MGNLUI-6347] Tree grid is not using limit/offset while filtering Created: 22/Oct/20  Updated: 15/Jun/23  Resolved: 22/May/23

Status: Closed
Project: Magnolia UI
Component/s: None
Affects Version/s: None
Fix Version/s: 6.3.0, 6.2.35

Type: Improvement Priority: Neutral
Reporter: Roman Kovařík Assignee: Quach Hao Thien
Resolution: Fixed Votes: 0
Labels: VN-Implementation
Σ Remaining Estimate: Not Specified Remaining Estimate: Not Specified
Σ Time Spent: 3d 3.25h Time Spent: 3d 3.25h
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: PNG File image-2023-04-03-10-47-14-438.png    
Issue Links:
Cloners
is cloned by CFGUI-171 Filtering in flat structure for defin... Closed
causality
caused by MGNLUI-6225 Flatten tree view structure while fil... Closed
Sub-Tasks:
Key
Summary
Type
Status
Assignee
MGNLUI-8046 Implementation Sub-task Completed Quach Hao Thien  
MGNLUI-8047 Review Sub-task Closed Antonín Juran  
MGNLUI-8048 PreintQA Sub-task Closed Antonín Juran  
MGNLUI-8049 QA Sub-task Completed Adam Siska  
MGNLUI-8068 Fix failed IT test Sub-task Completed Quach Hao Thien  
Template:
Acceptance criteria:
Empty
Task DoD:
[X]* Doc/release notes changes? Comment present?
[X]* Downstream builds green?
[X]* Solution information and context easily available?
[X]* Tests
[X]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Release notes required:
Yes
Documentation update required:
Yes
Date of First Response:
Epic Link: Grid performance
Sprint: Nucleus 36
Story Points: 2
Team: Nucleus
Work Started:
Approved:
Yes

 Description   

Steps to reproduce

Filter in a tree view.

Expected results

Datasource fetches just visible items.

Actual results

Datasource fetches all items and treegrid renders those.

Development notes

Treegrid is not using offset/limit because a logic to judge which items are visible (think about expanded items) would be too complicated.
As we use flat structure while filtering, we might use the same logic as flat grid while filtering.



 Comments   
Comment by Quach Hao Thien [ 03/Apr/23 ]

Discovery

Issue can be observed via debugging 

the query's limit is not limited to visible item on grid, but is set by the total items filtered (in this case is limit = 54 and offset = 0)

 

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