• How to use a query to get distinct values from a item table

    Community, I have created a staging table capability that will be used to generate innovator eBOMs from Oracle manufacturing BOMs. My challenge is working with 1.7 million rows of data in SQL Server. I know I could create a SQL procedure to get…
  • How to use CUI Checkboxes and Dropdowns + how get their values from other elements?

    Hi Community, I right now play around with CUI CommandBarCheckboxes and CommandBarDropdowns. Does anyone of you have worked with these two elements already? I look for a solution how to get their selected values from another (!) CUI element. CommandBarCheckboxes…
  • How to use email query Activity Assignment comments?

    Hello All, have possible use email query get Activity Assignment comments? I use this code. but comments get error information, and close by show resent ID. the following is query list <Item type="Activity" id="${Item/ActivityId}" action…
  • Best way to highlight (fully) federated data in grids and views?

    Hi community, does anyone has some ideas how to highlight federated data? I have some ItemTypes that show data from other data sources. The data is not mixed with Innovator data, it´s complete external content. I added a few customizations so also…
  • How to use "In" Operator in TGV query builder

    In TGV multi value list datatype is present & we need to filter data based on comma separated selection value. but In operator is not present in where conditions. If we select 1 record it is working fine but if we select multiple record in dropdown it…
  • How to use Visual Studio Code 2022 for Coding Methods

    I am new to Aras development, and I'd like to use Visual Studio Code 2022 ("VS Code") for coding Innovator methods. I found the ArasVSMethodPlugin project on GitHub , and its change log indicates that support for VS Code 2022 was added in version 1.21…
  • Not showing federated item data (separate federation)

    hi All, I am trying to create a separate federation in which I have a json file and I want to process the data and show to the search dialog box(logic is already implemented), method is executing but not showing any error but my data is not showing on…
  • How to check if a floating license(xPlm CadConnector) is in use or not?

    We have 5 floating licenses of xPlmCad connector. Sometimes, the license is not released when the user logs out. We were given a new key to use and we want to try it out. How\Where do I check to see if the floating license is in use? It would be great…
  • How to use explicit xProperties in ItemType?

    Hi community, is any familiar with using explicit xProperties in ItemTypes? Inside of a ItemType there is a relationships "xProperties". When can add custom xProperties there. These new properties will be automatically linked in the grid so user…