General

Hi all, I'm going crazy about this: I want a multiple dropdown be populated by a d query on a data store: local!config: a!queryEntity( entity:local!dse[ri!dse], query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn(field: ri!fieldName, isGrouping: true) } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ), fetchTotalCount: false ).data[ri!fieldname], and this is my dropdown configuration: a!multipleDropdownField( data:null, placeholder:"null", choiceValues:local!config, choiceLabels:local!config, label: "", labelPosition: "ABOVE", value: ri!value, saveinto: ri!value, searchDisplay: "AUTO", marginBelow: "NONE" ) but in test display it generate this error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!multipleDropdownField [line 4]: A multiple dropdown component [label="Multiple Dropdown"] has a

The following: IMHO, the low code security row should be dynamically converted to a security expression whenever I switch to it and vice-versa. It would save a lot of time. By the way, is it really possible to apply such a security rule into a security expression?  If so, how could I convert this into a security expression? Thanks.

Hello Everyone, We allow users to enter the amounts in the editable grid using the textbox component. (saving these values in the CDT decimal field) And displaying the total amount and validating the total column against other values. Values entered are : 430603.1013871.55117011.6523402.33 Would like to know why the sum function is not giving the value with the correct precision.   And also to calculate the sum with correct precision, do we need to use Fixed?

We have tables we want to create record types from but the tables can have millions of records in them and we only need to filter for certain rows. We're trying to find a way to filter the rows we need in the sync filters but there's a lot of limits on what we can use in the Sync Filters expression. Appian doesn't seem to allow rules or constants but we were able to make use of a!executeStoredProcedureForQuery() to call an SP which would specify the records we want to filter for, as per below: a!localVariables( local!totalCount: tointeger( tostring( index( a!flatten( index( a!executeStoredProcedureForQuery( dataSource: "jdbc/Appian", procedureName: "SND_getPksTotalCountToFilter", timeout: 30, inputs: { a!storedProcedureInput(name: "p_workflow", value: null) } ), "results", null ) ),

Tried using the Log Reader Plugin but it does not read logs from all servers. Any suggestion is appreciated. Thanks 

Hi All, There is a requirement to a get document from the third party system, Can someone suggest a way what is the best way to get the document from the third party system? Below is the implementation that I know, Apart from these any plugins or any other things? 1. Third party systems will return url where the file is located. As soon as user clicks the document can be downloaded into the local system. 2. Thir party systems will return the document in binary format and Integration can convert binary to document from the respsonse.   Apart from this Do we have any other way to get the document from the third party systems? My Next question is  If other systems want to post a document into appian, how exactly web appi will configure it, how the request hader document format will be? Thanks in Advance!

Hi, In our Application, we read an email box and for each email - we should check if it has any attachments and uncompress them. We have a requirement from business to uncompress zip, eml, msg, rar files upto 3 levels in depth and extract data and attachments. Is there a plug-in to achieve this? Any help here would be appreciated. Thanks, Keerthi

Team, want to check on these 2 aspects, which we are attempting to leverage in our Appian solution implementation.   1) We are building a solution to retrieve specific data using XPATH from an XML and mapping it to a target location.                 We will be using the "xpathdocument" function in Appian to fetch the value from XML.   2) We will also be leveraging the below function to obtain our XML. i) Convert the json data we have into an Appian object ii) Then convert the Appian object into XML.   --- something like this ---   local!apoPbj: a!fromJson(ri!ipJson)   local!xmlObj: toxml(local!apoPbj, true, "xml") --- something like this ---   3) Data will be fetched from XML using the 'xpathdocument' method as we mentioned above.   This looks working good when tested. Question: 1) But I see currently "xpathdocument" method supports only

Hello Team, We have a requirement to populate data into an excel template which will spawn for multiple sheets. This would be in a process model as we fetch the data to populate from a rest service. We were able to achieve populating data into the excel template using the using "Export Data Store Entity to Excel Smart Service". It works fine for regular mapping. But we are stuck with these 2 requirements.  1) We are were not able to dynamically insert rows into output excel sheet in this flow, when needed. There is a requirement to dynamically insert and populate rows in certain places (in the template), which we are not able to get through. 2) Also we are looking to see if there are any plugins or ability to dynamically delete redundant sheet from the output excel. Appreciate any inputs and suggestions.

I am an SQL Server Database Administrator and I will be migrating the Appian database from a stand alone SQL 2019 server to a clustered SQL 2022 server that has Always On Availability Group.  The Availability Group will be stretched across two subnets and will employ a listener for the application to connect. My question are: A: Do you see any problems with the configuration I am proposing for the SQL server set up - SQL AG and listener B: What features do I need to have installed on the SQL Server. C: Do I need the Client Tools SDK feature installed on my SQL server - I found it installed on the existing server D: What SQL Database permission are required for the Appian user that connects the app to the SQL server.  I like to work on the least privilege concept Please if you have the answers to these question or if you have a document that illustrates my SQL settings I would appreciate it I look forward to hearing from you Jeffrey

