Discussion Categories

I have below grid of data but i want to sort the below data by Month. User have dropdown option to select sort field as month and sort by like ascending or descending. The challenges am facing here is , since we kept month as text field its sorting in an Alphabetical order. can anyone help how do i do the sorting to get the month in a calendar order (Jan to Dec). Month        Vehical Brand    Repair  NewApril           BMW                 Yes      yesJanuary     Tata                    No       yesDecember Toyato                yes      No March        Audi                   Yes      yesMay           Kia  &

HI guys I'm chasing my tail here. We are assessing software against 4 criteria per software title. For each criterion we have a different assessor group. The software titles are kept in a list of map since they are not yet approved for our Allow List and we don't want to keep the data if they are not approved. We have a custom comments record type which has a many-to-one relationship with the software table. Issue: For each software title we need to keep 4 comments, but I find I am only able to overwrite the comments value, not append.Here's the code for my approval details interface:a!localVariables( local!softwareCategoryList: rule!getSoftwareCategoryList( includeDisabled: false, includedSoftwareCategoryID: if( a!isNullOrEmpty( ri!mappedValue.software[Global Software.fields.id'] ), null, ri!mappedValue.software['recordType!Global Software.fields.softwareCategoryID'] ) ), a!gridLayout( label: "Approve Software", lab

In Process HQ i am not able to see the ADD PROCESS button under Process Insights tab as shown in the picture. Could anybody please help me with that? Thanks in advance. 

I'm facing an issue related to timestamp precision in an Oracle table that’s used with Appian. The table has two timestamp columns: one with zero precision (Datatype - TIMESTAMP(0)) one with six precision (Datatype - TIMESTAMP(6)) When I insert data into these columns without any triggers enabled, everything works as expected: the zero precision column doesn’t include milliseconds, and the six precision column includes milliseconds. However, when I add a trigger to the zero-precision column, I get an error saying the actual timestamp precision is 7, but received 11 even though the column is defined with zero precision and the trigger only defaults it to SYSTIMESTAMP if null. Why would the trigger suddenly cause exception , wanted to understand the logic better 

can anyone help me as to how to get access to admin console my community account is somehow set to basic user and I am not able to change the setting to system administrator

Hi Community, We’re planning to upgrade our on-premise Appian environment from version 23.3 to 25.3. Based on the official documentation, it appears that a direct upgrade isn’t supported, and we’ll need to follow a sequential path: 23.3 → 25.1 → 25.3. I’d appreciate any insights on the following: Is this sequential upgrade path (via 25.1) the recommended or most stable approach? For those running Appian in a High Availability (HA) setup, how did you manage the upgrade across multiple instances? Were there any challenges or performance impacts during the production upgrade, especially related to backup/restore of large volumes of data? Any lessons learned or best practices you’d recommend to ensure a smooth upgrade? Thanks in advance for your guidance and experiences! Best, Ramanji

We have created an Expression Rule named abc, where data is fetched from a Record Type with Smart Search enabled. The results are sorted in descending order of similarity score. Smart Search is enabled on the Full Name and Address fields. For example, the address field contains values like "St.", and we expect that when a user searches for "Street", addresses containing "St." should receive the highest similarity scores. However, we are observing unexpected behavior. For instance, the address "1817 W Broadway Columbia MO 65218" sometimes receives a higher similarity score than addresses that explicitly contain "St.". Additionally, we would like to understand how Smart Search handles nickname matching—for example, whether a search for "Leo" would return results like "Leonardo" with a high similarity score. Request: Could you please help us understand how similarity scores are calculated in Smart Search? Is t

Hello, We recently upgraded our Windows Server from 2016 to 2022. The Appian version remained the same at 24.1, and the Appian home directory is still at D:\Appian. We did not make any changes within Appian itself. The database server, MS SQL Server, was also upgraded from 2016 to 2022. After the server upgrade, the Appian engines and Tomcat application server started successfully. However, images are not loading on the sites. When I checked the logs, I found the following error related to this issue.I did the Test connection for DB in Admin console and it was successful.Any suggestion to resolve this issue? Thanks,Venu. 2025-09-11 01:26:47,429 [http-nio-80-exec-2] ERROR com.appiancorp.rest.shared.FallbackExceptionMapper - Internal Server Error on REST API invocation.java.io.IOException: unknown PGP public key algorithm encountered: -86 at org.bouncycastle.bcpg.PublicKeyPacket.<init>(Unknown Source) at org.bouncycastle.bcpg.PublicSubkeyPacket.<init>(Unknown Source) at or

Is there a hard character limit on the integration's HTTP response? I’ve noticed that text values exceeding 4,000 characters aren’t being returned—just wanted to confirm if this is a known constraint. Also, while performing searches, it seems the maximum number of records returned is capped at 200. For example, when trying to retrieve information for 500 users including their addresses and phone numbers, we’re only getting data for 200 users. Is there a way to increase this limit or paginate through the results?

if( rule!APN_isBlank(singlePV: ri!date), "", /*left(text(ri!date, "mmm",3), ri!format))*/ left(text(ri!date,"mmm",3), ri!format)) Following is the error  Expression evaluation error at function 'text' [line 7]: Signature length (2) does not match parameter length (3)

I just created a process which extracts data from pdf and then uses a reconcile doc extraction to extract tables' data and submit the operation. My question is: do I have to use tables for nested data or I could just try to use text to extract all the data without any need in using reconcile doc extraction task? Is there any way to integrate the reconcile doc extraction in my own customized interface?

Hi i have a process variable called request_data which is cdt type and in that there was one column called casettnotes which is a cdt casenotes cdt has currently 4 rows of data in that there was a column casenote which i need to update which is 4th row case note column data for this i dont have primary value it was null so i tried using other column which is issuetype like if issuetype is failed then update casenot for that issue type like that, all i want the casenote column which is 4th row column in casettnotes cdt need to be updated how to acheive this tried using many alforeach with update function but nothing working kindly suggest on this

Hey everyone, I need to use the Fill PDF plugin in my Appian project. I have to create PDF documents where users of my application can add items, such as their name. I've built an interface that includes a 'paragraphField' containing the text of my PDF. I've used this interface as a form for my Fill PDF plugin. Can anyone help me better understand how the Fill PDF plugin works? I couldn't find any documentation.

Good day everyone, I am making use of a coulpe a!pickerFieldRecords(), but in one instance it displays the corrcet values and in the other it doesn't. Please see the screenshots I've uplaoded illustrating what's being returned for both instances. Also see the code for both instances. # Values are displaying incorrectly - a!pickerFieldRecords( label: "Property Type", labelPosition: local!labelPosition, placeholder: "Search for the property type", maxSelections: 1, recordType: 'recordType!{7068b0aa-dd81-434e-a6a2-049c4ebc1894}AH Property Type', value: ri!record['recordType!{b4e98f0d-2927-4efc-87fb-bc265c91339e}AH Risk Location.fields.{7b7cc88a-959d-4ca2-b6df-dd684e8df4cf}property_type_id'], saveInto: ri!record['recordType!{b4e98f0d-2927-4efc-87fb-bc265c91339e}AH Risk Location.fields.{7b7cc88a-959d-4ca2-b6df-dd684e8df4cf}property_type_id'], required: true, marginAbove: "LESS", showRecordLinks: false ), # Values are displaying cor

I want to know if there is anyway can compile appian code in local? Or use git to manage the source code.(Source code not the package download from web). What problem we face is how to develop in parallel。we are a huge team (100 developers). When we develop a new function,  we usually need to use the same object. But appian can not develop in parallel. So we want to find if there is any way we can compile appian code in local.

While trying to call an API, we are getting an the below error: success: false result: null (Null) error: Integration Error title: "The external system could not be found" message: "Appian could not find a DNS address for https://eis-apim.deviq-uat.work.iqvia.com" The call to this API worked fine in POSTMAN and the connected system with the credentials got authorised successfully as well. Is there some kind of setting with the network that needs to be changed to allow calling this integration endpoint?

We would like to open command prompt using appian rpa to execute some batch scripts ..Any pointers how i can accomplish? No luck using Task recorder as it gives 'unsupported error' 

Our Appian applications are composed of many design objects working together. But what happens when they don't? Our new online course, Monitor and Troubleshoot Your Appian Design Objects, is here to help. This training dives into the Health Dashboard and teaches you how to investigate and resolve common issues across Data, Processes, and Rules. Learn to proactively identify and resolve common issues in your Appian applications, ensuring they run smoothly and provide a great user experience. Enroll in the course on Academy Online to sharpen your debugging skills and build more resilient, high-performing applications.

Hi everyone, I’m working on my first Appian build and ran into an issue I haven’t been able to resolve. My save logic seems to save correctly to ri!record, but I’m getting an error related to the record type relationships. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error: xxxx must be indexed by its corresponding record type fields or relationships I suspect the issue is tied to how my record type relationships are configured, but I haven’t been able to figure it out. Has anyone encountered similar issues with saving data to a record type and relationship errors? I’d really appreciate any guidance on reviewing or troubleshooting the save logic and relationships. Thanks in advance!

I get the following error, which doesn't help me understand what could be wrong. The data (at least text fields) was extracted successfully using map, the doc id is passed correctly.

I want to create a custom UI where all my actions are displayed as styled buttons using a!buttonWidget, but still open the native record action dialog (start form, etc.) the way a!recordActionField does. Currently, a!recordActionField works fine for triggering the action and opening the dialog, but it doesn’t give me the same level of styling flexibility as a!buttonWidget. I tried using a!startProcess() inside the saveInto of a button, but that just runs the process silently without opening the dialog. Is there any way to call a record action directly from a button widget (and open its dialog), or is a!recordActionField the only supported method?

Hello Community, We are currently facing challenges with early detection of errors in Appian processes. In our implementation, many flows include killers and orchestrate multiple subprocesses. While Appian’s process monitor allows us to see execution paths and variable values, this visibility is very limited once the processes are archived. As a result, identifying failures in a timely manner is difficult, especially in complex orchestrator flows. What we are looking for is: Early Alerts Is there a way to configure alerts/notifications when: A process fails, A process takes longer than expected, A subprocess does not start or complete as designed? Observability / Logging Are there recommended best practices or design patterns to achieve better observability? For example: persisting process variables, execution history, and error details (including history errors and variable values) into logs or records so we can analyze issues even after processes are archive

According to  [mention:650c85e52fdf47f29168a7d381b7feb7:6b577b8c04704e209d29b6772bf67243:label=Leverage%20JMeter%20in%20Appian%20Load%20Testing%2C] this plug-in  [mention:a056532754bb4d848e4bc838433a0ebd:f7d226abd59f475c9d224a79e3f0ec07] is needed for, or at least greatly streamlines, performance testing in Appian. The app is now unavailable, and a comment on the plug-in page notes that it is out of date. Is this plug-in permanently out of support, and consequently, is that a showstopper for using JMeter in Appian Load Testing? What is the latest guidance?

I have tried to use the AI skill to extract info from pdf. But I notice that the speed of the AI skill is too slow. A doc like this. It takes 5 minutes to execute such a simple document. Is there anyway I can increase the execution speed? Is this because my model is not trained enough? Should I trained my model more?  

i have a store procedure where it has 13 different columns retrieved from 20 different tables i need to get user a link on single click to export data to Excel , and also if possible matched data should  be bold in the excel