Discussion Categories

I am creating a new process model in an application and when I try to set the data type of a PV! to a record type (named "DA Transaction")  It doesn't show me the option to use this record type or any other from the same application. I looked in an older PM from 2020 in the same app and it does have PV! with the correct record type, but if i try to create a new PV in the old PM, again i cant find the record type... I have no clue how to approach this, has anyone seen this before? in the picture you see the old variables with the correct data type and here you see that when i search for it, it doesn't find it. (I tried searching many different ways)

Hi! I´m trying to query a database with the following code (SQL) into the QueryDatabase Smart Service of the Process Model SQL STATEMENT: ------------------------------------------------------------------------------------------------------------------------------------------------------------- Select sum(TotalLineas) as TotalFactura from ( Select PRECIO_UNIT*CANTIDAD as TotalLineas from CPF_LINEAS_FACTURA where ID_PEDIDO = ac!pedidogroup by ID_UNICO ) ------------------------------------------------------------------------------------------------------------------------------------------------------------- If I use the code selected in green it gives no problem. But If I try to include the second "select from"  I have the following error:  What can be causing this? Any help would be useful

How important or realistic is the recommendation to keep under 30 nodes? Has anyone had more than 30 nodes and ran into major issues? How does memory usage impact this?

I have a requirement to copy data from one user form to another. If a user has made one order, it is saved in the database. I need a functionality where I can use the saved order's data to be copied to another form. Does anyone know how can I achieve this functionality?  Example would be very helpful.Thanks

Hi, I had an requirement to send a file over SFTP. To acheive that  i had created key under third party credential in admin console(Remote server). Using that specific key in send file over SFTP plugin. But getting below error. Error establishing SFTP connection. Confirm your hostname, username and password. See application server log for more details. Error Message: Unable to retrieve credentials from SCS: This plug-in [com.appiancorp.a2.process.runtime.activities.sftp] is not registered to access secured values for the given external system key [sftp-credential]. Check the external systems plug-ins list in the Administration Console.  what could be the reason behind this error?  what does below error mean? Error Message: Unable to retrieve credentials from SCS: This plug-in [com.appiancorp.a2.process.runtime.activities.sftp] is not registered to access secured values for the given external system key [sftp-credential].

We have this defect showing up as "High" in the HealthCheck (done each 2w) of our Appian infra: [Process Model Name] (44.4% of all CPU time, 67.6% of all operations, 117 mins of CPU time, 3213596 operation count) We don't have a huge number of processes of this type per day (around 600 complete), and the number of nodes is low. We also see in the same HealthCheck that the input interface it uses is called 1 million times! Interface.[Process Model Input Interface] (1056180 calls, 113 ms peak average) There is no way our one hundred users could call the interface one million times - there would be many more processes per day. Has anyone ever encountered such a repeated call to an input interface, causing huge CPU usage for a single process? Is it possible that the 1'500 such "Active" processes (kept as drafts of user input) be somehow regularly polled, thus calling the input task, and cause the huge number of calls to the interface ? If the above is pos

Can use Integration in records? how to use integration to manage records and whether it's possible to integrate records?

Hi! I was trying to use a query to obtain a value from a database. Concretely, I want to return the value of a custom record field, with some conditions/filters (the Purchase Order ID should be equal to the one used in the process, and the Status of the Invoice should be accepted). All of this are conditions based in the same record type. I had to use the custom record field (total invoice price, Record 1) to obtain the sum of the price of each invoice line (Record 2).  As I said,  I have not only source fields in my records, but also custom record fields. The problem here is that I can´t refer to the custom record field (pointed in red in the last picture) via query, because that fields are not shown in the database (cloud console). And the querys directly point to the database.  So, what would you recommend me in order to get the value of the custom record field? Is it possible to add the custom record field to the database, in order to make it possible to

I'm trying to parse a large data file into our sql database.  I have found the import csv to database smart service which would work with the "|" delimiter of the dat file except it has metadata as its first and last lines (not a csv header).  I have uploaded the file into an appian document object, but I can't figure out how to remove those lines so it works with the smart service. I should also note the dat file is coming from an external datasouce and cannot be altered prior to ingestion.

Hi! I´ve made a read-only grid and used it in another interface. The read-only grid contains Purchase Order Lines. I would want to select some or all the rows (PO lines) and change their "Estado Recepción" value from "No Recepcionada" to "Recepcionada" I searched and discovered the possibility to make the rows of the grid selectable. But for what I have seen, this only allows me to save the rows selected, not to change a value of the row directly. ¿Is there a way in appian to assign a button for each row and change a value of the row directly? ¿Or is it possible to put a checkbox component inside each row, so that when you click the checkbox, the status value changes? If not, I was thinking about using the selection, put a button to save the selected rows, and create a process model to change the status of the selected rows What do you think? Do you recommend me another option? Thanks a lot!

Hi All, I have a scenario where i have to populate related action in one of the column in read only grid. For instance, the row with identifier 1 i will populate related action for identifier 2 in that specific column. The issue am facing is that even though i can open that related action with identifier 2, the name of related action is still showing like related action of identifier 1, Note: Am only facing this issue when am using a!recordData as source but I could get desired result when am using a!query record type.You can try this scenario making one value in column as a!recordActionItem(action: record action, identifier: fv!identifier+1 Please suggest if am missing anything here. Thanks in advance!

Hi all - I am building out a document focused application and have created a Document Record that stores document properties, along with a link to the document. I'd like to built out a UI that is similar to Knowledge Center capabilities, but end user focused, as part of our application. For example, (based on roles),  the selectable document list (which i've done), but including actions like Delete, View Properties, File in Folder, Versions, etc.  Similar to KC in the image below. My question is:  Is there a way to embed a subset of knowledge center into my app, with a configurable subset of capabilities?  Or do I built it out myself adding the appropriate related actions?  If the latter, is there a place I can look to see under the covers as to how KC is configured?   And a somewhat related question - i've defined a UI for the user to upload a document and am having trouble figuring out how to map the fileName to my customer record property.

