How to get the data of Impact Matrix using Query Builder?
Like the question states. I need to get all the items ( their properties etc) that are associated to a PR(which are ECR, ECO etc.) I also need complete data from the impact matrix of ECO and EDR. When the Impact Matrix relationship is added to the ECO, the Impact Matrix doesn't have the properties such as item_number, Name, Revision etc. These properties are not even close which makes me think I am not going about this the right way. There isn't any other way that I saw to connect the impact matrix to ECO, the only option is via relationship here. Any help is appreciated! Thanks!
Query Builder show database names instead of labels - how to improve property selection for complex data structures?
Hi community, does anyone know how to prevent that Aras use labels for the property selector in the QueryBuilder? I try to extend a Query Definition, but I would prefer if Innovator shows the native database name of the properties instead of the label: Note following situation in the image: - Entries are not distinguishable when they have the same label, like "Document" - Entries are sometimes just blanks where I have removed the label on purpose Innovator doesn´t even seem to honor my perfect sort_order of these properties. Does anyone have an idea how to improve the situation? I currently use a pretty old QueryBuilder version. Maybe situation has improved in newer Innovator versions, but I have to work with what I have [emoticon:44a8a53ad3364ea78a16c5a3229f75bb] Thanks and best regards! Angela
Can I customize Tree Grid View input XML
Hello, Question about Tree Grid View/method functionality. I'm are creating some kind of tree (for example Part BOM) & data comparison tool. I'm utilizing Query builder and I have 2 different query results in my method at hand. And now we are planning how to visualize the comparison results to the user. One idea was to utilize Tree Grid View which would fit well in our plans in many levels, but is it customizable enough is the big question. Can I somehow feed or get TGV to read my results? Can I somehow use CSS or modify how TGV could show the results (for example I want to use colors to show the differences between structures & data)? Or is it so the TGV always need's direct results from Query Builder? And the XML it's eating cannot be changed - or are they way to modify it? Or are there any other ways to do it? I believe this is not unique problem. I'm using query builder similarly like in: https://community.aras.com/b/english/posts/using-query-definitions-method-code. And I'm utilizing Form Dialogues currently to ask from user what to compare. Cheers, Jukka Lehtinen
How do I use "Like" with declared properties in Query Builder?
I would like to use Query Builder to get Plant declared Manufacturing Parts who's item numbers have a Root that are Engineering Part number. Example: Engineering Item Number: 1122345 Manufacturing Item Numbers: 1122345 (ABB), 1122345 (GFD), 1122345 (PLO) In SQL I could use 1) Where [Part].item_number like '1122345%' 2) Where [Part].item_number like CONCAT([Part].item_number,'%') and [Part].classification = 'Manufacturing' I tried the following in the following order as Query Definition Conditions: 1) [Part Number] like '@[Part Number]%' -- This did not work. 2) [Part Number] like '1122345%' -- This did not work Can anyone make a suggestion here? Are there any documents that cover/describe examples of Query Builder Condition Statements? Thanks for the help! 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()
Tree Grid View Filtering
Hello, I've got a multi-level BOM that I'd like users to be able to filter by Name or Part Number. I followed the Query Element Builders Guide and the blog post "Filter a Tree Grid View with Parameters"; however it only works with the parameters at the top level. So if for instance, I've got a part (top level) with a Name of "Part_1" and I use the parameters on the TGV with that, it filters fine. But if I have a sub-part to that, with say a name of "Part_2" and I use the parameters on the TGV to that item, nothing shows up. I'm assuming the problem is in the filter condition... (Name LIKE $name) AND ([Part Number] LIKE $item_number) Can anyone help?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?
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.
Query Builder & Poly Sources
Good day all. I am on v11 SP10, and the previous caretakers of the system did not use the OOTB ItemTypes. I would like to build a Query Definition to find Illustrations that are associated with a manual. All of the document ItemTypes are part of an All Documents Poly Source. The Illustrations are associated to All Documents, not the Manual ItemType. Is it possible to do this or will I have to do something else? Thank you for your help.
