Discussion Categories

Hi there. We have an issue we have been unable to resolve with Appian's default task notifications. We want the "View Task" button from the notification email to send the user to the task on one of our sites rather than through Tempo. We have been able to accomplish this in a couple of our environments by setting the default user start page to: "">our-environment-name.appiancloud.com/.../our-site-page" with a couple others sites set up for specific groups. We have tried the same thing for another one of our environments, but no matter what we've tried with specific groups and default sites, all the task notifications are sending users to the tasks in Tempo rather than the site. We've tried comparing settings across the environments to spot the differences to see why it is working in one place but not the other, but we haven't been successful yet. Is there some other setting that we've missed?

so lets say clothesType is declared as string in db. in a rule, i am iterating over this variable using for each loop. the problem is i can't declare the clothesType as an array as it would affect existing functionality. If i could, it would solve the problem. So, are there any built in appian functions that i can use to run a for each loop over a value that is accepting one value only?

I would like to include Navigation bar as it is described in Navigation Patterns. To make it flexible and to be able to assign particular navigation entry to different users I would like to store in table A all NAV Section (id, name, icon and rule name) and in Table B - userToNavigation mapping. In table B i will store userid, tableAId.  I don't want to list all Navigation sections and then all rules/section as it is in example. I would like based on userToNavigation mapping display proper interface. In other words i need Appian to understand rule saved in table as text to be recognized as proper interface (rule!interface) https://docs.appian.com/suite/help/21.4/navigation-patterns.html

Hi, The requirement is to compare document with its previous version of the same document ID in appian. Is that a possibility and if so any plugin or function that to be used?

I'm trying to manually create a related action for a record type (the auto generator didn't work). I need to create an expression rule that returns an individual record based on the record ID (according to the documentation), but there doesn't seem to be any documentation on how to actually do this. I've posted what I have currently that is not working, could someone let me know what I'm doing wrong? Thanks in advance! Expression rule: a!queryRecordType( recordType: 'recordType!{5e8d63c0-430d-4636-9dfe-e5e4c67aefc5}SH survey data', fields: {}, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ) ).data[ri!identifier] Context field in Related Acton configuration: { record: rule!SH_getSurveyRecordById(rv!identifier) /* SH survey data */ }

Can anyone tell me the procedure to follow, so that I can have on-prem solution on my device. P.S, I tried following mentioned on the Appian website but it is of no use as when I try to go on the Appian Forum, it redirects me and shows error 404. So can anyone guide me?

Hi All I am working on the Appian portal and trying to upload more than 1 file at a single time, I used maxSelections in file upload field but its not working I am using record Type and local variable because we can't use rule inputs in the portal. Below is my interface code and CDT .

Hi everyone, I need to track my company distribution list (contact group) on outlook email. It should work this way: Sombody sends an email to my distribution list. Receiving the email to my inbox is an action that triggers appian process with parameters extracted from that email. The distribution list that I need to monitor has company domain and it is not on appian cloud. I checked the Receive Message Event documentation but I am still not sure how to approach this task. Thank you in advance,Marcin

How To Remove Unwanted fields in pie chart.

