Get the last state of an Object with query definition or REST
Hello ARAS community, once again o would have your advice. to be clear, this is what we have in the table of an object : id REF_NUMBER_ MODIFIED_ ON STATE IS_CURRENT MAJOR_REV 2154BB99E5F046 B 2019-11-06 09:43:54.560 Working 1 A 2A7B8BD203A54C C 2019-11-06 09:44:03.450 Working 1 A 5E2A1CD82CD14A A 2019-11-06 09:45:41.210 Saved 1 A B3CE5360E24449B A 2019-11-06 09:43:48.837 Working 0 A I need as a result to get the line 1, 2 and 4. this correspond to get all the object at the state Working and only the most recent one. My problem is if i use as filter (state = 'working') AND (is_current = 1) i only get line 1 and 2. the 3 cannot be segregated. Is it possible ? Thank you :)
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 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: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.
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 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 Builder Error
We have an ItemType A and two Relationships Ra and TGV_Ra. In this, we are trying to get the details of Part Items which are present in this Relationship Ra and populating those in the Relationship TGV_Ra. But we've been getting this error - <SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../" xmlns:i18n="">http://www.aras.com/I18N"> <SOAP-ENV:Body> <SOAP-ENV:Fault> <faultcode>1</faultcode> <faultactor /> <faultstring>Failed to arrange records by desc order Failed to retrieve ItemType </faultstring> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> Can someone help me with this?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?
