Can I add columns to a relationship tab dynamically?
How do I add a column to a relationship tab dynamically. I wish to federate an ItemType, the number of columns returned depends on the dataset and query combination and cannot be predicted prior to the query being run. Typically I would expect 30-40 columns, but could theoretically be up to 200. My plan is to add a relationship type which is populated onGet, to bring back the required information using my Query. I would not to create a custom relationship view, as this will ensure compatibility with future upgrades. What is the best way to proceed? Can I create columns dynamically to return the results? Do I create a related ItemType with 200 columns and hide the ones I'm not using with JavaScript? Any help is appreciated. Many thanks, Martin.12KViews0likes3CommentsHow to color grid cells according to properties that are hidden in grid?
Hi Community, I hope somebody can give me some hints to solve the following use case. I use an onAfterGet Server Method in ItemType Part that colors certain columns like ‘state’. Now I want to add some color to an additional property that contain the ERP-Number of a Part. The ERP-Number column shall be colored according to two other properties that give information about the state of the erp transfer. But I don´t want to display the two additional properties in the main grid. That´s why the two properties are hidden by default. This now leads to the following problem. When my two state properties are hidden, they are not part of the get query that is run when performing a simple search in the Part grid. When the properties are not selected in with the get query, I cannot use them for coloring with my onAfterGet method. Is it somehow possible to add the two properties to the grid select query, but without showing the properties in the grid? Or does anybody now other ways to add some color to grid cells? I am thinking about some federation approach, but maybe this one can be solved easier. Thanks for any help! Best regards, AngelaSolved11KViews0likes6CommentsInnovator 12 - Where will grid preview images be displayed?
Hi, I have reviewed the demo slides of Innovator 12 BETA and most of the ideas are great and go into the right direction. But there is one thing that really confuses me: In the current Innovator main grid there is a 'Properties' columns near the TOC. I know from other customers, that this column is not very popular and as far as I understand the slides, this column will be removed in Innovator 12. But I wonder were Aras now will show the grid preview image? The option to preview the thumbnail image in while searching in the main grid was the one big advantage of the 'Properties' column. Anybody knows something about this one? Best regards! Angela8.4KViews0likes4CommentsHow to add a new icon to the Search Grid? or modify the default simple search
I want to modify the default simple search criteria and to pass the effective date by default. Or I want to add a new icon to the search grid and an event to modify the query on search click. or I can go with Advanced search and saved search but I want to pass the effective date of today's date. how is that possible?Solved6.3KViews0likes2CommentsTypeError: calendarItem is null
Hi Aras Community, I installed Aras 11 SP12: I am having blank grid screen for all types of view, when opening with an alternative language (eg. Chinese) In the firefox, the console is logging "TypeError: calendarItem is null". There is no issue on this when opening and using the Default Language (English) view. Can anyone guide me in how to fix this issue? Many Thanks!4.6KViews0likes2CommentsSET FORM PROPERTY FROM GRID EVENT IN ARAS
Hi Community, From the relationship grid event context, I was trying to set the value of a property and refresh in the source item form. top.instance.handleItemChange("property",value); The same piece of code is not working with Firefox. It works in IE. Any alternatives are available for Firefox ? Thanks in advance..!4.1KViews0likes2CommentsCascading dropdowns on grid columns?
Is it possible for the selected dropdown list value on a documents grid (tabular) to filter the list values of dropdown list next to it (cascading)? I know cascading filtering is possible to do in forms, but if that functionality doesn't carry over to the tabular grid view its useless for end users.4KViews0likes2CommentsRelationship grid vertical borders are not aligned between head and body rows
Hello All, We have a relationship grid, which has 46 columns. In Firefox browser, we can see the vertical border of cells in head row, as well as simple search row, are not aligned with the cell border of body rows. The more clumns you have, it is more obvious you can see in the right part of the grid. Not sure if you have experienced this issue. Is it an Innovator bug? Our Innovator version is 11 SP15.My Firefox is 52.6.0 ESR 32-bit. Display reslution is 1920x1080. OS is Windows 10. Below is screen capture.3.8KViews0likes2CommentsHow to get selected column index
Hi, I want to display the message when the user clicks on the "Related File" column from Document File relationship. so, how to get the column index? When User clicks on "Related File" the file will get the download, so on that browser window, so I want to show this message. Regards, MK3KViews0likes1Comment