Foundation

Good afternoon, We are using the send file over node to put a file in an sftp. But when we run it, it tells us this in the log: com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.sftp_conn=Error establishing SFTP connection. Confirm your hostname, username and password. See application server log for more details. Error Message: java.net.ConnectException: Connection timed out (Connection timed out)]                And it says that it is caused by Caused by: com.jcraft.jsch.JSchException: java.net.ConnectException: Connection timed out (Connection timed out)                 at com.jcraft.jsch.Util.createSocket(Util.java:349)                 at com.jcraft.jsch.Session.connect(Session.java:215)              

Hi All, I have requirement where i need to display the API data which is in hierarchical pattern. which we need to display in hierarchyBrowserFieldColumns. I have implemented the hierarchy but we need a filter to selected any values from that hierarchy, to achieve that i have used a custom picker but how i need some input from you guys to implement that scenario. Any help  the data from API is in the format { a!map( id: "1234", body: "Test1", title: "Title1", name: "Name1", Array: { a!map( id: "12345", body: "Test2", title: "Title2", name: "Name2", lastname: { "Array2" } ), a!map( id: "123456", body: "Test3", title: "Title3", name: "Name3", lastname: { "Array3" } ) } ), a!map( id: "123456", body: "Test2", title: "Title5", name: "Name5", Array: { a!map( id: "12345545", body: "Test2&qu

Hi everyone, I'm on 21.3 and noticing that Section labels aren't being read out by a screen reader despite what the documentation seems to state: https://docs.appian.com/suite/help/21.3/ux_accessibility.html#use-accessible-headers Using NVDA on Firefox. Here is a sample of the code. Am I missing something? a!sectionLayout( label: "Section 1", accessibilityText: "Section 1 Accessiblity Text", labelHeadingTag: "H2", divider: "ABOVE", dividerColor: "ACCENT", contents: { a!sectionLayout( label: "Field Set 1", accessibilityText: "Section 2 Accessiblity Text", labelHeadingTag: "H3", divider: "ABOVE", contents: { a!columnsLayout( columns: { a!columnLayout( contents: a!dropdownField( label: "Field 1", placeholder: "Placeholder", value: index(ri!formData.FORM_DATA_SECTION1, "field1", null), saveInto: ri!formData.FORM_DATA_SECTION1.field1,

At what stage of Appian Delivery Methodology we repeatedly do backlog refinement. Is it the Build or the Optimize stage or am I missing something?

Hi Appian Developers, I hope you all are doing well and safe. I have created a Facebook group for Appian Developers so that people can understand about Appian technology outside too. Please join the group at https://www.facebook.com/groups/appiandevelopers to share the questions/answers and contents about Appian. Regards, Shubham Kumar

Hi, I'm experiencing the following behaviour. To the best of my knowledege it is not the expected one, but maybe I'm wrong. I have a process with an usertask node assigned to two groups. Lets call these groups A and B. User1 belongs to Group A, and dont belog to Group B. When the process is started, it creates the task, lets call it task 1, corresponding to mentioned usertask assigned to groups A and B. I check on a report task of type "Task attributed to user" with User1 in context, task 1 is included. So far so good. Then I remove User1 from Group A. What I expect is that task 1 disappear from the report, but it remains on the report (of course I refresh it once and again) until no less than half an hour. After 30 minutes more or less, it is not an exact measure, report shows correct tasks, I mean, task 1 is not showing any more on the report. I assume that this is not the expected behaviour ¿Am I wrong? Regards

i'm trying to get the billNo of this invoice object   but when i try to retrive it  i get null values if  i use  the index function  if i don't use index function i get an error saying the error that i just wrote in the subject  the only way for me to get this information is just getting all    the values  how could i  get just one value ? bellow i'm gonna let you some examples of  what i see.

The video sound does not work in Appian Academy lesson Create an Application: First Steps. Tried Chrome and Firefox but that did not fix the problem.  Sound works fine in both browsers  for non-Appian websites.  Sent multiple emails to 'academy@appian.com' and received  auto-response  emails only. But sound has not been fixed and have not received any communications other than the auto-response emails. Suggestions on fixing the source so I can use the Applian Academy lessons? Thanks for the help.

Hello there, I've used the index() and property() function for years to pull from CDTs and dictionaries however I've recently run into a problem where both functions are no longer working as expected.  Am I crazy here or is there something else going on? I would expect both of the following statements to return "999" however, I am actually receiving "null" as the output.   fn!index({startYear: 2022}, "YogiBear", "999") fn!property({startYear: 2022}, "YogiBear", "999") The screenshot below shows several varieties of the call, along with proof of dictionary format and content, returning null instead of the defaultValue from the index function.  I am able to reproduce this in 4 different environments including a cloud setup.

Hi All, How to handle exception while  using Import Excel to Database in Process Model . In other ways, I want to show an Error Message in the interface if Import Excel to Database throws an error.

I'm doing an interface with Milestone component for 7 steps ,the flow continues  until 4th step when i click on "next"  BUTTON .But from fifth step it was not cotinues its flow. (Please NOTE: INTERFACE doesn't throwing any error)

I am having an issue with a read only grid that is selectable. Upon page load users can select checkboxes, but those selections disappear. However, if the user selects the checkboxes a second time, the selections save and persist. It is only the first attempt at saving the selections that fails.  Note: The first selection takes a long time to load and then disappears. The selections after that load normally. This issue does not exist in the interface designer (only on the live site) selectable: true, selectionValue: local!selection, selectionSaveInto:{ local!selection, a!save(local!selected, append(local!selected, fv!selectedRows)), a!save(local!selected, difference(local!selected, fv!deselectedRows)) }, selectionRequired: true, Code above is where we save each selection in the read only grid. a!startProcessLink( processModel: cons!PS_OPEN_NEW_TICKET_PM, processParameters: { periIDs: local!selection } ) Co

Hello all,  I have a process that is trigerred by a timer event.  I want this process to be trigerred on a quartelry basis, with the first trigger date on March. How can I specify the month that I want the process to start ? Thanks in advance

Hi, can we write single expression rule to get data from multiple table, if it's possible how it can be simple example like: select orders.orderid, customers.custername from order inner join customers on orders.customerid=customer.customerid can we write such query in expression rule  Thanks, Kavya 

difference between terminate and end event, also  if i add asynchronous process model to the terminate process event then how process model and instances behave?

I am doing the Acme Auto Exercise for the Appian Developer coursework and am having some issues saving configuring the XOR gateways to save the condition pathways. The instructions as listed under "Appian Step-by-Step #9": Configure the Cancel XOR Gateway In this process, if a Mechanic cancels the start form, the process will end. If a Mechanic submits the form, the process will continue to the next process node. Follow the steps below to configure the Cancel? gateway. Drag and drop an XOR Gateway into the Maintenance swimlane to the right of the Start Node. Rename it to Cancel? Drag and drop an End Event into the Maintenance swimlane above Cancel?. Rename it to End - Cancel. Connect the Cancel? and End - Cancel nodes. To connect, hold down SHIFT on your keyboard, and then click from one node to another. SHIFT will automatically toggle your pointer to the connector tool. You can also use the Connect icon to connect the nodes. Drag and drop an XOR Gateway into th

Why Appian throws Internal Server Error on REST API when an interface or expression evaluation fails?

I have created an application that uses a public API as an Integration to retrieve the required data from a 3rd party website and store it in the Appian database. So my application is a "Dictionary Book" and I have created a CDT for the same using these fields:   id word phonetic origin definition example searchedBy searchedAt Next, I created an interface wherein I have passed this CDT, readOnly and cancel as a rule input. The user needs to fill and submit the "word" field, and the "searchedBy" and "searchedAt" fields are set using loggedInUser and now function. The rest of the fields would get their respective data via Integrations. I created the entire process in the Process Model and I was able to get and save the data for all the CDT fields without any errors. But when I added this interface as a page to my site, and tried to execute this interface, it gave me an error saying: Expression evaluation error [evaluation ID = 831a9:

Hi to everyone! Can everyone help me with this error message? I guess that PDF can't be created because of some special character?ERROR:An invalid XML character (Unicode: 0x1a) was found in the element content of the document Thanks!

a!queryEntity( entity: cons!PF_ENTITY_VW_REQUEST, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn(field: "RequestUserID", isGrouping: true), a!queryAggregationColumn( field: "RecordID", isGrouping: false, aggregationFunction: "COUNT" ) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: "RecordID", operator: "not null"), if( isnull(ri!RequestUserId), {}, a!queryFilter( field: "RequestUserID", operator: "=", value: ri!RequestUserId ) ), if( isnull(ri!activeStatus), {}, a!queryFilter( field: "ActiveStatus", operator: "=", value: ri!activeStatus ) ), if( isnull(ri!RecordID), {},

Hello, We have a requirement to embed Appian user interfaces/ approval tasks in a WeCom mobile App. I referred to Appian's documentation on embedded interfaces on https://docs.appian.com/suite/help/21.4/Embedded_Interfaces.html It details how to embed Appian interfaces in web pages outside of Appian but could not find any details on embedding Appian content in external mobile App. So is it possible to embed Appian interfaces in a mobile App like WeCom (similar to whatsapp)? Any pointers would be helpful Thanks!

How to make the milestone field step count as dynamic eg - if I have 10 questions the local!steps  will come dynamically as 10

I wan to know how to get the list of all process calendar names from the process model? Thanks

I was watching the course Advanced Appian Developer > Design for Scale Using Patterns and Anti-Patterns > Process Management Patterns. https://academy.appian.com/#/online-courses/9eec0cd2-199a-4c4e-85a8-cb7d044c0718 At about the 2:10 mark the instructor states "Text variables used by a process remain in cache until the next restart so archiving does not immediately remove all data. Do not save large amounts of data in text strings ..." This sounds an awful lot like a 'memory leak' to me. I thought that all memory for a process was released when the process is deleted or archived? Is this not the case? When is this memory recaptured? When the server is restarted? If so, how are clients who license Appian through the cloud impacted?

I have an interesting User Case where I need to link an Appian record with something outside of appian in a react application we are using. I don't understand the record generation since its not using any information from the database in that generation which it shouldnt because it could be a security issue, but I was wondering how I could get that link specifically and pass it to a button on my react app so when they click it, they will be taken to the specific record in appian for whichever record they clicked. Sorry if this doesnt make much sense.