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…

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…

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…

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…

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…

Is there a way to view the level number in TGV? We can see the level information in an exported Excel file from TGV, but it is not directly displayed in the TGV interface.

How to enable split screen mode in TGV similar to Part MultiLevel BOM Relationship in Part for effectivity context menu? By default how come that TGV has relationshipID_splitter elements?

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…

We've successfully created multiple Tree Grid Views following the documentation and various blog posts. However we're run into an issue when a query is updated (say removing elements) before those elements are removed or unmapped from the Tree Grid…

Hi community, I am playing around with displaying some data structure as Tree-Grid-View in Forms. The amount of data is very small. Normally we can display Tree-Grid-View data in relationships or pop-up dialogs. But I don´t want that users have to…

Hi everyone, I have an itemtype for which I have a saved search.When I click on the itemtype on TOC after clicking on saved search,the parameters applied for saved search are still there.I want to remove the filtering parameters and show an empty grid…

Hi community, this question is about TreeGridViews and the display of TGV data in Forms, popups, relationship grid or whatever. Right now there are two files inside Innovator that are commonly used to display TGV data: - ../aras.innovator.TreeGridView…

Hi Community, I have a custom SQL query that gets assembly information from another data source. In this data source, all relationships and related items are available in one table. Additional columns help to indicate, on which level / hierarchy position…

I am trying to create a recursive query to look at children, I try by using Reuse Query Element Definition but unfortunately its not working and when i select the element add button freezes as can be seen below.

Good day. When I try to add a Tree Grid View, the editor does not display. It only shows a blank page. The problem seems to be similar to this problem, Requirements editor not showing anything? , but I didn't see an answer. This is something that has…

Good day all. I am getting this error when trying to verify my Query Definition and Tree Grid View are set up. I add a field to a custom ItemType for tracking software, Manufacturer. When I se the query & test it, I can get all of the data I want, so…

Hi, I am currently looking to customize my excel export functionality, is it possible to have some columns in excel sheet to be read only, when it is exported ? I am passing the treegrid to the method as an input, but i don't want some columns like…

I want to display the results obtained by SQL in a TreeGridView, but I want to implement it. QueryBuilder does not allow me to achieve this. Can I display TGV trees? I want to narrow down my search by conditional branching.

We have an ItemType A and two Relationships Ra and TGV_Ra. In this, we are trying to get the details of Part Items which are present in this Relationship Ra and populating those in the Relationship TGV_Ra. But we've been getting this error - <SOAP-ENV…

I created a new DataModel with just one command bar button. I created a new Presentation configuration, linked the new new datamodel and added it to the "Linked Toolbar/Context Menu" property in Treegridview definition. When I try to show the tree…

Hi, expert In case like image below,how do I calculate the global scope ratio of my BOM and display the result with query builder and tree grid view ? The local scope ratio is recorded in relationship(item type) , because each items ( PartI,PartII…

Hello Everyone, I have one requirement in Tree Grid View with copy paste functionality: Create two TVG, One grid with Copy context Menu and another with Paste context menu. So if i copy row from one grid and paste into another that should add…

Hello, I'm using effectivity in tree grid views in Aras 12. One use case I had was to have effectivity on different levels. So that the top level of a structure has certain effectivity configurations and lower levels have their own that refer to the…

Hello, Is it possible to display a color list property in a tree grid view as it is displayed in forms and relationship views? With both the label text and the background color displayed in the cell. I've only been able to get tree grid cells to display…

Hello, Is there a way to add the button Export to Excel in a Tree Grid View result? I'm working on Aras 11SP15. I saw that this feature is available by default in Aras 12SP01. I tried to add it through ItemType (for example Part) -> Client Style…