General

I'm currently using embedded interfaces with Appian on cloud, but I will migrate to on-premises. Can I keep using them after the migration?And to migrate my applications from cloud can I simply export and then import them on premise, or is not that simple? Thanks!

Dear Team, I am writing to request assistance with configuring Content Security Policy (CSP) in the httpd.conf file for our Appian application hosted on an Apache web server. We aim to enhance our application's security posture by implementing a robust CSP to mitigate risks associated with script-based attacks such as Cross-Site Scripting (XSS). Below is the  CSP configuration  which i get on the application  Content security policy : report-uri /suite/rest/a/logging/latest/csp/report; report-to report;  is there any way to mitigate the issue 

We have a structure in db with an id, INFO, fatherID, level I have to given an ID, have to reconstruct all the Hierarchical Structure under the Given ID The Structure is a Three                                                                                           /------------ID1------------\                                  ID2[fatherID:ID1]                                                                               ID3[fatherID:ID1] ID4[fatherID:ID2] -/&nbsp

HI , I have a requirement where I need to pass Sting values with separate Line to API . here is the  List of Sting with 4 items. “28978937982932090” “28978937982932091” “28978937982932092” “28978937982932093” I want to send it as single string with line break to API  “28978937982932090 28978937982932090 28978937982932090 28978937982932090” Can you help me with this scenario. Thanks in advance

I've been having trouble writing to a record that wasn't giving me trouble last week. I decided to rebuild the record as that seemed like a quicker solution than figuring out what weird issue that was. However, now when I am generating record actions for the record, appian generates them in a completely separate application. The components don't even show up in the application I am building in, they just show in another one, even using that other prefix for the various generated objects. What is going on?

Hi, We are using Base64 Expressions plugin in our application in so many interfaces now this plugin is vulnerable and need to find the alternative for this plugin. can someone please help on this? Note: we are using it to encode and decode the text.

Hello, I'm using the code below, enter ../ it's redirected to "Access Denied",  any idea why? I don't see any error logged in the Tomcat log. a!localVariables( local!searchKeyword, a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Search By Keyword", value: local!searchKeyword, saveInto: { local!searchKeyword, a!save( local!searchKeyword, trim(local!searchKeyword) ) }, refreshAfter: "KEYPRESS" ) } ) } ) )

Question: We are running a process model which has considerable number of steps, where few in a loop to accomplish our goal. We could see the 'Process Details' printing the values which is really helping us to debug and verify. But 'Process Details' could print this only for the first few steps but not for the rest of the steps (in the later stages of the process model). How can we see the complete log of all the 'Process Details' and variable values.

Hi Everyone, Can we exit from a!forEach() loop?  I have a use case , where I need to iterate through the list of users and once the condition met ( checking for the user's organization and weight category), I have to stop iterating through the rest of the items. I need order to achieve this, I have to exit from the loop.  How can I achieve this ? Apologies for not clarifying the use case earlier. Use case is given below. Use Case: There is a list of Boxers. Each boxers belongs to particular organization and weight category. I want to select 2 boxers for the match randomly. 2 boxers must belong to same weight category but different organization. To achieve this I was trying to loop through list of boxers and fetch 2 boxers belonging to same weight category but different organization. Once I get 2 different boxers, then I wanted to exit the loop, because I got 2 boxers for the match and don't want to loop further. Note: Weight category and organization are not know

I'm using the "a!startProcess" to call a process model from the Appian interface. The process model takes more than 30 seconds to complete. Is there a way to increase the timeout when calling the process model from the interface.  Do we have property in the a!startProcess for this? We are trying to keep this as a synchronous process. a!startProcess( )

Hi All, what are the different Namespace available in CDT? Thanks in Advance.

I have a requirement to configure "Approve" and "Reject" buttons in an approval email notification. When a user clicks "Approve", it should open a new email draft with the body pre-filled as "Approved." Similarly, if the user clicks "Reject", it should open a new email draft with the body as "Rejected - Rejection Reason: ". I have created an HTML template with Approve and Reject buttons.   It works fine when the HTML template is opened in a browser. However, when I configure the "Send Email" node in the process and using the same HTML template, the email is triggered and delivered to Outlook, but the buttons appear as plain text instead of functioning buttons. What could be the cause of this issue? Can we achieve this in appian? Are there any suggestions or alternate approaches to achieve the desired functionality? What is the best practice for configuring actionable buttons in an email notification, in

I have a timer process, where the timer configured as following: Timer condition is a environment constant, and we a switch in UI where user can change the constants value from false to true or from true to false, to decide whether they want the timer process run It has been working fine, but today when I  turn on the switch, which mean I changed the value of the constant from false to true, the timer process is not triggered Can anyone advise?

Hi, While running the installer getting below error after 'extracting setup files' Error in action ExecuteAction Error in action InstallSelectedFiles

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?