General

I've a requirement to make available a number of PDF documents within our UI, that the users can download as and when they wish.Initially I sorted this by saving those docs in Appian KC, along with an associated DB table that stores amongst other things the docID. At run time I simply make a call to the db table, get the doc id's and then generate the list using a!documentlnk. a!richTextDisplayField( value:{ a!richTextIcon(icon:"newspaper-o", color:if(fv!item.priority="1","NEGATIVE",{}) ), a!richTextItem( text:" "&todate(fv!item.updatedon)&" "&fv!item.message, link:if(toboolean(fv!item.islink)=true(), {a!documentDownloadLink( label:"download",document:fv!item.doc) }Works great.However I want to expand this to capture which of the docs are being downloaded and are true FAQ's vs ones that simple dont need to be taking space. Ideally I thought to use an a!saveinto and write the pertinent into to another d

I have an app for site surveying equipment that produces a task which is going to be completed primarily on mobile, often offline. Since the task could take multiple days to complete I added the 'Save Draft' button to the interface from the process model. On desktop it works as expected, I can hit the save draft button, exit the task, then go back in and pick up where I left off with all the previous data still there. However, on the mobile Appian app, when I hit this button the data is saved properly, but the task then closes. Since I experience the occasional app crash with the Appian mobile app, I would like to be able to save my work periodically without having to exit the task each time. Is there a way to prevent the 'Save Draft' button from closing the task in the mobile app? Thanks in advance!

how to give action to the Icon, such that onclick it should add the card layout above the icons column layout?

dependent and precedent errors in exporting application

Hi Team, I am getting special character i.e ";" in empty field, how to remove the special character and save the value? Already tried stripwith() and it is not working as expected.

Hi Team, I have an excel template in which i need to map values to the particular cell positions like {B2,B3,B4,E2,E3}; that are being retreived from a table. I am getting all the data in single row currently even after giving the cell keys. Any suggestion? Thanks Anandita

Is there a way to query up who is assigned to a particular task? I've got a process report, but I'd like to somehow pull the assignee for a particular task out of that for use elsewhere. What is the best way to do that? 

Good afternoon, We used the node Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV2) Later we updated to version 2.2.1(Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV3) and since then, passing the same values ​​in the input inputs, the shipment no longer occurs and gives us the following error: Does anyone know if anything has changed? A greeting and thanks in advance

Hello, I am trying to achieve below 2 things and need your help please. My form consists of 5 fields (ClientName, SubmittedBy, SubmittedDate, isSaved, isSubmit) which will be save into to DB table. 1. Form is having 2 buttons save and submit. On click of Save, it should save all the 5 fields with isSubmit=false in the database and the form should not be closed. On click of Submit, the isSubmit=true and the form is closed. 2. How to create a reusable function which is called from both Save and Submit button. That function should have the a!save code which will save the fields accordingly. The below 3 lines are called in both the buttons and based on from which button is called, it should save fields.                              fn (isSubmitClick) {                                              

in my database i have time in 24 hours format for example "8:00". when i create a query for this datetime what i receive is   a result with four hours difference how can i achieve to get it in the same time zone  as the database

My scenario is to check the date past 45 days.  todate(now())-local!creat_dt return intervals(days to Seconds). How to retrieve Days from it. Or is there an other solution to find?

Hello, I am getting the below error when querying a particular table from the application. The entity I am querying is a nested CDT.  Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0] Server Log file Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0]) (APNX-1-4164-025) at com.appiancorp.type.external.teneoimpl.QueryRuleExceptionHandler.handle(QueryRuleExceptionHandler.java:50) at com.appiancorp.type.external.teneoimpl.TimedWorkRunner.run(TimedWorkRunner.java:62) at com.appiancorp.type.external.teneoimpl.TeneoQueryExecutor.execute(Te

Hello Everyone, I am getting the following error when querying one of the table from application. The entity I am querying is a nested CDT.  Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0] It is an existing CDT which used to work just fine. The only recent change I have made is increased the column length for some of the fields in the table and removed the length parameter from the xsd annotation. Could it be the issue? I am able to get data by sql select statement. Please help if anyone knows or have experience on how to fix this issue. Thank you.

When searching for objects in appian, is there a way to exclude something? Like if I was going to Google something, for example, I could search for "fruit" but not "apples" by typing "fruit -apples" is there some equivalent in Appian? Most of the objects in my application have a specific prefix and I'd like to search for the ones that don't have that prefix so I can eliminate them. 

Hello There, How to upgrade to Appian 22.1? I am using the free plan 

Hello Team, I am trying to create a new view with expression rule or sql script that will include the sum(PaymentAmt) for cases where directDepositTF is 1. For example in the attached image, caseId 138465, I would like a view that sums the amount in paymentAmt column into a new view. Thanks

The project I am working on has a specific use case where they export a excel sheet and then convert that into a PDF from there. The excel sheet doesn't necessarily hold data. It holds data in the sense that fields are highlighted. My question is for the example attached is it possible to recreate this using the document generation/management tools or any other tools within Appian? If so what would I be looking for and how would I accomplish this? Attached is an example about states vs what foods they like, don't like, or indifferent as example data. What could I do to recreate an appian export of this data and it changing if I have a field that says if fries are good and burgers are bad etc.   

So someone on my team has a process model with the following error: There was an error in an expression in Process Model Properties at Process Start Form : Variable(s) not found: local!planType local!addActivity I can guess that some expression/interface hidden in that start form is missing some local variables (the start form itself has no errors), but the problem is there are tons of expressions in that interface and many of those expressions have multiple levels of nested expressions in them. Short of clicking through these countless expressions until I find an error, is there some way to quickly find which one might be the offending expression?  Or if I'm reading the error message incorrectly some advice on where I should look would also be appreciated. 

Hey all,  I have a general question,  Why does Appian have a different appearance sometimes? Is this a matter of which URL they use? Sometimes looks like this:

Hello there! I have the following process: We send a email to a customer with a user with a link to a interface. The user has to complete an interface, then the user is redirected to an external page where a email with a temporary password is send. The user has to take this password and provide it in the page. Very simple. The problem comes with the mobile version. When users try to open the link in their mobiles, the page is opened in the same tab that the gmail app (i think that this happens because the integration between browser and gmail app), so when they want to see the password sent to their emails, they have to close the tab and, with that, all the process has to start from the beginning. My question is, can we open the link in another tab/interface after the user complete the interface? We tried with safelink but it doesn't work in mobile (it's opens the page in the same tab). If not, is it possible to do something to avoid the process or something to start in the sam

