• Connecting to Linked Server (External SQL Database)

    Hello all, After many attempts and support of Aras Support, we are still unable to execute SQL Stored Procedures on an external SQL database. Context Aras Innovator Version 26 SQL Server 2017 Goal Execute a Stored Procedure on an external…
  • How to use Visual Studio Code 2022 for Coding Methods

    I am new to Aras development, and I'd like to use Visual Studio Code 2022 ("VS Code") for coding Innovator methods. I found the ArasVSMethodPlugin project on GitHub , and its change log indicates that support for VS Code 2022 was added in version 1.21…
  • Code Snippet: Generic, Reusable Code to Get All Identities In a Group

    Hello everyone, Here is a code snippet to retrieve all identities in a identity (group) recursively. As I faced this requirement multiple times, and Innovator not having a standard function for it, I decided to create it myself. //*************…
  • Looking for equivalent of SQL select max(property) in IOM

    I am looking for the equivalent to select max(property) in IOM. The below SQL query returns exactly what I want, but I understand that this should be used as a last resort and want to make sure I'm not missing something. select MAX(item_number) FROM…
  • Need Guidance: Prevent On Close Server Event to get called when there is Error (when voting) and the CM Activity is not Closed?

    Hello All, I'm creating a server-side method that sends an email to the Change Leader. It gets invoked " on close " in association with a Change Management workflow activity. The email should be sent only when the activity is closed, and the workflow…
  • Technical Documentation - Content Generator for an Image?

    In Tech Docs Content Generator examples, I've run across: this.Factory.NewItemProperty this.Factory.NewText this.Factory.NewTable this.Factory.NewElement I'm trying to pull a Graphic from another item (requirement) and apply it into the…
  • Calling SearchDialog from Server method

    Hi, Is it possible to show SearchDialog from a Server method? I can use MaximazableDialog in Javascript to show the SearchDialog and get the response in callback. But I want to use such facility in a Server method. In my particular case, I am trying…
  • Property validation - Dialog to Confirm Ok or Not

    Hello All, I've been struggling with a property validation use-case and I'm sure it's something that'd be useful to lots of folks. Have a working server event that blocks the user from proceeding if a certain property is left blank; however there…
  • How to use GrantIdentity ?

    Hi, On ARAS R12, in server methods, I needed to grant temporary some rights. For that, I did something like this: var myidentity = Aras.Server.Security.Identity.GetByName("My Identity"); bool PermissionWasSet = Aras.Server.Security.Permissions.GrantIdentity…
  • How does Aras handle the action(s) on a collection of items in an AML?

    I have written a server method that uses some custom XML-like AML to implement an inventory reconciliation. I would like to pass in a collection of items for this method to act on. When I implement a server call like: <AML> <Item type="Part" id…
  • ARAS 12 - Before saving children's Item Type get the ID of the parent's Item Type

    Hello everyone, Try explain, my scenario: I have the Item Types related: 1° Item type Authorization. 2° Item type AuthorizationTittle. 3° Item type AuthorizationTittleRelation (only to related). In the Authorization register view, I…
  • Send emails from a C# Method not working

    Hello, I am trying to send an email from within a C# method but I am not receiving the message in my email. My code is made up of trying to check a url and then return if the url returned with an OK status or a 404 Error. When I get to the part where…
  • Merge pdfs and convert csv to pdf

    Hi everyone, I want to add the data in a relationship in table form in a preexisting pdf.I am thinking making a csv from relationships than converting to pdf using some libraries and then merging both the pdfs.I tried itext7 but aras toolbar disappears…
  • Server Side API to get connection string or URL

    From the Server side API, how do I get the connection string (i.e. Server, SQL Database)? I need it to execute custom SQL code that joins data from another database. From the Client Side, I can use var url = aras.getServerBaseURL(); var base = aras…
  • Identify when affected Items' server methods are being invoked on Express ECO Release/Revise?

    I have some Custom BOM Item Types controlled by the Express ECO. On the custom Items we have the on Before Update and On after Update Server Events responsible for formulating the name(based on some specific field values) of these Items. Is there…
  • What is the best way to validate whether an item has a parent?

    I'm trying to send an email on promotion to "Released" of Parts when a couple of criteria are met, the parts being of a certain custom classification we've added, and them not being used in another BOM anywhere (i.e. they're top-level Parts being released…
  • Debugging Server Method

    Hello All, I am new to Aras. Since I have 15+ experience .net. Willing to learn and get updated. I have download and gone thru programming guide. I have installed and setup Aras Innovator in IIS. I have added element in config file. I am not able to…
  • Get the Context Action Name in the Method

    Hi All, I have Multiple Server Side Item Actions Configured on the Part Item , I want the logic/functionality to be performed by each action to be controlled by the same method . In which case , is there a way to pass the Invoking action name to the…
  • How to return JSON from a odata method

    Hi, I created a a serveur method named COCO_MONITORING returning a JSON like this var innovator = this.getInnovator(); var output= new Newtonsoft.Json.Linq.JObject(); .... return innovator.newResult(output.ToString(Newtonsoft.Json.Formatting.None…
  • Run Action from Relationship

    I have an Itemtype A and a relationship to Itemtype B On the Main grid of ItemType B I have an action which works perfectly fine On Itemtype A in the relationship Grid where there is ItemType B if i place my action there It does not work. I was wondering…
  • how to execute in multithread

    Hi all, Could you please explain how we can execute in multiple threads? And how to rollback all transactions in these threads when if an error occurs. Kindly help. Thanks. Gantulga
  • Commit the transaction half way through the code and continue the execution from there.

    Hi Team, We have a scenario where we want to commit the transaction half way through the code and continue the execution from there. For example : 1. We are working on Background tasks implementation 2. Where we want to change the status [property…
  • How to debug server side code in ARAS?

    I have added the breakpoint if (System.Diagnostics.Debugger.Launch()) System.Diagnostics.Debugger.Break(); It hits on the method breakpoint in Visual Studio, but I can't see the code nor I can step into it either. Also attaching the error occured…
  • How to rollup cycle time and setup time of operations and set that value to a process plan property

    Hi, I have a property called 'duration' in mpp_ProcessPlan and i would like to fill that Property value with sum of cycle time + setup time of all the operations associated with a process plan. how to write server side method for relationship Types…
  • Retrieving Related Items

    I need to take a "Requirement Document" item_number, find all the related "Requirement Document Requirements" and their "Requirements". Looking at the solution for Unit 8 in the v12 Developing Solutions guide I got a pretty good idea how to do this…