Browse By Tags

  • 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…
  • Query for Items related to the current user's Identity?

    Looking to build a TGV for our users that basically looks for certain ItemTypes that they are either a creator, owner, or manager of. Trouble I'm running into is how to set the initial Query condition? I tried setting a Where condition of Current…
  • How do I set a where statement on a Query Definition against the current date the query is run?

    I want to only have it pull a specific relationship (Part AML) if a custom date field "Valid To" is greater than the current date. I am able to create the Where that compares it against a specific date, but this query definition is pulled by another process…
  • Apply Sorting on Tree Grid View

    Is there a way to sort rows/content in alphabetical order in tree grid view ?. We have a relationship tab where we add the relationship items , using tree query definition we build a tree grid view but we need to sort the rows in aplbhateical order .…
  • Query definition - Same fields added multiple times, causing issues with graph view

    Intermittent issue Sometimes, the properties that I add 'disappear' when the query is saved. I've previously made the mistake of going back and adding the properties again. It is not always immediately apparent in the query builder that the properties…
  • Query Definition Reuse Query element definition freezes

    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.
  • Query Def & TGV - All Grid Rows Must Have Unique IDs

    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…
  • Aras 12.0 effectivity with OR condition

    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…