Tree Grid View slow: reads whole branch on expand — improvement ideas?
Hi Aras Community Folks, I’m facing a performance issue with the Aras TGV, expanding a node is extremely slow at large data volumes (~10 minutes at 1M items), and it looks like the server reads all descendant rows even though only the first 100 are shown. Details below — would really appreciate any guidance. Environment: Aras Innovator 14.36(14 SP36). Standard TreeGridView over a recursive Query Definition. Short version of the problem: When a user expands a node, the grid shows only the first 100 children (page size 100, with a “Show More” row). But under the hood, the server reads every descendant item beneath that branch — hundreds of thousands of rows — even though only 100 are displayed and none of the descendants are returned in the response. At 1Million items this makes a single expand take ~10 minutes. Root item (starting point) │ └─ Level B item ← via root's reference property │ ├─ [B → B] Count(child B) > 0 │ └─ Level B item ⟲ "Reuse Query Element Definition" → back to B (recursion) │ └─ [B → C] Count(C) > 0 └─ Level C item (is_current = 1) │ └─ [C → C] Count(C) > 0 └─ Level C item ⟲ "Reuse Query Element Definition" → back to C (recursion) Page size (max_child_items) = 100 | Default grow depth = 2 Two recursive legs: B→B and C→C, each gated by Count(...) > 0 Two recursive legs: B→B and C→C, each via Reuse Query Element Definition. Each relationship is gated by a Count(...) > 0 child-existence filter. TGV settings: page size max_child_items = 100, default grow depth = 2. What we measured: Expand one mid-level B node at 1M items: ~8 min. Shows 100 B rows + “Show More”, 0 C rows — but SQL reads the full descendant set (hundreds of thousands of rows) twice (paging query + property read). Count(...) > 0 already compiles to a permission-aware EXISTS; the cost is the broad descendant read, tied to the expand-icon (hasChild) check. Relationship source_id/related_id indexes already exist. Questions: On expand of an item, only the first 100 children are shown — but the server reads all descendants beneath the branch (full data) first, then returns 100 items. The descendants are read in full just to show 100 rows and to decide each row’s “+” expand icon. Is there a supported way to fetch only the 100 displayed rows from the start, and to make the expand-icon check stop at the first match instead of reading everything? Regarding the global tgv_MaxFetchItemsCount variable (default 1,000,000): we’re considering temporarily lowering it (e.g. to 100) before an expand and restoring the default afterwards, to limit how much is fetched. Does it actually limit the result to that many rows (return just the first N), or does it only reject an over-limit request with an error? And is it checked before the heavy SQL runs (so it saves the work), or after (so the rows are already read)? Would really appreciate any guidance or suggestions on the queries above106Views0likes3CommentsIs it possible to change color for TGV row/cell based on some conditions
Hi Experts, We have use case to change color of TGV row/cell based on some conditions. We are exploring various options to implement color change in TGV row/cell or at least text color. But not able to get any working solutions. Could you please suggest if it possible to achieve it. If yes, could you please share steps to implement solution. Example: Change TGV cell for rows with State - Released or Change Text color 'Released' to Red/Green193Views0likes3CommentsTree Grid Views but with additional filters to hide data we don´t need - what options do we have?
Hi community, let´s assume we have a multilevel BOM with many Parts. Some of them have Documents attached. There are Documents on level 0, 3 and 7 of the BOM. I want to have an tree-like overview of the Parts and the Documents, but I don´t want to display the Parts with no documents. We can use AML or SQL to get the data. E.g. I currently use following custom AML solution to get all documents and their levels in a simple grid rendering, SQL would work similiar: In the past I already used some 3rd part libs to render lightweight trees. But these custom trees often don´t blend in well if we don´t spend a lot of time with styling. So my idea is right now to use TGV for the tree rendering. I made a very test with QD and TGV. Data is missing intentionally as it´s just a functional sample. TGVs work well for trees, but they will show the complete BOM structure. Is there any way to hide the data we don´t need? We can use parameters to filter the data. But this filter option currently only hides the text of the elements and not the complete grid row itself. This behavior probably has a reason. In a multilevel BOM scenario Innovator cannot tell on which BOM level we have documents. TGVs need the complete data for the rendering. But I would be awesome if we would have some additional filter options to play around with appearance of the data AFTER query execution. Does anyone has an idea to do these kind of tree renderings? Thanks for any input!!! Angela193Views1like4CommentsTree Grid Filtering on multiple levels
Hello, I'm looking through the community forum for some information regarding filtering/searching on PE_BomStructure tree grid view and query definition. I've got a multi-level BOM that I'd like users to be able to filter by Part Number ( string or item). I followed the Query Element Builders Guide and the blog post "Filter a Tree Grid View with Parameters"; however it only works with the parameters at the top level. Is there any way to effectively filter the 2nd level rows and return the expandable level 1 rows where the item is found? I added a visualization in the attachment.130Views0likes3CommentsBOM Structure view with Substitute details
We are trying to fetch set of specific BOM substitute parts that are added on the Part BOM relationship of Root Part. And display it similar to BOM Structure tree view with addition filters on property. The substitute part added has to be replaced on the view with the Part on with it is present but the BOM Structure for the remaining has to be the same.44Views0likes0CommentsEdit a tree grid view cell value
Hi, Can someone please provide a sample javascript code that will allow to update a tree grid view’s cell text with a dynamic value . In my case the value is not fetched as part of query definition, instead it’s calculated dynamically in the UI based on a tool bar button click method31Views0likes0CommentsTGV Parameters Filtering doesn't show record if value is blank
Hello All, I have created TGV on part and I have added parameters to search and filter on custom "state" property . I have given default value as * . It works well and able to search and filter on state column but there is one issue if any record has state "Blank" . That record is skipped from TGV results and which is causing me showing incorrect TGV results . Help me to understand cause. Thanks in advance .120Views0likes1CommentTree Grid View Filtering
Hello, I've got a multi-level BOM that I'd like users to be able to filter by Name or Part Number. I followed the Query Element Builders Guide and the blog post "Filter a Tree Grid View with Parameters"; however it only works with the parameters at the top level. So if for instance, I've got a part (top level) with a Name of "Part_1" and I use the parameters on the TGV with that, it filters fine. But if I have a sub-part to that, with say a name of "Part_2" and I use the parameters on the TGV to that item, nothing shows up. I'm assuming the problem is in the filter condition... (Name LIKE $name) AND ([Part Number] LIKE $item_number) Can anyone help?Solved1.8KViews0likes4Comments