What if I have an API and I just want to manipulate the results and display it in listview. My goal is to manipulate this result below. I want to summarize the array into one row and convert the tenantName into columns [ { "name": "test1", "summaryGroup": [ { "name": "test1", "tenantName": "TST", "isAvailable": true,…
Is there a Function in Mongoose that can be used as a parameter in SUBSTITUTE that returns a special character (for example the tab newline characters)? I would like to set up an Event Handler that uses these special characters in the email body, resulting in something like the following: 1. PROPERTY({first_property}) 2.…
I am working on a query joining the customer order master, and the address master. I need to join on the company, the customer number, and the customer ship to address. However that column in the Customer order master seems like it has odd enoceding. Like it isn't codepage 37 or CSSID 65535. Column is C6B9CD. Any ideas on…
Hi, We have an event handler created in AES on IDOPostItemInsert that needs to approve the requisition line. We have set multiple approvers on the same prompt to approve the requisition. Now we are trying to capture the approved date based on each approver's response. Is there a way to get a response date based on the…
Hi I am having issues loading an IDO collection for a report form. 1) This IDO has 2 tables po_mst and whse_mst joined by whse.whse and site_ref. I ran it in IdoDataViewer and runs fine. I then check if it will run in DataViews Setup, it will run without the addr##1 property from the whse_mst table. If I add the addr##1…
I am able to get the UserName when using the SyteLine Desktop Client using USERNAME(). However, when the form is opened using the SyteLine Web Client the IIS Datapool App user is returned. I have tried using: USERNAME() System.Security.Principal.WindowsIdentity.GetCurrent().Name Environment.UserName They all return the IIS…
Hello, I am trying to upload file into MT Cloud via Mongoose. I am testing success upload just by showing message with uploaded file path. When file has extension like .txt or .xml everything is working fine. But I often need to process text files with extension like .940 or .bai2 or even without extension. When I try to…
Hello, I am trying to upload file into MT Cloud, and then read this file from Mongoose. I suppose, that file upload is done correctly, I have returned file path: But when I try to read it, I receive IO permission error: So file must be accessed some other way? Here is my Form Script code: using System; using System.IO;…
I have created a Send Email event against SLPoItems that retrieves an e-mail value added to a user field called _ATRO_DerPreqAttn. The event is designed to fire an e-mail to the e-mail address specified in _ATRO_DerPreqAttn when a purchase order is received and it works provided the e-mail is a valid address or series of…
Hi, I need to send XML file from Mongoose to IDM via ION API in MT Cloud. I have this FormScript in which I am downloading XML file from url: //<Ref>System.Net.Http.dll</Ref> using System; using System.IO; using System.Net; using System.Text; using System.Xml; using Mongoose.IDO.Protocol; using Mongoose.Scripting;…
It looks like you're new here. Sign in or register to get started.