Discussion Categories

How to call a record view in an interface.

Hi All,I was trying to show tasks related to the order  in that order details interface, I was trying to write code but most of the time it comes half baked.I would like your help in this case. I understand I need to use looping, indexing and if condition to get this done , But I was not able to get the correct form of logic.  If any sample code is available for this scenario is very helpful for me to understand.Thanks in Advancefor example(The desired outcome), below for an order it is showing approval task related to that order:

I want to show progress bar in Read only Grid cell, How can i do that?

Hi Everyone, I am trying to run A360 bot through Appian 22.4 . I have created connected system and then integration. I am trying to run a operation deploy Bot. Can anybody help me on how to get File ID, Name OR how we can run A360 bot through Appian  Thanks in Advance 

Dear All,I am very new to Appian, kindly guide me how to get MyAppian page in Appian Community Cloud Platform. Guess, it's available on paid version only, in this case, I am trying to upgrade from community to paid version, but I am unable to do, please guide me, I have gone through the documentation. But couldn't solve my problems.Mainly I want to connect my existing Cloud Databases (Azure SQL Database & Aurora MySql database) to Appian Cloud platform. Your early response is highly appreciated. With best regards

Hi In my task report there are 3 active tasks, but when I tried to query that report in Interface it is only showing 2 active tasks.Can you please help me to know what is the issue?Code for the same:a!localVariables( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ), local!report: a!queryProcessAnalytics( report: cons!TS_Constant_Process_Approval, query: a!query(pagingInfo: local!pagingInfo) ), a!gridField( label: "My Tasks", instructions: local!report.description, data: local!report.data, columns: a!forEach( items: local!report.columnConfigs, expression: a!gridColumn( label: fv!item.label, sortField: fv!item.field, value: if( fv!item.configuredFormatting = "TASK_STATUS", index( { "Assigned", "Accepted", "Completed", "Not Started", "Cancelled", "Paused", "Unattende

Hello, I have a question, I have an interface which is a grid, this allows me to add a dropdown with information obtained from a constant, this constant has 3 groups, my question is, how can I do so that when I add a new grid, this information from my constant is independent of my dropdown that makes new, all this is written to another constant through a process. I have something like this, I already tried using save to to my new constant, but it is not updated with the process, does not elminate or anything. this is my code. thanks you! a!localVariables( /*rule to save groups */ local!groups: rule!GS1_getgroupnames(), /*rule to get all groups */ local!grupos: rule!GS1_getgroups(), a!formLayout( label: "Manage Additional Distribution List", instructions: "Please select and modify the groups that you wish to update in the grid below.", contents: { a!sectionLayout( label: "Additional Distribution List", contents: { a!gridLayout( label: "", labelPo

Hi, We've got a scenario where we want to provide hyperlinks for the user to access a site page which contains a record list. Is there a way to have filters prepopulated for a record list when the user clicks on the hyperlink, like maybe through passing values via the URL? Or any way to have filters prepopulated at all? I know users can save filters, is there something similar to preset them? I've been looking through the forums and documentation but I haven't found anything yet. Thanks for any help!

Lesson 4 Exercise: academy.appian.com/instructs me to "Log into your Appian Community Edition environment, and select the Acme Exercise application."I cannot locate "Acme Exercise" where I could work with an Expression Editor."Acme Solution Site" takes me to https://swmi.appian.community/suite/sites/acme-exercise-sitebut  I am not able to locate an Expression EditorWhere is "the Acme Exercise application"?

Hey, I am creating a service request management application. In that I'm creating a form for the user to fill and submit to raise the requests. Now while submitting the status of the request would be pending and it would be assigned to respective groups of people who would either accept / reject the request. Next while the status is pending, I'm allowing the user to change the details of the request which he / she had raised, so that mistakes in the request if any could be rectified by the user. Now I want to create a validation for it. The validation is, if the user clicks on edit and submits the form without changing any contents of the request, I should show an error message saying "Something needs to be changed in order to submit". Is there any solution to this, as in any way in which I could do this?      

Hi All, "Request Re-Opened Details are updated" should change to "Request reopened details are updated" can anyone please help on it Regards, Supriya

Hi everyone, I'm looking for documentation or guidance regarding the download document from s3 bucket. My node is completing but no file is appearing in the target folder. So, what could be the issue?

Hi, When you call a REST API and have such a reply below. How would the best pratice to cast the response to a CDT please ?Do you consider this ER must always return a generic CDT reply (solution A),or do you consider this ER must return 2 different CDTs according the reply, but in this case, we would have to handle a condition (Solution B) Response Ok from API : body: {  "id" : 1212  "url" : "https...."} Error Response from API : body: {  "developerMessage": "file already used",  "errorCode":102 } Solution A : type!response(  OK: {  /* Filled if OK */    id : 1212    url : "https...."  },  ERROR {  /* Filled when Error */    developerMessage: "file already used",   errorCode: 102 } Solution B : 2 different CDTs type!errorResponse(  developerMessage: "file already used",  errorCode: 102) type!

Hello, I am using the PDF from XSL-FO Transformation with Fonts Smart Service from the Dynamic Document Generator (https://community.appian.com/b/appmarket/posts/dynamic-document-generator) plugin, version 1.9.1 I have no examples of using this Smart Service and the plugin documentation doesn't have specific examples. I have tried to use the only complete code I can find in the community: https://community.appian.com/discussions/f/plug-ins/17891/pdf-from-xsl-fo-smart-service  This produces a PDF without errors, but when I try to open it I get a "Damaged file" from Acrobat Reader. This is how I configured the Smart Service: Xml Document: a constant to test.xml file, with the code from the example Xsl Document: a constant to _xslStyleSheet.xsl file, with the code from the example Xsl Parameters: null Font Document: null Font Italic Document: null Font Bold Document: null Font Bold Italic Document: null Create New&

I have a column req id in database which is auto generated when I save user details. Now when the form is submitted to supervisor I want that req id should be displayed in read only mode. 

Hello Everyone, I am new to Appian I am trying to use Integration object where I have used QR Code Generator API I want to use that body ID 4424 but when I am calling that in Expression rule it is giving reaction tree so can you please help me how can I get that body ID.

Hi All, Is anyone aware of Export Database Data to CSV smart service? We are using this smart service in one of our processes and saving the data in one table using Import Database Data from CSV. Export in CSV is working fine but when importing the data in table, it is giving format error on date column. We want to find how this Export Database Data to CSV works to understand if this format change is occuring when generating the CSV. We are currently analysing all the possibilities of this issue. Kindly assist. Thanks and Regards,Diksha

Where/how do i create a new process calendar for my application? unable to find the Process calendar option in the gear icon that i see on the top.

Hi, Scenario 1: I am facing time difference when I am make a DB(postgre) entry via Appian. I am trying to upload an excel from Appian UI with date field column. The database field name updt_td And crt_ts has default values assigned as current timestamp. On uploading my excel I am not passing the above two fields in excel. My Appian user is timezone is EST. After writing to table the default value of these 2 columns get updated with difference of 5 hrs. for EX: If I am triggering at 24-11-2022 10:00 EST in database it shows 24-11-2022 3:30. this value is generating by default if we give column as null. Scenario 2: If in a DB column I pass the value as Now function from my process Model, then also I get the time as mentioned above(increased by 5 hrs). Scenario 3: if I normally write an insert query in database then it takes take default value which is correct. In short when i am uploading via Appian it is taking wrong time.

Hi, I am trying to pass the timestamp value which is of type text in CDT from upstream through webapi. The milliseconds part is getting rounded off automatically Value from Upstream: 2022-11-21T09:00:56.998992Z Roundoff Value: 2022-11-21T09:00:57Z Expected format : %Y-%m-%dT%H:%M:%S.%fZ" But I need to send the same value from my upstream to my downstream system Any solution for the above please?

Hello, is there any way I can remove this window from the SITE and directly start from the Login Page?   I also Removed the  My Learning Journey Contact Appian (Sign-in Page Links) from the Admin console but it is not reflecting on the SITE.

Hi, I am unable to convert csv to excel using smart service "Generate Excel from CSV" after downloading plugin "CSV to Excel", version: 1.0.1. It was working earlier with version 1.0.0. Please update us with a solution to this since it is impacting business requirements. Regards, Akansha Kumari

Hi, I want to get local!notes.createdDateTime value out of local.notes by matching the note Id with local!caseNote.noteId, where local!notes was created by querying from a record type, and local!caseNote is a CDT type. Not sure why I got the error above, as I already use square brackets for local.notes local!result: index( local!notes['recordType!{0b920cc5-462c-4191-981c-afe3a33f9ce4} Reference Data - Notes.fields.{a447478e-53ee-40e5-80dc-6588861432fb}createdDateTime'], wherecontains( local!caseNote.noteId, local!notes.id ), null ), Could anyone help? Thank you!

Hi,  I would like to realize a site with this layout where billboard component stay on all page as on the top and on the side and not as my result. thanks

Hi, I've created an Integration component and I have a PDF to send to a remote REST API (by POST method). So I've created an Appian document, and I've upload a PDF file (Test1.pdf) as it. When I call the remote API, I get an error in the response : "developerMessage : Extension non authorized - filename: "Test1.pdf.zip"  " Do you know why this component is adding ".zip" extension to the PDF file ? Of course, I've tested it before in Postman and all works fine. In my request body (in Appian), I've set my param like this : Name : "document"   Content Type : Document (auto-detect) Value : (RI is uploaded with Test1.pdf) I've tried another way : Content Type = Custom (with  application/pdf) but I obtain another error : "Internal error: Required request part 'document' is not present" Any idea ?