General

Hi, I am trying to populate a filter using FitNesse for Appian. The filter seems to be inside a frame, I am able to verify that the user filter is present but when I add script to populate record type user filter, it returns error that it could not find the filter.

We recently noticed a issue in production that the excel is populated with random duplicates for any record intermittently. User is filtering out the data on SAIL and clicks on EXPORT button. We can see the filtered data in the excel but few records are duplicated in excel which does not exist in view or SAIL. We ran the query entity explicitly to determine the data and it is correctly retrieved as per the filters applied. So there is no pattern as such to figure out why this issue is occurring. And this is only observed in Production and not in lower environments. As we are not manipulating the data anywhere, I am guessing the issue must be with the view, especially with primary key. We are currently guessing that the issue might be with the way smart service is sorting out the data based on filters applied in excel report. We are using Export DSE to Excel smart service. We are using a view with SELECT ROWNUM ID and mapping this ID as Primary Key with @ID annotation on CDT. But we are

Any one tried this card layout method to handle layout forms. I am facing issues in clicking on the below 'yes' and 'No' options as card links on the below layout form. I tried with all the relevant existing Fitnesse methods below to click on 'Yes' and 'No' options on the form attached:    click on card CARD_LINK_NAME or CARD_LINK_NAME[INDEX] click on card CARD_NAME or CARD_NAME[INDEX] in card choice field FIELD_NAME or FIELD_NAME[INDEX]   Nothing seems to work. Any thoughts or views on this?  Many Thanks

Hi Guys, i've tried implementing the post deployment process model feature and was able to get the details of deployment from 'deployment uuid' which is passed by appian to process model by default. But the post deployment process runs only for direct deployments and we need to run our custom code test on manual deployments too. So, is there a way by which we can get the deployment uuids of all the deployments happened during a day, filtered by date so that using those i can create a scheduler which performs quality check on all the deployments once a day. or is there any api using which we can retrieve the deployment details in an environment. Thanks in advance.

Team, I have below code : a!localVariables( local!data1:{"test1<br>","test2<br>"}, local!data1) Output is list of text strings "test1<br>"(Text) "test2<br>"(Text) I want the output to be in format "tetst1<br>test2<br>" Basically i am formatting a data before sending into email template but it is appearing like below , i want the semicolon to be removed. Test1 ; Test2 It should be like below Test1 Test2 ANy suggestions ?

Hi, We are using microservices architecture in our enterprise and all data related tasks are performed using rest APIs. We want to use Appian as UI layer for our application. So my first question is it Appian recommended for such scenarios, when all data related operations (Get data, add, update data) will be performed using API integration? If yes, Will Appian features like Data Sync, Records relationships useful/supported while using Open API connected systems for records?

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)              

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

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, 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 

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

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), {},

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

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. 

Hi all , can anyone help me with the below requirement please. I have a address cdt . In the interface below ( attached screenshot ) i have two section temporary and permanent address. So there is a  check box also in the interface . My requirement is : if the check box is not selected both the temporary address and permanent address should be saved  and if its selected both the address should be saved. But it should be saved in the same CDT So can anyone help me on how to solve this. a!localVariables( local!temporaryAddress:'type!{urn:com:appian:types:KYC}KYC_addressDetails'(), local!permanentAddress:'type!{urn:com:appian:types:KYC}KYC_addressDetails'(), a!formLayout( label: "Customer Address Details", contents: { a!sectionLayout( label: "Temporary Address", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Address Line1",

Hi, I have a address cdt . In the interface below i have two section temporary and permanant address. So when i check box ( i,e : is temporary address same as permanent address) the address should be saved . my requirement is : if the check box is not selected both the temporary address and permanent address should be save and if its selected both the address saved. But it should be saved in the same cdt So can anyone help me on how to solve this a!localVariables( local!temporaryAddress:'type!{urn:com:appian:types:KYC}KYC_addressDetails'(), local!permanentAddress:'type!{urn:com:appian:types:KYC}KYC_addressDetails'(), a!formLayout( label: "Customer Address Details", contents: { a!sectionLayout( label: "Temporary Address", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Address Line1", labelPosition: if( ri

Hi Appian Experts   I want to Upgrade old Process Instance to new New Version of PM . Can you tell what is prerequisites and how we can achieve that ,

Hi Team, I have configure process model in which I am using sub-process, inside sub-process I am using below expression  = { action: pv!buttonValue, actionBy: pp!initiator, currentStatusId: pv!selectedAssignments[tp!instanceindex].refStatusId, modificationType: pv!selectedAssignments[tp!instanceindex].modificationType, currentActivity: pv!currentActivity[tp!instanceindex], assignTo: pv!assignTo} When I run the flow I am getting below errror An error occurred while evaluating expression: = {  action: pv!buttonValue,  actionBy: pp!initiator,  currentStatusId: pv!selectedAssignments[tp!instanceindex].refStatusId,  modificationType: pv!selectedAssignments[tp!instanceindex].modificationType,  currentActivity: pv!currentActivity[tp!instanceindex],  assignTo: pv!assignTo} (Expression evaluation error : Invalid index (1) for list: valid range is empty) (Data Inputs) Please help me on this. Thanks,

I have a new Appian 21.3 installed running on Tomcat 8.5.70 as the application server. I'm getting the following CSRF token not valid error followed by 404 /suite/masterapp/undefined.cache.js is not available. I have tried adding <Context useHttpOnly="false"> in the Tomcat context.xml but still getting the error. This issue is preventing me from opening the editor for editing the form fields. Have I missed some configuration on Tomcat? Thanks. 2022-01-21 03:13:52,683 [http-nio-8080-exec-6] WARN  com.appiancorp.security.csrf.CsrfTokenManager - There is no valid CSRF token in this request [URI=/suite/framework/backgroundAction.none,method=POST,content-type=application/x-www-form-urlencoded]2022-01-21 03:13:53,602 [http-nio-8080-exec-4] ERROR com.appiancorp.ap2.PortalResponse - Error: 404 Message: The requested resource [/suite/masterapp/undefined.cache.js] is not available

Hi, i have a requirement where i need to get data of same cdt type from 2 different places and combine them together to display  in a interface. cdt 1: type!A{key:"100", field1:"test1"} cdt 2: type!A{key:"100", field2:"test2"} after merging output should be like this type!A {key:"100", field1:"test1",field2:"test2"}.Any suggestions will be really helpful. Thanks in Advance. Pradeep.B

Hi, Could someone please help me with the difference between StartProcess and Startprocess Link? And also exemplify with some use cases please. Thanks Faisal