How to avoid the additional helper window when creating a report?
Hi, this is not really an urgent topic, but it´s something I wanted to ask for an eternity. When we create a new Report (e.g. Multilevel BOM Report), we will always get an additional empty tab that works as helper window. User have to close the window to work with Innovator again. But espcially new users often forget to close it and than are confused why they cannot use their Innovator any more. Is it somehow possible to avoid the helper window? Or automatically close it after the report was generated? Thanks! AngelaSolved5.8KViews0likes5CommentsDefine context item for query called via method
Hi, I am referencing this blog post: https://community.aras.com/b/english/posts/using-query-definitions-method-code I am running a query via method, how can I set the condition as the query seems to return all possible results without a context item.948Views0likes1CommentSQL Server Reporting Services (SSRS) via HTTPS in Innovator Release 2023. How to fix?
Hi community, the release notes of Innovator 26 mentions following fixed issue: I-050277 Fixed an error that prevented Aras Innovator from connecting to SQL Server Reporting Services via HTTPS. I did a quick test in Release 2023 and noticed that I cannot create SSRS reports via HTTPS in this release. When executing the Report, I get following error message: "The provided URI scheme 'https' is invalid; expected 'http'. (Parameter 'via')". I assume Release 2023 still contains the bug that was patched with Innovator 26. Release 2023 removed the RSGateway.aspx that was previously used to connect to SSRS. Not sure how Aras calls the reports in the new versions. Does anyone know how to fix this one? I assume we need to customize the codetree, add some assembly binding or similar. But I have no idea so far how to do it. Thanks and best regards! Angela576Views0likes4CommentsGraph Navigation
I am trying to set up Graph Navigation as per below documentation https://community.aras.com/b/english/posts/getting-started-with-graph-navigation But after adding the graph view to an itemtype. i set all the required as per documentation . when i open the Graph i see screen as mentioned below But i wanted to get rid of those ARAS ID's marked in yellow , i just want structure to be visible. can you help me fix it5.4KViews0likes3CommentsC# SQL Date Query
Good day all, I am trying to create a dynamic report to produce the time it take between starting an activity and ending an activity. I can get the information I am looking for by using SQL, but it will not limit the returns based on dates. I have tried a few different ways to do this, but nothing is working for me. Thanks for any help you can provide. [embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:ed95bac7-b9b0-4d83-9998-62b7a1797922:type=text&text=StringBuilder%20sql%20%3D%20new%20StringBuilder%28%29%3B%0A%20%20%20%20sql.AppendLine%28%0A%20%20%20%20%20%20%20%20%22Select%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22WP.name%20AS%20change%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22WP.state%20AS%20status%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22Act.name%20AS%20activity%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22ClosedBy.keyed_name%20AS%20closed_by%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22Act_Assign.created_on%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22Act_Assign.closed_on%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22Act_Assign.modified_on%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22GETDATE%28%29%20AS%20today%2C%20%22%20%2B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22DATEDIFF%20%28d%2C%20%5BAct_Assign%5D.created_on%2C%20%5BAct_Assign%5D.closed_on%29%20%2B%201%20AS%20date_diff%20%22%20%2B%0A%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%22FROM%20%5BWorkflow_Process%5D%20AS%20WP%20%22%20%2B%0A%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%22INNER%20JOIN%20%5BWorkflow_Process_Activity%5D%20AS%20WPA%20ON%20WPA.source_id%20%3D%20WP.id%20%22%20%2B%0A%20%20%20%20%20%20%20%20%22INNER%20JOIN%20%5BActivity%5D%20AS%20Act%20ON%20Act.id%20%3D%20WPA.related_id%20%22%20%2B%0A%20%20%20%20%20%20%20%20%22INNER%20JOIN%20%5BActivity_Assignment%5D%20AS%20Act_Assign%20ON%20Act_Assign.source_id%20%3D%20Act.id%20%22%20%2B%0A%20%20%20%20%20%20%20%20%22INNER%20JOIN%20%5Bsm_Change%5D%20as%20Change%20ON%20Change.item_number%20%3D%20WP.name%20%22%20%2B%0A%20%20%20%20%20%20%20%20%22LEFT%20OUTER%20JOIN%20%5BUser%5D%20AS%20ClosedBy%20ON%20ClosedBy.id%20%3D%20Act_Assign.closed_by%20%22%20%2B%0A%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%22WHERE%20WP.name%20%3D%20%27CR-1091%27%20OR%20WP.name%20%3D%20%27CR-1169%27%20%22%20%2B%20%2F%2F%20AND%20Act.name%20%3D%20%27ECR%20Approval%27%20%0A%20%20%20%20%20%20%20%20%22AND%20Act_Assign.modified_on%20BETWEEN%20%272023-08-01%27%20AND%20%272023-08-02%27%20%22%20%2B%0A%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%22ORDER%20BY%20WP.name%2C%20Act_Assign.created_on%20ASC%2C%20Act_Assign.closed_on%20DESC%20%22%0A%20%20%20%20%29%3B]Solved0Views0likes7CommentsSelf Service Reporting
Hi ARAS Experts, I have a question. I have been building some Self Service Reports in an ARAS 11 instance. I think that they could be very useful in our Environment. I have the following questions: Can I E-Mail a URL to the Report. If so how? ( I dont want to use exported pdf ect, I like the dynamic nature of the Report within ARAS) Can I link each row in the table to the associated Item so that it will open up within the same ARAS instance. In "Properties", I have played with the advanced property Settings. I can turn an entry in the table to a Hyperlink that will open a specific Item (FQDN), what I cant do is put the right variable in the URL to link to the associated item.5.5KViews0likes4CommentsRun Aras Report from Method
Good day all, How do I run an Aras report from a Method? I have several reports that I have created in Aras (not MS Report Services) and I can't figure out how to run one from a method. I'm trying to create a Modal Dialog so the use can pick the report and information needed, then run the report. I noticed that there is an applyMethod (and others), but it didn't seem to work when I tried applyReport (I was hoping it would be that simple). Thank you for any help you can provide.Solved2.5KViews0likes2CommentsContext from method to called email
I've got an email that I'm calling from a "post" method on the Part lifecycle, but the default context that's passed to that email message isn't the Part, it instead seems to be the alphabetically first Identity in my database? Why is this happening, and is it possible to (and how can I) pass the Part as the context item to the email, so I can use xpath variables for that part in the email? Alternatively, if there's a good way to just find the part that's being promoted via the email message query, that's fine too. That's the goal, however I need to get there. Here's the method that's running, for what it's worth: Innovator inn = this.getInnovator(); if (this.getProperty("classification", "") == "Hull Assembly") { Item checkIsRoot = this.newItem("Part BOM","get"); checkIsRoot.setAttribute("select","id"); checkIsRoot.setAttribute("maxRecords","1"); checkIsRoot.setProperty("related_id",this.getID()); checkIsRoot = checkIsRoot.apply(); if(checkIsRoot.isError()) { //First grab an identity to send the mail to. Item iden = inn.getItemById("Identity", "097FB092EBDE42EB9E5A274ABC0059DA"); //Next, grab the email we want Item myResult = inn.applyAML("<AML>"+ "<Item type='Email Message' action='get'>"+ "<name>BOM_Release</name>"+ "</Item></AML>"); Item myEmail = myResult.getItemByIndex(0); iden.email(myEmail, iden); } } return this;Solved2.9KViews0likes2CommentsReport Query Question
Good day all, I am trying to figure out why I can't a couple of reports to run. I know part of the problem is that our database does not use the OOTB Part ItemType. Our Parts List is a document ItemType and it links (weirdly) to our Part. I have this report that I don't understand what it is trying to do. Thanks for any help you can provide. Name: s_IPL Label: Indentured Parts List Type: Item Location: Service Target: Window Report Query: np:top_part_id=<xsl:value-of select="@id"/>&rs:Format=EXCELOPENXML7.3KViews0likes8Comments