If a user belongs to two different application groups and both the groups are added to user start page (different application), which application start page will they see after logging into Appian?

Hi Everyone,  I recently attempted the Appian L2 certification but unfortunately did not pass. I've been studying using Appian Community videos, documentation, and the official exam objectives. To further enhance my preparation, I'm seeking specific documentation links and topics that are directly relevant to the L2 certification. This will help me verify if I've missed any crucial topics. Additionally, I would appreciate any recommendations for mock exams or practice scenarios focused on senior developer-level questions.  

Hi ,  We need to implement a requirement that limits the number of concurrent sessions per user. For example, if User A logs in through Session 1 and then attempts to log in on another device via Session 2, Session 1 should be terminated. Ultimately, we want only one active session per user at a time. The "Limit Number of Concurrent Sessions Per User Account" setting will allow a minimum of two sessions, but instead of terminating the first session, it will trigger an error when attempting to log in with a new session. is there any way to achieve this functionality? . The Application is on premise 24.4

Hello everyone, I am working on a project and need assistance with segregating output values. Specifically, I want to segregate the values and only retrieve the ones corresponding to a particular column. Can someone guide me on how to achieve this or suggest a solution within Appian to isolate the values from a specific column? Any help would be greatly appreciated! Thank you in advance!

Just wanted to know whether Appian Market is shrinking? Looks like we have fewer Appian openings in job market these days? What is community experience on this?

Hello Community, We are currently using Appian for BPM-related processes, but recently we have started utilizing Appian as a backend service to handle multiple API requests in one of our services. We've defined REST services in Appian, and our clients are now calling these APIs, essentially treating Appian as a web server. However, we are facing some performance challenges, including timeouts and long response times. We also conducted load testing, and the results were below our expectations in terms of performance under heavy loads. My question is: based on your experience, is Appian designed to handle high API request loads in this manner (i.e., functioning like a web server)? Should Appian be used for such purposes, or should this approach be avoided due to potential limitations in handling large-scale API traffic? Any best practices, optimization tips, or insights on the suitability of Appian for this use case would be greatly appreciated! Thank you in advance!

Hi, I run some SAS Programs manually. Is there a way, That I can schedule the run of SAS codes via Appain . Please help

Hi everyone, I’m running into an issue with one of my process models in Appian. The process is supposed to trigger automatically based on a record event, but sometimes it just doesn’t start. There are no errors in the logs, and when I manually start the process, it works perfectly. I’ve already checked the record event settings, confirmed the security permissions, and verified that the process model is published and active. Could this be related to caching, background job scheduling, or something else I might be overlooking? Thanks! If you're looking for top-quality concrete services, take a look at: Concrete Contractors Richmond VA

In the image below, the labels are shown as 0, 10K, 20K on y-axis. How can I change this in Appian? I searched, but there is no field in the a!columnChartField(). I want to do this in a column chart. Please give me a solution.  

Normally when a new application is released there is this guided tour "clicked here to do this", "clicking here does this" if the new user wants to continue, they keep clicking and if they want to they have a choice to exit that tour. Does Appian have any such feature to record such a feature for an application developed/released in Appian? 

Hi All,         I m trying to delete old versions of rules using Delete Rules/Constants smart service in Contents Tools plugin. But i m not able to get the id for the rules folder which is a mandatory input. So is there any way to get this folder ID or any other way/plugin to dynamically delete old versions of rules(As there are more than 200 rules(expression/Interfaces), doing it manually will be time consuming). Request for your suggestions. Thanks in Advance, Pradeep

I had a query regarding Dollar() function. We are using Appian 24.3 version, so we planned to upgrade to 25.1 version. if I see deprecated functions, I can see Dollar() function as well but currently we are using this function. If upgraded to 25.1 Dollar() function wont anymore or it will work for some version (upcoming). Please help us to understand till when it will work. Thanks

Hi, I'm using a record action to open an interface in a new tab. When the new tab opens it shows a Sumary button upside the content, which is not possible to hide, but as an alternative I would like to know if I can show the same interface when pressing the button. Right now when pressed it shows a blank interface as in the image. Thanks!

I have a new install of version 24.2.  When I start tomcat, the log file is filled with "[INFO] Setting Entity Expansion Limit to 100".  Is there a way to stop this line from getting written to the log?

Hi everyone, I'm encountering an error while trying to display user information in a grid column inside an interface. I have attached the code and error. I would appreciate help in order to fix this. a!headerContentLayout( contents: { a!columnsLayout( columns: { a!columnLayout( showWhen: a!isPageWidth({ "DESKTOP", "DESKTOP_WIDE" }), contents: {} ), a!columnLayout( width: "WIDE", contents: { a!sectionLayout( label: "Details", labelSize: "MEDIUM", labelColor: "STANDARD", contents: { a!cardLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( label: "Make", value: {