Discussion Categories

Hi everyone, We have a UI requirement involving a read-only data grid. The grid displays values such as student names. When a user hovers over a grid cell, we want to show a clickable tooltip containing a list of related items. Each item in the tooltip should be clickable, and clicking on it should open a dialog box with detailed information. Example Scenario: The grid displays student names. On hovering over a student name, a tooltip appears showing a list of mark sheets by year. Clicking on a specific year opens a dialog box displaying that year's mark sheet. Looking for suggestions or best practices on how to implement this kind of interactive tooltip behavior. Has anyone tackled something similar or used a library/component that supports this? Something like: But the marksheet should be a Dialog Box that is associated with a record action. Thanks in advance!

I'm encountering an issue when trying to access a cloud database URL from Appian. The full URL I'm using is: dev.abc.us-east-2.123.aws/.../index.php However, when I copy and paste this into a new browser tab, the URL gets truncated and only loads as: dev.abc.us-east-2.123.aws/.../index.php Interestingly, I’m not facing this issue with another table from the same schema—its URL works as expected. Has anyone experienced something similar? Could this be related to how Appian encodes or renders the link? Any suggestions on how to preserve the full query string when opening the link? Thanks in advance!

We are using Jira Integration to get most of the Jira fields value. But somehow "Resolved" date field is not coming in response for Jira type as Bug. Appreciate your suggestions.

Appian is evaluating validation before I submit, even though the parameter is set. a!validationMessage( message: "Field is Required", validateAfter: "SUBMIT", showWhen: a!isNullOrEmpty( rule!_process_CurrencySanitizer(a!defaultValue(ri!value, null)) ) ) Why is Appian behaving like that? It should be expecting my submit.

This is my usecase. i have editable grid of data  and also providing user to do the (custom) filter and sorting. But now user want the export those data into excel.we have used EXPORT DSE to Excel smart service to do that. But here the challenges is user applied sort is not working when we export the data. I don't know how to configure that. Can anyone help me here.

I have a read only grid that is supposed to populate with all entries in a record with a certain flag and put that into a read only grid. The problem I run into is that despite the grid displaying only 3 entries at a time, the query keeps timing out because of how large the number of entries is. I need all entries to be available for my functionality and it is set to load as async. Is there a way to bypass the query timeout error?

Hi, Did all steps 2-3 times not sure what am i missing at step 5 application build for "W2375SAA Vehicle" Generate environment record types is not accessible.   choose Database Table I see below Can some one look into this. looking forward to do next steps and learn more.  Thanks, Ami 

1. My requirement is that users can be able to download the reporting interface as pdf using a click of a button. 2. Also if there is any way to export my reporting data in excel (my reporting interface contains- counts of events, dropdowns and charts like- column chart, pie chart, bar chart, etc.)

I'm working on a custom currency input field component and facing a challenging issue with decimal value conversion and rounding when values exceed 10,000 (5+ digits). Here's my current implementation: a!localVariables( a!textField( label: ri!label, labelPosition: a!defaultValue(ri!labelPosition, "ABOVE"), value: a!currency( isoCode: a!defaultValue(ri!isoCode, "BRL"), value: rule!process_BRLInputSanitizer( value: ri!value, toDecimal: true, showSeparators: false ), decimalPlaces: 2, showSeparators: true ), placeholder: ri!placeholder, saveInto: a!localVariables( { a!save( ri!value, a!currency( isoCode: a!defaultValue(ri!isoCode, "BRL"), value: rule!process_BRLInputSanitizer( value: save!value, toDecimal: true, showSeparators: false ), decimalPlaces: 2, showSeparator

Hi , I have a multiple dropdown inside a grid layout , so choice values for that dropdown  previously static one coming from database , but now we have changed it as cascading one based on condition the dropdown choice value will change. Now the existing request are all throwing error. I thought of based on the request created date to change the choice values to be selected but i am not sure where that condition can applied inside the dropdown choice or before , because for new request also for choice values i have applied some if condition . Its not working properly. Can anyone help me to identify the option which is efficient?a!localVariables( local!fundlookup: { a!map(lookupId: 1, value: "Comment A"), a!map(lookupId: 2, value: "Comment B"), a!map(lookupId: 3, value: "Comment C"), a!map(lookupId: 4, value: "Comment D"), a!map(lookupId: 5, value: "Comment E"), a!map(lookupId: 6, value: "Comment F"), a!map(lookupId: 7, value: "Comment G"), a!

 As you can see I am not able to see data type from the list I wanted to create a constant of type Data Store Entity.

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