Foundation

This is an issue that was initially reported on a Site and I could not replicate it when testing in any browser, until I thought to test on a separate monitor (not my laptop screen). When testing on the monitor was able to replicate in Chrome & Edge through the Site, through the top-level parent interface, and through the interface that contained the dropdown (although for the customers instead of a refresh, it was causing the entire page to turn grey). Can only replicate the issue on my laptop screen through the interface, not through the Site. I have reached a resolution for the issue (updating/deleting rows in the database or logic on local!choices to replace nulls with "Unknown") but sharing since I was not able to find anything when I had searched online. Believe the issue was caused by a user deleting some of the data for a couple rows before using the "Delete" icon/button that had been set up. The case was the query pulling in the data did not have a

Hi Team, Looking for a function which can provide hours and minute difference between two date and time considering business calendar. calworkhours() only provide hours plus it rounds off it to nearest hour. Looking for below calculation : Start Time : 20/04/2023 10:00 AM End Time : 24/04/2023 11:30 AM Output -  hours : 17 , minutes 30 Calworkhours output - hours : 18

Hi Guys, Our client checking the node timings for each step in the process in that time we noticed the simple expression rule took around 1 to 1.5 seconds, however the same rule checked in direct expression rule it took only 1ms. Can any one facing this type of issue? Any solution for this. Please find the below examples, Example: Obj: Sharing simple example below which i done for testing perspective. Expression rule logic: elapsedtime(now(),now()+52) => took 1ms Call the rule in process model(without activity chaining) => took around 500 ms. Thanks, Pradeep Sridharan

Hi All, Our customer wants a functionality in Appian where let's say they took screenshot or snipped an image from anywhere and they should be able to paste into Appian without saving it to folder in their computers. basically they do not want to use File upload field which source a documents saved in the computer instead just snip an image and paste into Appian. Is something like this is possible or exists in Appian? Thanks

Recently I tried to configure Appian on Kubernetes for desktop development but was informed that I needed to have a license for Self Managed accounts. This is confusing to me as I have been able to download versions of Appian since 2018 and install on local servers with no issues, licenses have been granted every time I make the request. In my opinion, these downloads and installations are self managed as Appian surely does not maintain the servers I have my installations hosted on. Can anyone help me understand the difference between the ability to download and install (what I call on premise) Appian environments and what are called Self Managed environments? It really makes zero sense to me and hoping someone can shed some light on this. Apologies if this is duplicated anywhere, didn't really see anything directly related.