if( not(ri!executeWhen), { data: a!dataSubset( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, sort: ri!pagingInfo.sort, totalCount: 0, data: {}, identifiers: {} ) }, a!localVariables( local!employeeList: cast( typeof( { 'type!{urn:com:appian:types:INO}INO_employee'() } ), ri!employeeDataSubset.data ), local!staffList: index( local!employeeList, where( a!forEach( items: local!employeeList, expression: and( tointeger(fv!item.designationId) = cons!INO_DESIG_ID_STAFF, ) ) ), {} ), local!employeeIdList: index(local!staffList, "internalEmpId", {}), local!operationsCodeIdList: index(local!staffList, "operationsCodeId", {}), local!dateList: if( isnull(ri!selectedDateList), {}, todatasubset( a!forEach( items: ri!selectedDateList,

Hello, We are installing a freshly new windows appian installation and when trying to generate the temporary licence to finish the setup we get the below licence error :  No k4.lic file exists. Any ideas ? Thank you

I have a requirement where we need to send data from tables to PUB/SUB API in JSON formate . for this i tried fetching data from tables using queryentity then converting data to json .While sending we also converting that data to encodebase64string  and touniformstring . here the issue is we are unable to send large amount of data because encodebase64string has limit on characters . Is there any alternate way  to send data . Thanks,

In the grid there are tag fields for different values, initially the values are null as well. For null, the tag field is not working

i want to create a read only grid with selectable rows. the use case is whenever a user selects a row a modify button comes up the interface and after that with the fields autopopulating from the selected grid values. the user can update the required values and they can be updated into the database. how can i achieve this.

Hello! I wanted to build an Admin Tools section using the Charcoal Scheme. I like it overall, but how can I make objects such as dropdowns follow the theme? It just looks a bit out of place when interface objects are still white, and I can't figure out how to change this.

Hi! I´m trying to make a list of elements (local!ListadoMateriales) to use in a dropdown. To make this list, I´m querying a database (CPF_LineasPedidos) and applying a filter (only materials where the idPedido is equal to the selected in a previous interface) The fact here is that my filter is failing (the value must not be null or empty), I think that the "idPedido" value is not flowing from the process model into my new interface 1. Capture of the code. The ri!recordFact refers to the database in which I have the idPedido This is what I want to do: First interface (idPedido selected): Second Interface (the one I´m editing, referred with the code in the end of the post). I want the list to make a dropdown in the "Material" column values. I add that the values Factura, Pedido and Proveedor are SAVED from the last interface referring them inside the function append (line 206) Thanks a lot! This is my code: a!localVariables( local!Lineas

Hi All, AM facing an unknow issue on send email node. In our lower environments the response body is configured as attached below Deployed the same process model in PROD, but i could see additional html tags are added in response body section as shown below This is not happening in send email nodel where response body in wrapped inside expression. Can anyone suggest why this is happening? I deployed the same PM from dev to test to prod... But prod is showing differently. Thanks in advance

Hi Team, I have a column(Assignees) in a record type, there in the filter I'm thinking to write a logic like below a!queryFilter( field: 'recordType!Record Details.fields.assignees', operator: "=", value: loggedInUser() ), id, Assignee(text) ----------------------- 1, "user1;user2" 2, "user2" if the user1 login, record 1 should be displayed in the grid if the user2 login, record 1,2 should be displayed in the grid

Hello. I created a maintenance interface. When I do releasing, all the link are pointing to this maintenance interface. like interceptor, blocking all the link. How to do ?  Thanks.

Hi all, I have two records: Employees and Managers. Each manager has multiple employees (One to many relationship) Manager table is like this: ID NAME LAST NAME Employees table is like this: ID Manager ID Name Last Name When I'm updating the Manager record I want to be able to edit that manager Id of the employees table, since sometimes some employees might change manager or might not have a manager at all. So first , I'm trying that when the user is updating the manager record when they  click on a dynamic link(icon) on the name of the employees under that specific  manager, they can set that to NULL, so basically make that employee no longer have that manager. What is the best way to reference this if I'm using a rule input of type manager in my interface.

Hi! My process Model gives me the following error: When I searched into the process start form and rule inputs, I viewed the yellow message of the map. I don´t understand what is happening exactly Can someone explain me why is this error caused and what can I do to solve it? Thanks a lot!

Hi! I´m trying to create a dropdown field inside an editable grid, based on a list I have created the following list (the choice labels and choice values appear correctly) But the problem appears when I try to add the dropdown field value:  Interface Definition: Expression evaluation error [evaluation ID = 02S6W] : An error occurred while executing a save: Expression evaluation error: You must specify a variable to save into, such as ri!name << fn!sum. Received: Text. My code is the following (problem located around line 71): a!sectionLayout( label: "LÃ%ADneas Factura", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de factura correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Factura"), a!gridLayoutHeaderCell(label: "Factura"), a!gridLayoutHeaderCell(label: "Pedido"),