Discussion Categories

Hi  I want to automate Appian server stop process. If I am starting or stopping Tomcat Server can we get the status of it as we get for other servers ? ( Not in tomcat-stdout log ) Thanks in advance .

Hi, I am using a plug-in Advanced Document Templating. 1. I have a docx template, using this I am generating a docx file. Service: DOCX document from template 2. From the generated docx, I am generating a PDF. Service used: PDF document from DOCX Issue is,  In generated PDF there is a table with multiple rows set, this set gets looped dynamic number of times (10). I am getting that table moved to a new/2nd page, but I want that table to start in 1st page and then continue in next page. Issue is only in PDF not in the generated DOCX. Any one experienced this and how did you fix? Thanks, Keerthi

Hi all, I have created an interface from which I can click on a field and access the detail view of the record type used in the interface. From this detail page I have created buttons to perform certain operations from process model, passing the data of the selected row of the record to the process. I would like to do the exact same operations but from the home page, without having to access the detail page, as in the attached screenshot. Maybe even including some related actions. is it possible to do this, and if so, how? I thank everyone in advance

HI EVERYONE, I have a process model and that need to be triggered at every 30mins and it need to be triggered at 15th and 45th minute in everyhour(Eg:- 12:15am, 12:45am, 1:15am, 1:45am ..... an so on.). But in schedule trigger we don't have such option, In interval details I gave 30 mins but based on the publised time and deployemnt time of process model, the scheduled run timings are changing. Irrespective of the deployment time/published time, I want the process model to trigger at 15th and 45th minute in each hour. How can I achieve this?

Hi, need suggestion for the following requirement. We want to place a CSV file generated through Appian within a specific folder path in NFS(Network File System). Appian runs in an EC2 AWS instance and the NFS is a on-prem file location. We are not permitted to mount the NFS and hence looking for solutions.

a!localVariables( local!transactionCDM: index( index( rule!NW_Transaction(ri!transactionId), "result", {} ), "body", {} ), local!documentDetails: index( local!transactionCDM, "supporting_documents", {} ), local!selectedDocument, { if( a!isNotNullOrEmpty(local!selectedDocument), { /*{rule!NW_verticalSpacer(n: 4),*/ rule!NW_UpdateDocumentDetails( selectedDocument: local!selectedDocument, transactionCDM: local!transactionCDM, showWhen: a!isNotNullOrEmpty(local!selectedDocument), transactionId: ri!transactionId ) }, a!cardLayout( contents: { a!recordActionField( actions: a!recordActionItem( action: 'recordType!{fff94020-d948-4267-8934-8f9a465308bd}NW Transaction.actions.{ba411847-1b0f-4a59-a70f-72a877d724f0}uploadDocument', identifier: ri!transactionId ), align:

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