General

Hi guys,  I think I am close to the solution, but I've been stuck with this for a while and figured asking cannot hurt. I am creating an interface which is supposed to show the user data from another User Input Task and have them confirm it has been input correctly. For this I use a read-only grid which I configured according to the Appian tutorial. However, it displays the data in only one row, albeit separated in the pre-defined columns (so e.g. it will say for Underlying "Underlying1; Underlying 2" in one cell). The data is pulled from a CDT as a rule input. It contains "flat" data like single booleans, but also arrays. For this exercise, only arrays are concerned. Do I have to manipulate the data beforehand or am I missing something major? My code: a!gridField(  label: "Fixing Levels",  labelPosition: "JUSTIFIED",  data: ri!product_cdt,  columns: {    a!gridColumn(      label: &q

Hi, Is there a way to use local variables in a rule that is used in reduce function When called from UI? When Using from UI it says that I need to configure  refreahalways for the local variable ..... Thaks in advance, Gil

Good morning, We need to have a webApi that receives a document and a json input with other data in the body. I have been reviewing the document upload template of the webApi and in the body it only lets you add the document.Does anyone know if what I need to do is possible? Greetings and thank you

Hi I am working on Appian version 21.3. I have created an extraction process referring to the below link: https://docs.appian.com/suite/help/21.3/create-doc-extraction-process.html The process looks like this in my case: The CDT is: My concern is, out of all the values only 2 values are extracted and 1 value is semi extracted. The PDF file I have created manually. Want to understand why all values are not extracted despite not much values are there in the PDF. PFB the Appian Reconcile form that pops up as a task for me: Thanks in advance!!

i am trying loop through the each row in the excel but foreach is not working .

Hi Team, We need to show four tabs in our site's homepage and all the tabs are different interfaces which are interlinked. The first tab/page is a action whose context is a process model with a startform. How should i configure it in the 1st tab page. Below is my code for tabs UI: So here I am trying to call the process model for first page with a!startProcessLink but i is not working. Can anyone please suggest what should be done here? Thanks.

hello, I'm currently on Appian version 21.3 and i want to upgrade to 21.4 can you please help me, I don't have any experience in upgrading appian version 

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.