Discussion Categories

In a Process Model I have added an Execute Stored Procedure and configured everything very well, in Data in the data source I put the constant with the connected system, in the name of the procedure I put the correct one and I configure the 2 input variables of the procedure, save and it is published fine and when it is executed it returns the error: ERROR: insert_in_din_tbl_tests(character varying, integer) is a procedure Hint: To call a procedure, use CALL. Position: 15, I understand that by default the Execute Stored Procedure executes with CALL without any prior configuration, but rather it executes it by default, so I don't understand how to arrange my execution.

We have an application that on a flow assign a series of task to a series of users or group. In this case we have a user that shared to another user  (for internal policy the second one dont have to see, and dont see, the specific set of data related to the task, but this isn't the problem)  The problem is that even the specific task was assigned to a group where there isn't the second user (that have received the task link) if that user use the link, it can see the task. Why? Are there some restriction that i can apply? Obviously we talk about task in report and not in tempo.

Hi Everyone, Is there any way to export data in local variable to excel? The Actual Requirement is 1. I have created some custom columns in Record Type 2. Generated an expression using Aggregation and stored the data in local variable 3. Created a Grid Report using the local variable 4. Now I need to enable download excel option for the data available in local variable But Appian is not allowing to enable showExportButton: true(), and getting below error. Thanks in Advance

Hi Guys, I have a requirement where the user has to fill in around 5000 characters in a paragraph field, is it possible to store 5000 characters to the database ? 

Hello :  My local machine is a windows 11 Home Named ( hostname ) zenbooktxuss .  The temporary license was working ( until it has expired ) . I requested  a permanent license twice .  I selected Local environment , introduced zenbooktxuss.casaredns.ddns.net as FQDN  ( the machine has that domain suffix configured but is not in a windows domain or workgroup)  and the Q output of my machine was something similar to this --> KDB+ 4.0 2023.05.26 Copyright (C) 1993-2023 Kx Systems w64/ 12()core 32574MB jesus zenbooktxuss 192.168.0.49 ... Just with the hostname But the license is registered like --> KDB+ 4.0 2023.05.26 Copyright (C) 1993-2023 Kx Systems w64/ 12()core 32574MB jesus zenbooktxuss.casaredns.ddns.net ..... The hostname was replaced ty the FQDN .  Once i have installed the permanent license . When i test the license 4 with the q script  i get this message . '2024.09.17T08:24:28.985 license error: host ze

Any latest plugin or smart service to call subprocess dynamically ?

Hi everyone,  I'm having this issue not sure if it is something wrong with my code or Appian issue itself, please help.  I'm having an editable grid, the data for it is a data subset type local variable, and in rows I use forEach of its data. I already provided the id for the gridRowLayout(), but not sure why it does not store anything into my local variable. I also tried with fv!index and it does not work either.  This is my input local variable with data subset type:  

hi,  I have a record list with values  {name:"Test1",id:1},{name:"Test1",id:2},{name:"Test2",id:3},{name:"Test1",id:4} my output should show - pid should be concat of the name and the sequence based on count 1. id:1,pid:"Test1001" 2. id:2,pid:"Test1002" 3.id:3,pid:"Test2001" 4.id:4,pid:"Test1003" any code suggestion will help 

Hi Everyone, I have a situation, i want to show the a constant timezone to every user no matter user is from USA, Canada or india, every user should see a constant date and time , No matter user changes his timezone in appian setting , timzzone should be remain same, changes in timezone in appian setting should not impact interface setted timezone, For exmaple: In the I created a record at 13 Sept 2024 12:11 AM IST , but i want to show on the inferface 12 Sept 2024 11:41 PDT, i implement a code when i set my timezone in appian setting as India Standard Time (IST) but when i change my time to PST in appian setting it impacts on interface as well  text( todatetime( gmt( text( gmt(fv!row.createdOn, "750"), "mm/dd/yyyy hh:mm AM/PM" ), ) ), "MM/dd/YYYY HH:MM AM/PM" )

Hello, Is there a way to set a read-only grid to have a height that matches the viewport height? I understand that the "fixed" setting keeps the grid at a set height, but it doesn’t adjust dynamically with the user’s viewport. I’m looking for a solution that combines the behavior of the fixed setting—such as scrolling and locked headers—with a height that adjusts to the available space in the viewport. Using a match statement with a!isPageWidth() won’t work in this case, as it does not provide enough control over the height.  Thank you! Nick

Hi All, Video component is not showing in Android mobile Appian App when the file upload is being used. is it a bug in Appian or is there any hotfix or any other option is available? Please help Regards, Bharat

can someone answer this question. what are the data management techniques in appian As I am new to appian and this is the question that i have faced in an interview

Hi  I am using Import Excel to  Database Smart service and for Datasource I tried to make connection using Connected System .I called the CS in constant using  CS as its type .But in Import excel smart service , Datasource is defined Text type .Is it possible to give DB connection url string as Text and pass it in constant and then use it .If yes then what is correct connection url string?

Hi all, I need to move an Appian 20.4 installation on a Windows server 2012R2 to a Windows server 2022 standard, and I want also to upgrade to Appian 24.1. Has anyone some clues to perform the activity?

Hi everyone, I need help checking whether I’m doing something wrong with my code. I’m having an editable grid with data is a data subset local variable. In it’s gridRowLayout() I also provided the id parameter. But somehow when selecting the row, it does not save any data to local!selectedAzureId. I also tried with fv!index instead of fv!item.fileId but did not work either. And below is local!data – the gridLayout data source:

this kind of output my SP giving me, and I have used print statement of SQL to print this output,  but when I call SP with the correct input Parameter then it's not returning the result.

I am not able to publish portals in appian comunity environment and also not able to create service accounts , can this things be enabled in future.

I have a file that have around 80000+ records and size is around 35MB. I would like to understand the way to read the data in it but need paging to be part of the process as i want this to be inserted into DB.

Hi All,   I have a template document where it has 3 statements and then a table which will display data . But if the data is empty, the table header is also not displaying . But I need the output doc to display the template. table with header row showing no data available. Is this possible, Please suggest some solutions. a!localVariables( local!queryXML: if( toboolean(ri!isFormat)=true(), ri!data, a!forEach( items: reject(fn!isnull,{ri!data}), expression: "" ) ), if( a!isNullOrEmpty(ri!data), "", if( toboolean(ri!isSplit)=true(), local!queryXML, ""& ""&ri!product&""& ""&rule!DIL_testNewDateFormat(date: ri!dateFrom)&" to "&rule!DIL_testNewDateFormat(date: ri!dateTo)&""& ""&ri!type&" listing"& if( ri!type = "Unblinded", "Unblinded Safety Data : Do not share with blinded study personnel", "" )& local!queryXML& "" ) ) )see attachment/resized-image/__size/640x480/__key/communityserver-discussions-

Join Appian experts to learn how you can unlock AI potential using Appian’s latest generative AI skills. In this livestream, you'll see how Appian’s pre-built prompts streamline a wide range of AI-driven tasks, making automation easier than ever. Our experts will showcase real-world use cases, answer your questions, and explore how these AI skills are being implemented across industries. Don’t miss this opportunity to see Appian AI skills in action! Turn on notifications to make sure you don't miss it!

Hi all, I am a beginner of Appian and I am required to change color of each rows in a grid. Even though "Shade alternate rows" is enabled, the contrast is not vague, so I need to do a clear contrast... I hope your help. Best regards,

Can anyone help me with this

Hello everyone, In our Appian setup, we are utilizing SAML within Azure to embed Appian interfaces into an Azure application. We've encountered some issues when attempting to call the Microsoft Graph API, so we decided to create a Bridge API in our Azure application and make calls to it directly using the existing browser token connection. When I log into the application using SAML and then open a new browser window to call our Bridge API, I receive the expected data. However, when using a!httpWrite for a POST request to retrieve the API information, the response only returns an HTTP 200 confirmation code without any actual data. I assumed that no additional authentication methods would be necessary since I'm already connected to the application. Has anyone faced a similar issue or can you suggest anything I might have overlooked? Thanks for your help!

Estoy trabajando en un proyecto grande que ha evolucionado con el tiempo y está compuesto por varios subproyectos independientes, cada uno desarrollado por un equipo diferente. Si bien estas aplicaciones tienen sus propios propósitos, están interconectadas y juntas forman parte de un flujo de trabajo completo. Para contextualizar, un ejemplo sería: • La aplicación A gestiona la creación de una solicitud para construir un edificio. • La aplicación B se encarga de redactar el proyecto junto con los arquitectos. • La aplicación C gestiona los permisos necesarios para la construcción. • La aplicación D gestiona la contratación de personal para realizar la construcción. En total, hay unas diez aplicaciones independientes que en conjunto forman uZn único proceso funcional. El reto al que nos enfrentamos ahora es la creación de una aplicación “padre&rdq

I am trying to create an email that will go to an non Appian user.  I am putting 2 links/buttons in the email for them to click and in turn would like it to start a process.  First, is this even possible?  Second, in my HTLM code, do I set mode to cors or no-cors?  Third, where do I put the authorization in the HTML code?  I set up a service account in the admin console and added it to the user group.