Hi all, I am trying to build a selectable editable grid, but everytime I select a row it keeps selecting the entire grid. I saw previous comments that each row needed to have an identifier, and my data does have one, but its identifier status must be getting lost somewhere if a selection on my grid keeps selecting everything. Here is my test code: a!localVariables( local!data: rule!query_case_summary(show5YrAvg: false), local!header: {"age", "gender", "smoker", "amount", "fiveyravg1", "fiveyravg2", "fiveyravg3", "fiveyravg4", "sum5yrChange", "annual5YrChange", "currYrChange", "priorVal", "currVal", "recVal", "reviewStatus", "lastReviewedBy", "userRecVal", "comment"}, local!selectable, { a!gridLayout( headerCells:{ a!forEach(local!header, a!gridLayoutHeaderCell(label:fv!item)) }, rows: a!forEach( items: local!data.data, expression: { a!gridRowLayout( contents:{ /*

Looking to find out how many times a interface is clicked into or initial loads to get rid of interfaces that are not clicked into. The Sail_Detail.csv should do this but for some reason the internal code is empty. Does anyone know a plug-in that can find this information or a different log?

Hi Experts, Is there any restriction in Appian on a service account with read-only access on Oracle database, to not be able to create the CDTs using those table. In my current application I have been provided with credentials for the account which has only view access for the tables. I have configured the connected system with provided credentials. But when I'm trying to create CDT's I can only find the Schema Name but not the underlying Tables. Please suggest.

Hi Experts, Kindly help me to impletment the Audit Log Functionality, Requrirement is as if any fields get updated to a new value, I have to show the Field name shich got updated along with its Previous Value and New VALUE along with Who has done the update and WHEN i.e if Original value is a!map( id:1, fName:"ABC", lName:"XYZ", DOB:11-05-1995, phone:"1234567890", ) and updated value is a!map( id:1, fName:"CDF", lName:"XXX", DOB:11-05-1995, phone:"1234567890", ) Serial number Field previous value New Value Updated By Updated On 1 fNamelName ABCXYZ CDFXXX (Username) (12-10-2022) 2 Thanks

hi, my query is if i want to read xsl document  details in expression rule is any function for this

Hi, We have a database table where data gets dumped in a regular interval by a ETL job. We are using database Backed record with synced functionalities. Now, we need to sync/import newly inserted data to record in a regular interval, but FULL SYNC cannot be done automatically (more than once a day). Is there any way to get those new data in Record?

Hello i'm just trying to get the name of the past month, im using this code:  proper(text(today(), "MMMM")) But it only generates the name of the current month Thanks!

Hi, I'm using an Integration component to call a REST API that allows to return a PDF file (the input is a document ID). In the Integration Response Body Parsing selection, I've chosen the "Convert binary to Appian object" option to store automatically the document in Appian. All works fine, the document PDF is retrieved then stored in Appian KC. The issue I meet is to deal with the error case:When the API is called with an incorrect Document ID, the Integration error output result is stored in Appian as a Json file. But I don't want this Json file to be store in the Appian KC. If I want to choose the "Return raw response body" to manually deal with the raw body response, could you tell me how may I manually convert and upload the binary content to a PDF file in Appian please ? Regards

An error occurred while evaluating expression: expiredContracts:rule!TCT_ContractDashboard_Status_Expired( waitingOnCustomerAndApprovar: pv!waitingOnApprovaAndWaitingOnCustomer) (Expression evaluation error in rule 'tct_contractdashboard_status_expired' at function a!forEach [line 3]: Error in a!forEach() expression during iteration 10: Expression evaluation error in rule 'tct_docusign_getenvelopedefinition': com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.util.concurrent.TimeoutException: null)

Hi All, I have the requirement to close the process task after clicking over the button in interface? Can anyone please help me out?

Getting Below error while retrieving Data. Expression evaluation error at function a!queryEntity_18r3 [line 4]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [VIEWDT6164], query: [queryentity expression], order by: [[Sort[eventType asc]]], filters:[null])

Hi all,   Wanted to ask the community to see if anyone has some best practice recommendations to handle the edge cases caused by Appian limitations in how it detects null/empty values and how it converts null singleton types into array rule inputs; and especially recommendations on setting up re-usable query entity rules.   We've discovered that Appian handles nulls in unintuitive ways depending on the data-type. If a rule input is an array, and you pass in a singleton of the same type that is null, Appian will automatically convert that input to {null} (a one element array where that element is null), rather than null or {} (empty). According to Appian support, this is the expected behavior of the product.   However, this causes two issues for us:     The out-of-the-box isnull() and a!isNullOrEmpty() functions return false, despite a reasonable assumption that the value is null/empty. (It is not. It is a one element array with that element being null, due

I am on the Exercise where I have to change the image to a document image I was initially getting an error as it was like the documents was missing there but managed to add the images to my app. I have keyed the code under the expression editor. a!imageField( images: a!documentImage( document: fv!row['recordType!{c20ff609-5f40-4fea-8800-074abc464c7c}AX Vehicle.fields.{f1cb1cdc-1134-40e8-b30b-0b90d32da455}vehicleimage'], caption: fv!row['recordType!{c20ff609-5f40-4fea-8800-074abc464c7c}AX Vehicle.fields.{f1cb1cdc-1134-40e8-b30b-0b90d32da455}vehicleimage'] ), size: "SMALL") I now get this error below.

Hi, when I am creating the record type using an entity that contains transient value it's throwing an error. ERROR: "Preview currently unavailable due to an error on the source" I have checked the data source multiple times by doing save and publish and the data source not showing any error, it is successfully publishing. can anyone please help me with this error ...

Where can I find the Appian Foundations Learning Path or Course? When I go to Appian Academy, I see courses for Seller, Planner, Administrator, Builder, but none of them contain a course or Learning Path entitled Appian Foundations, which is mentioned on Appian Customer Case Studies page Lesson 6 of 6?  Thank you!

Hello, Please could someone help me on what I need to write in the Related Action configuration of the Delete button for it to work and delete the record from site as well as DB.