Browse By Tags

  • 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…
  • 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 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…
  • Can't map query elements in tree grid view

    Hi, I have been trying to solve a problem I have with using the tree grid views. I can't seem to map certain elements. I wanted to make a recursive tree grid view based on a relation to a poly item where both poly sources had a relationship to the poly…
  • Reverse Lookups with Query Builder

    Long time users of Aras Innovator may be familiar with configuring an empty relationship to display data using the ReverseItemsGrid.html file included with the PE application. This custom grid lets users easily see the parent items in a database that…