• 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…
  • RE: How to use email query Activity Assignment comments?

    Acrius said: 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…
  • RE: How to use Visual Studio Code 2022 for Coding Methods

    That´s an old question but I would also be happy to hear more about using VS Code. The plugins that I know mostly support regular VS Studio. But in the beginning it´s also totally fine to not use VS at all. I depends on your company and team structure…
  • 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 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…
  • 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 a foreign property in a MAC policy?

    Hi all, I've tried to convert a foreign property to a string on a Document Item Type as foreign properties aren't compatible with MAC policies, but I'm not getting very far. The current thinking is: Create foreign property "input" Create string…
  • RE: How to use explicit xProperties in ItemType?

    Does no one know more? Maybe anyone has an idea for an alternative concept. I have an ItemType that shall store testresults. Each test item shall store additional values of various sensors. So basically my ItemType looks like this: Test-No.: T-1234…