Discussion Categories

I want to add multiple columns from different tables to a existing views in Appian Cloud database. Can I use CREATE OR REPLACE VIEW for adding multiple columns from different tables to an existing view? can anyone provide sample script.

Hi all, How to compare two lists in appain {1,2,3} and {4,7,6} IF the Comparision true then it will write true otherwise false. Please help me

I have a Site say "ABC". In that site, i have configured a record which has multiple tabs: summary, cases, audit etc.  My Requirement is, whenever i click on a tab, the name at the browser tab should show that. For eg, If i click on Summary, the browser tab should show summary. I have attached a screenshot for reference. I checked, it could be achieved by configuring dynamic display name in the Sites, but I don't know how to achieve that. Is there any code snippet or example for display name using expresssions in SITE. Thanks in advance

Windows server allowing 5 concurrent user session logins. Can we have different Appian RPA processes running in different sessions at the same time? Which means installing the agent for each user specific session and connecting it with console and resource. 

I am looking for ways besides cards to initiate startProcessLink from a UI. Initially I was trying to replicate the look of Card Record Actions, but when I use a card layout I run into issues on mobile or smaller screens where the card becomes hard to read, or a scroll bar appears. Card choice field does not support links. Or is there a way to remove the scrollbar from cards?

Hi! I'm trying to save values from a multiple dropdown into a rule input, but my code it's not working. I proved a!forEach in my submit button, but when i press the button only save the last item of my array.   a!localVariables( local!categoria: cast( 'type!{urn:com:appian:types:FDC}FDC_CATEGORIA?list', rule!FDC_ER_getAllCategoria()), local!organismo:rule!FDC_ER_getOrganismoByCategoriaId(id: ri!categoria), local!guardarOrganismo:local!organismo, /*local!prueba:ri!cartaOrganismo.idOrganismo,*/ a!sectionLayout( label: "Section", contents: { a!sideBySideLayout( items: { a!sideBySideItem( item: a!dropdownField( label: "CategorÃ%ADa", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!categoria.coNombre, choiceValues: local!categoria.idCategoria, value:ri!categoria, saveInt

Hi, my trouble here is that I don't know how can I save true or false in differents boolean columns in my database. I tried something like that: a!checkboxField( label: "", labelPosition: "ABOVE", choiceLabels: { "Limpieza","Plaga","Manipulador" }, choiceValues: { "Limpieza","Plaga","Manipulador" }, value: {if(isnull(fv!item.inLimpieza),{},"Limpieza"),if(isnull(fv!item.inPlaga),{},"Plaga"),if(isnull(fv!item.inManipulacion),{},"Manipulador")}, saveInto:{ a!save( fv!item.inLimpieza, if(contains( save!value, "Limpieza" ), true,false) ), a!save( fv!item.inPlaga, if(contains( save!value, "Plaga" ), true, false) ), a!save( fv!item.inManipulacion, if(contains( save!value, "Manipulador" ),

Is there any way to delete all the previous version of selected artifacts at once rather than deleting them one by one ?

This might sound a bit silly but I wanted to know how to track during which phase of the application flow, an API is being triggered? I have an API that kick starts a process model that queries data from database and that is about it. In the backend I see this process model is getting triggered every now and then started by a service account. Now, how do I know when this API is even being called? How do I back track it? checking its dependents doesn't show anything except for the process model.  Any response is appreciated. Thanks.  

Hi all,i tried to perform upgrade my local server from 23.1 to 23.2 inorder to upgrade the env i followed all the steps mentioned in https://docs.appian.com/suite/help/23.2/Upgrade_Guide.html while starting the tomcat appserver i noticed the fatal error pointing to local port by default appian install pointing to 9300 but search server poinitng to 9200, please find the logJun 20, 2023 5:06:38 PM org.apache.catalina.core.ApplicationContext log INFO: No Spring WebApplicationInitializer types detected on classpath log4j:ERROR Unable to deduce date from C:\appian_23.2\appian\logs\perflogs\http-requests-and-responses\integration_req_resp_activity.2023_06_16.1686880664795.log rotated log file. log4j:ERROR Unable to deduce date from C:\appian_23.2\appian\logs\perflogs\http-requests-and-responses\integration_req_resp_activity.2023_06_15.1686825944448.log rotated log file. 2023-06-20 17:06:41,485 [wait-for-component] INFO com.appiancorp.tools.WaitForServers - Waiting for servers to be up.

Hi Community, I am using webservicequery() function in one of my expression.It is working perfectly fine in our development environment. However when we have moved that Application to the UAT environment.We are getting below error:Expression evaluation error at function 'webservicequery': The WSDL cannot be processed because the remote server's certificate is invalid. Check that the certificate has not expired.   Can someone help me on this ? Is there any settings which I have missed ?I have verified the Expressions in both the Environment. They are exactly same even the User Name and Password.Regards,ABDUS SAMAD

a!localVariables( local!fieldName:"5", local!operator:">", local!value:"2", a!textField( value: fv!item.fieldName, saveInto: fv!item.fieldName, validations: { a!validationMessage( message:"test", showWhen: local!fieldName & local!operator & local!value ) } ) )This is an example of what I want to achieve, the operators can be different, the fieldValues & fieldName can be of the other fields. I want the showWhen condition to work even if I give it a string.

If we have an icon on our interface, ("clickable icon") ---->  configured with a start process i.e. when we click on it, a report opens and shows on a new tab, is there a way to show that report in a pop up and not in a new tab? Icon image attached fyr:

In my application there is vendor who comment when submitting a form and when it comes towards reviewer the reviewer comment again.So I want to show it as history what vendor commented and what reviewer commented.

Hi, Our Company wants code signing enabled for all code and we use on-prem Appian. Is there any way this is possible in Appian.

There is a problem with task "Move To Collab" in the process "FILE_SHARED_DRIVE_CONNECTION" Problem:  An error occurred in executing an Activity Class. Details:  com.appiancorp.suiteapi.process.exceptions.SmartServiceException: java.lang.Exception: User xxxx is not a System Administrator. You must run the Move to Collab smart node as an administrator. Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority This message has been sent by Appian   Still even after the node in the process model was configured as "Run as who ever designed the process" says - com.appiancorp.suiteapi.process.exceptions.SmartServiceException: java.lang.Exception: User xxxx is not a System Administrator. You must run the Move to Collab smart node as an administrator.

Hi Champs, Is there any way to edit CSV file inline in Appian screen and storing them back to Appian as document. Regards, Ghanashyam

What Is a function for showing array itoem in ascending or descending

Hi All, Please help me on this error a!localVariables( local!listOfAmendments: if({ index( index( rule!ISR_er_PopulateAmendmentsInExecuteMeetingDataSubset(meetingId: ri!meetingId), "data", {} ), "amdId", {} ) = index(rule!ISR_qry_GetISRAmendmentPrimaryReviewers( meetingId: ri!meetingId, primaryReviewer: ri!primaryReviewer, isActive: true ),"amdId",{}) },rule!ISR_er_PopulateAmendmentsInExecuteMeetingDataSubset(meetingId: ri!meetingId ),{}), /*(Amendment Number, Amendment Reason, Proposal Reference Number, */ /*Study Title, Primary Investigator, Medical Scientist/Proposal Champion (from GIL-134), */ /*Currency, Budget, Slides (Slide for the Amendment) (GIL-263))*/ local!tableAmendmentGridStart: " Amendments to be Reviewed: TA Ref # PI Country Study Category ", local!tableAmendmentGridEnd: " ", local!amendmentsGrid: a!forEach( items: local!listOfAmendments,

Hi, Can anyone confirm if it is possible for Appian to connect with Nasuni. Regards, Chetana

Hi All, Is there any way we can download entire .msg file (including attachments and email body as is) in Appian directly ? Thanks, ND

Hi all,    While Data Sync Enable, Doing related action For Update query in the table by using the Write to data store smart service. I am getting data sync error as below screenshot. I have generated the related action by using "generate a Record action". but in documentation said that Immediate sync is possible by using write to data store smart service.But it is failing and returning error as below Thank you.

hi everyone we just have a trouble in data sync. we have created some record types from the database, but one of them failed in data sync. the status is "failed" in sync history. the detail shows "Alert: Unable to sync due to a system failure. Issue identifier: [e0bcc3cb-4961-443e-be9d-ced7237ae97c]". is there some proboble reasons for this trouble? Thank you all.

Hi all, I had a scenario Where i used MNI to start sub process (The sub process creates instance for each item in a parent PV , All at once and moves on each time an instance finished). And Inside sub process i'm just writing to Record , with a wait time which was defined in that parent pv. and i'm mapping output from sub process back on to parent. And on next node i'm appending it to a list. My issue right now was if two sub processes completed at same time one of the two is getting ignored second one getting  appended twice to the list. (i Can't use looping ******, cause i want to process all the data once .)

I would like to publish videos and documents using the video component and document viewer component. But when I use them, the component shows a download button. I don't want my published content to be downloaded. Can setting permissions by group solve this problem?