How to deprecate a existing constant?

Hi, I have two tables with name x and y, X has 20 columns with name of text1,text2,text3.. text20, and additional some columns as id and cif - which is used to store the values in this one row isequal to one line which includes all 20 cols y has 20 columns with name of text1,text2,text3.. text20, and additional some columns as id and cif - which is reference for x table  using both the table i have show the values of x table all 20 cols of one row in one line  how can  i achieve this?  as of now i used only X table to show the values and just concatenated all the cols  is this right way to do?  Thanks Kavya Muttur 

Hi, I'm trying to test a fruitless foreach, and I'm surprised to see that the result is not just null or empty.- can you tell me why this code returns 20 null lines please (please see the attached file) ? I was expecting an empty list- - In this case, how to assert that the result is fruitless ? a!localVariables( /* Get a list of 20 Vehicles */ local!vehicles: a!flatten(rule!CJT2_GetVehiclesWithFilters( id: null ).data), /* The id = 550 does not exist in the Vehicles so we'll not find it */ local!oneVehicle: a!forEach( items: local!vehicles, expression: if(tointeger(fv!item.id)=550, fv!item, {} ) ), local!oneVehicle ) The object of this post, is not to replace foreach by another function (like index or reject) but to understand how works the foreach. Regards

Hello. I'm getting this error in our UAT Environemnt while uploading PNG file. but in our DEV environment the file upload is working properly

Hi, Im facing this issue when i'm retrieving  a list of data from an integration and  casting it to a data subset  when i try to acces a  especific id in a expression rule everything works perfectly  and it returns an  id but  when i do the same thing on a process model  it throws me this error that you see i tried many ways of getting this to work  and nothing. what could it be the problem that  i'm facing ? below how looks like  the expression rule when i  use the   process model to get the  values this doesn't work either