a!forEach( items: local!milestonedata, expression: { a!gridRowLayout( id: fv!index, contents: { a!paragraphField( value: { fv!item.milestone }, saveInto: fv!item.milestone, characterLimit: 1000, required: true ), a!dateField( value: { fv!item.milestoneDate }, saveInto: { fv!item.milestonedate, a!save(fv!item.projectId, local!data.projectId), a!save(fv!item.phaseId, local!data.phaseId), a!save(fv!item.isActive, true), if( isnull(fv!item.projectMilestoneId), a!save(fv!item.createdOn, now()), a!save(fv!item.updatedOn, now()) ), if( isnull(fv!item.projectMilestoneId), a!save(fv!item.createdBy, loggedInUser()), a!save(fv!item.updatedBy, loggedInUser()) ) }, required: true ), a!dropdownField( label: "", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: rule!PLT_GetReferenceDataStatus(parentId: cons!PLT_ParentId[6]).Name, choiceValues: rule!PLT_GetReferenceDataStatus(parentId: cons!PLT_ParentId[6]).referenceId, value: fv!item.statusId, saveInto: fv!item.statusId, se

As you know, there should be an email address link at the bottom of the screenshot for sending email by click on it. But I cannot see it now in both 22.1 and 22.2, does someone have any idea about it?

Zuuuuuuup people ! So, I'm trying to create a screen to upload files,, between 2 interfaces. Since I need to send files to process model, I need to set rule input. But, When I try it, the following message is poped up: Is it possible to send those files without using rule input ? I've tried to set rule input at button submit click, without success.

I'm using "Copy document" and "Export  Data Store entity to Excel" smart services in a process model to generate a excel sheet. While the sheet is generated when the contents are displayed, the cells don't fit to the width of the contents within them. In excel we can generally expand according to the width of the contents by selecting all rows and columns and double clicking in the middle of any two columns. But that is after generating the file. So, I want this columns to be auto adjusted or expanded while generating itself. how do I make this happen? Now, How I need it to be, Thanks, Shravan

I have few active receive message(cancel_process) event with a condition to match a request id and then proceed. A different process executes and send message(cancel_request) with request id to all receivers, this call does not have destination process ids. After this, all active receive message node moved further even though the condition was false. The receive message executes even when the condition evaluated to false, has anyone faced this issue? Thanks in advance!

Hi team, I am Looking for an API that provides Services to fetch Cibil score by sending PAN Number. Can anyone Help me in finding the API for this Thank you J Vinay

Hello All,  As per the link https://docs.appian.com/suite/help/21.2/Custom_Mobile_Applications.html, it seems that Appian Provide Custom Mobile development. Where can we get more information regarding how to develop a custom mobile applications. Does Appian provide some IDE and SDK for custom mobile application development.  I am aware of the fact that applications created on the web using the Appian Designer platform can be view on Appian App available on Play Store, but what about if some want to create the only app for Mobile applications.  Additionally, can we create our own apk and IPA for Android and iPhone, later can we publish this to app stores. 

Hi all, I want to learn how to upload document on a REST webAPI. What I want first is to fetch the document from POSTMAN to Appian ( for Test purposes only ). However, I'm getting 500 internal server just by including a document from my body. Without including a document, it works fine.  my Body is a "Form-data", My issue probably is on my Web API Object of Appian ( request ), can you advice on this one on fetching request data from POSTMAN? Thanks rule!REST_Route( request: http!request, handlers: { rule!REST_Route( path: "/test", handlers: rule!TEST_PostTestAPIHandler(request: _) ) })

Hi, I need to copy an existing application with cdt and data source in the same server environment with a different application name. Kindly let me know the best practice for this and the easiest way of doing this. I also need to create a copy of the table structures used in the DB.  Thanks in advance, Swetha.

Hi Team, I have a parent process model calling another process model using "Sub-Process" service. Here we have input as well as output data configured. If the child sub-process has any error in it, then the parent process model is in Active status at the sub-process node. We do not get any alert emails neither with regards to the parent process nor with child process model. I have another parent process model calling another process model using "Sub-Process" service. Here we have only input data configured. If the child sub-process has any error in it, then the parent process model is in canceled by exception status at the sub-process node. We receive alerts stating that there is an error in task "child sub-process node name". I concluded that if output data is configured and the child sub-process fails then the parent process model stays in active status and in such cases we don't get system default alert emails or any kind of alert mails stating that

How to find the wrong email address when we are fetching data from the DB? (I am fetching employe's Data from DB, after fetching the data I need to send the mail notification to those Employ's, but "I don't want to send the email notification whose gave me the wrong email format or wrong email in process model Also I need to find the invalid email id")  Can Anyone help me for this,

I want to display cards as rows and columns of each 15 displaying as a grid together. After this i want to apply condition to display the numbers in order and display the cards that numbers are divisible by 7 , 8 and 9 only without rearranging. I display the rows and columns using cards. Can some on help me please?

I want to make UI where two grid will be shown grid 1 will have all data and grid 2 will be initially empty. In grid 1 we have checkbox where we can select different row and when we click add button then all selected items will be transferred to the second grid and selected item will be deleted from grid 1.  

When there is prolonged user inactivity, a popup comes from Appian stating that session is about to expire. We are not able to click on any of them. The screen freezes until we refresh the browser.  I am looking for guidance if anyone has encountered this in their projects. Any pointers are appreciated.

Hi, local!initProvidersSegment.ServiceLocation.Addresses is my CDT where Addresses is a list of array. In the grid selection i have selection value in local!selection i want to find local!selection in Addresses except one field in local!selection.Action field which is updated and CDT values remains untouched.. Suggest an expression.

Hello,I'm trying to create a POST method WebAPI that waits for its process model to end.I need to receive a JSON data type, process this data, and return an XML generated with the process model as the WebAPI response, is it possible to process the JSON information received and make the WebAPI wait for the process model to end ?I know that by the own definition of this method, the process model runs asynchronously, but I don't know any other way of approaching this case.Any idea will be welcome.Thanks in advance !

Hi Techies, We have a requirement where we want to show a particular site page when a particular user logs in. We have provided the site page url directly to the users but the problem is they want to see different site page for different users on log in. Is there any way we can change the default page that opens after logging in for different set of users? Thanks

Hello Everyone, I am trying to append data into a nested cdt in the order i enter data in the tabs, but unable to do so. Currently i am saving the data like this saveInto:{local!info,a!save(ri!userData.UserInfo.field1,append(ri!userData.UserInfo.field1,local!info)) I have a big multi section form and each section has multiple tabs. The section (form) i am working has 4 tabs and each tab has almost same fields. I have a rule input called users data which is of the type usersData cdt. usersData cdt has nested cdt's. My use case is - users should be able to enter data in multiple tabs in the form and after entering the data it should be appended into one of the nested cdt's of the rule input. The nested cdt is an array. I want the data from tabs to be saved in the order user enters them. Ex - Tab 1 - Fields A, B, C                                              &nb

I have this querydelete from PLSM_note where noteId in (fn!substitute(fn!joinarray(ac!selectedRecordIds, ";"),";",","))as shown in the below image. This query should translate to: delete from PLSM_note where noteId in (1,2,4,50)A) This is all on a single rowB) This is a single queryWhat's the solution to this?

Dear Team, Could someone help me to understand the below issue please. I am trying to fetch the total count of the records from DB view. When I give fetchTotalCount=true it's throwing an error 'Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query'. If I change the fetchTotalCount=false, it's working fine. Sample  code is below: a!queryEntity( entity: cons!DB_VIEWS_DSE, query: a!query( selection: a!querySelection( columns: a!queryColumn( field: "id" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1, sort: { a!sortInfo(field: "id", ascending: false()) } ) ), fetchtotalcount: true )