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 the unique (distinct) oracle Assembly IDs but I would like to use a Query Definition. In the data model below, what is circled in RED is the Oracle Data. What is circled in Blue is where I am separating a 1) [multi-Division, multi-Ora Org, with non distinct Assemblies (by Ora Org)] : stg_Oracle_MfgItem_MfgItem INTO 2) [single-Division, multi-Ora Org, Distinct Primary Assemblies] stg_eBOM_PartBOM_Primary AND 3) [single-Division, multi-Ora Org, Other Assemblies (without Primary PartBOM)] stg_eBOM_PartBOM_Other The goal is as follows: 2) stg_eBOM_PartBOM_Primary will be used to generate the innovator [Part BOM] relationships 3) stg_eBOM_PartBOM_Other will be compared to stg_eBOM_PartBOM_Primary to derive Substitutes So I would like to use a Query Definition to gather all the Distinct Oracle Assembly IDs so I can populate the stg_eBOM_PartBOM_Primary table. Thanks in advance for your time and insight. Scott
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 automatically and I don't want to have to update the Query Definition every day with the current date for whoever ends up running it that day. I currently have: [Valid to] > '2021-11-29T00:00:00' I want something like (this doesn't work) [Valid to] > current_date()
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 = Name, but that didn't work. Do get results expected when I set a parameter and then execute the query using Name LIKE $first_name... I will be launching from a method, so I presume that could merge it into the startConditionProviderParam = 'startConditionProvider=ItemDefault({"id":"id"})'; segment, but I was hoping there was a way to do this from the Query itself. Has anyone done something similar?
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 . does Aras OOTB has this capability ?
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 have been added multiple times. A graph view based on the query does not properly generate. When the properties are correctly displayed for the query definition (sometimes after re-login, sometimes after restarting Chrome browser), I can see that there are duplicate properties. It would be nice if error proofing were built in, so that this situation would not occur. I'd love to hear about any other ways to steer clear of this issue.
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 top level. But in order to do this I think I would need to have an OR condition in my effectivity criteria. I have been able to programatically set the "EffectivityCriteriaDefinition" parameter of the query definition to filter by 1 option for a variable by setting the parameter like this: <eq> <variable id="item_id_model" /> <named-constant id="item_id_z5" /> </eq> but when I try to use this type of OR value for the parameter the tree grid fails to render: <or> <eq> <variable id="item_id_model" /> <named-constant id="item_id_z5" /> </eq> <eq> <variable id="item_id_unit" /> <constant type="int">10</constant> </eq> </or> Is this a bug in the tree grid/query definition implementation of effectivity or am I approaching this the wrong way? Best Regards RickAras12 add a new Change relationship tab
Hi, I just downloaded Aras12 and see that the part changes tab now relates to a Tree grid view and Query definition. Has anybody with Aras12 tested to create a new change tab and add correct relations? In Aras 12 "PE_Changes" query definition, they have been able to add Simple ECO's etc, but I can't figure out how. I cant see how they did that, due these references are not available as choices when trying to add them to my new query definition Regards//MikaelCan'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 item. I was able to set up a query definition that seems to work fine when i run the test query, but certain elements won't map in the tree grid view. I have tried a few different ways to set up the query and while I've mainly worked in aras 11 sp12, I have also tried it in the open version of aras 12. It seems like the tree grid views have issues mapping element when there are multiple instances of "reuse query definition" in the query. Has anyone encountered or solved this problem? Best Regards Rick Query def: Tree grid view:
