Discussion Categories

Hi! I'm working on version 24.3 with Spanish as the primary language, and I've added a document upload component (a!fileUploadField) to an interface with validation to receive only an XLSX document. I used a file originally with an .xlsx extension and it validates well, but if I manually change the extension to .pdf so it converts, for example, and then upload it, I get an error that I didn't capture in my validation: "File could not be uploaded. Reason: The file extension does not match its underlying file type." It doesn't actually upload the document, and the error persists even without the attached document. Or if I upload another correct document, I have to refresh the entire page for it to stop appearing. Is there a way to bypass this validation and just leave the one I have manually, or is there a way to update the validation when a new document is uploaded?

We are integrating Kafka plugin detected two incorrect behaviors:   The first (and most important) issue is a problem arising from the way we insert into the "tm_job_transaction" table. The "scheduled_date" field doesn't allow nulls, but the INSERT is returning a null in that field. After reviewing the database logs (RDS for MySQL), this is the SQL statement the plugin is generating.   As you can see, the description table is this. scheduled_date is not null But the plugin generate this SQL sentence   2025-10-09T08:12:39.717781Z1625671 QueryINSERT INTO tm_job_transaction (job_type_id, context_json, scheduled_date, status_id) VALUES (132, '{"topic":"sbna.payment_execution.ach_payment_exception_created.json.eb.01evts0039v1bed","partition":0,"offset":603,"key":null,"value":"{\\"PARTACCOUNTNUM\\":\\"031700013000500346\\",\\"detail-type\\":\\&

Hi, I received mail saying I can't get my passed "Appian Certified senior developer" certificate since I don't satisfy the pre-requisite which  I was not aware  of for the exam. So, My question is if i pass "Appian Certified Associate Developer" will I get my " Appian Certified Senior Developer" certificate?  or again I have  to reappear for the same? Thank you.

Hi, I am generating PDF from DOCX  value is displaying correct in doc file , but it is overlapping in PDF How to reslove this ? DOC FILE: PDF :

Hello All, While updating CDT, got below error An error occurred while trying to write to the entity "SEC_IPOMarginMapping" [id=a6da64a0-8b67-4c95-9eee-0073b364a76c@705410, type=SEC_IPO_Margin_Mapping_List (id=9412)] (data store: SEC Securities DS). Details: javax.persistence.EntityExistsException: A different object with the same identifier value was already associated with the session : [SECIPOMarginMappingListDT22360#2] Data: TypedValue[it=9413, v={array of values}. The Unique identifier column is set to auto increment. Please advise. Regards.

Dear Team, When I am working on a case in workspace, I observed that unless I manually change the case status and assignee from the 3 dots button, these fields do not change automatically. Is this an expected behavior? For example, even if all the tasks of a case are completed, and I manually do not change the status, the status remains "open".

Hi, This Morning when i am trying to download the Installer from my Robot it is giving me the 403 error. And i haven't faced this error yesterday and not sure what happened. Please if any one knows the resolution kindly suggest here.

Hi, I have created one custom record field where it calculated sum of all the event points present in the table.But I'm trying to display this data in the grid based on the date range selection so basically if that date range has only one row with event point = 10, it should display only row with value 10 but it is displaying the sum of all 100 rows in a single row. How to handle single row data calculation in appian records?

Hi, I'm using the Google Charts Component a!googleTimelineChartField, and am wondering if there is a configuration I'm missing or a better solution to a timezone issue I've come across. I'm passing in queried data that is in the user's time zone (e.g., GMT+1:00), but the Timeline component seems to always convert it to UTC (tested with other time zones and they all seem to convert the shown chart data to UTC). The easiest solution is to apply local() on the data to essentially 'double apply' the time zone, so that when the timeline tries to convert it to UTC, it actually shows up in the user's time zone as required (e.g., a user's offset of -3:00 is double applied as -6:00 so that when the chart converts to UTC, adding 3 hours, it's shown to the user still as -3:00). With local() applied, it matches the data in the grid which does show the data in the user's time zone as usual: I'm wondering if I've missed some obvious conf

Hello everyone and please help with this request:  1. Class Member Status Updates: We need class members who were enrolled in MH sessions to have their status updated from Active to Closed. When end dates were entered at the time of closure, we assumed the status would update automatically, but it appears those cases are still showing as active in the database.

I have a question about the performance of data processing. I have a query a list from record type A, and now I want to filter some data from the data I queried. I have two ways to do that, one is use query record type and add a filter to get the data I want, another is I use logic function to get the data from the list I queried.  My question is, is there a big performance difference between these two solutions? If yes which way is preferred. If no how about CDT.  Because when I code in Java, our strategy is better to query the database only once. But I'm not sure is this suit for Appian. But I think records type has cache like Redis, so even query the record type too much times, it will not cause performance problems. But I'm not sure if my thought is right?

Hi Team, I am facing issue while trying to append the data to rule input , I have editable gird with multiple components with add and remove option using same component i.e dynamic link, so I am trying to update/add some data based on the item getting added. Its working 1st time , if i change the plan, scenario they are like button to navigate. i try adding it to different plan its not appending  it. only 1st time added data is reflecting. localVariables( a!localVariables( local!customDataforNewPlan: { a!map( prcRequestId: 1, wmsRequestId: 101, annualfee: 1000, minimumfee: 0, sequence: 1, amount: 500, createdby: "user1", createdon: now(), updatedby: "user1", updatedon: now(), isactive: true() ), a!map( prcRequestId: 2, wmsRequestId: 102, annualfee: 2000, minimumfee: 0, sequence: 2, amount: 1000, createdby: "user2", createdon: now(), updatedby: "user

Hi team, I'm exploring options to fetch user login audit logs for extended periods such as the last 3 months, 6 months, or 1 year. Currently, I only see daily login audit data available. Is there a more efficient or consolidated approach to retrieve historical login activity over longer durations? Any guidance or best practices from the community would be appreciated.

I am trying to invoke an Appian web-Api using Insomnia, which is a GET method, it queries db and fetches results.I am passing the Api key as header in insomnia.I have mapped the service accounts and security every thing correctly, but still i am nit able to invoke the API.I am getting this error : Error: Couldn't resolve host name

I passed the ACD101 certification exam, where can I see the breakdown of how many answers I got right by category? The screen closed immediately after I finished the exam.

Hi everyone, I'm running into an unexpected issue when trying to delete a document immediately after uploading it through an integration in the same process model. I have an interface where the user uploads an Excel file, which gets stored temporarily in Document Management. From that interface, I start a Process Model that looks like this (see attached image): Start Node Gateway → checks if a document exists HTTP Integration (CEDT_INT_postUpload) → sends the file to an external endpoint Delete Document → deletes the temporary file after upload End Node When the process reaches the Delete Document node, it seems that Appian hasn’t finished handling or streaming the document yet. As a result, the integration fails or the file never actually reaches the destination folder. If I remove the Delete Document node (or move it to a later step, e.g., after a short delay or in a separate subprocess), everything works fine — the upload completes successf

Hello,I am trying to create a custom UI component that will take input the image reference, height, width and unit (px, pt, %). It will display the image in the UI with provided height width. I need this as it is on of my requirement. I need to set custom height width of image.Now, How to achieve this. I had created a project like below:custom-image-plugin/ ├── webpack.config.js ├── package.json├── appian-component-plugin.xml└── src/        └── customImage/                ├── ImageComponent.jsx                └── index.jsBuild this component and added to the zip file the build js and appian-component-plugin.xml and trying to deploy as plugin, but it failed. Can't find any logs why it is failed.Help needed1. How to achieve this? 2. Where to find the logs for the failure.

Hi all,     I want to extract all the data of table (multiple table) and export to excel and generate report and then email. we don't have CDT we use record type. please help me how to extract data from record type or database and export to excel, generate report & email. What i have tried:  I used Export SQL to Excel plug in with sql query and Jndi name which is my data source but it is throwing me error as "The following error was raised by the Export to Excel function:  null". Please help me to resolve this issue or if there is any other way let me know. Thanks

Hi All, I basically created a custom between date for my users. The purpose of it is basically to mimic the start date of a month to the end date of the month for my data. Shown below is basically what it does: My question here is this. From my understanding, Appian's database stores any datetimes column as UTC, before converting it back to whatever timezone the user is from during the interface display. However, what exactly should I set as my between date during the process of filtering? I'm unsure of how exactly the query filter will communicate with my cloud database (my record type) to retrieve data. My worry is that the values are inaccurate and data is wrongly displayed and calculated due to the some edge cases, e.g. on the last day of the month. Here is my code for the between: As you can see from the "Chosen From Date" and "Chosen To Date", I initially attempted to custom fit it to my timezone. During this process, I returned the value create

Hi All, I am getting the below error at the bottom of interface canvas when configuring the GridPlus component. I am on Appian version 25.2. Error: SyntaxError: Unexpected token '<', "<!DOCTYPE "... is not valid JSON Use case: An user input grid where user can copy and paste large data set from excel  I have followed the documentation and all the expression rules(queryRuleName, columnConfigs) are working individually. Any guidance will be appreciated. 

Hi Everyone,I am trying to export a view from DB using "Export DSE to Excel" smart service but often it's failing throwing the error.The view is a simple view with 13 columns and with hardly 5k data, we are using filters also when we are trying to export using that smart service but still it's failing.Any leads would be appreciated.Here i am attaching the error i am getting.Thanks in advance.ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=28413, classname=com.appiancorp.process.runtime.activities.DataExportEntityExcelSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: Error accessing data store entity: Entity_Name. Please contact a system administrator for additional details. at com.appiancorp.dataexport.strategy.QueryExceptionStrategyDse.getOriginSpecificException(QueryExceptionStrategyDse.java:20) at com.appiancorp.dataexport.strategy.QueryExceptionStrategyBase.makeQuery

How to remove duplicate letters from the string without changing case of letters input "Deleted" output "Delt"

I’ve set up a date search in my Appian interface backed by a Cloud DB table. When users select a date, it updates a rule input, which is then used to filter records. The filtering works well and shows only the data for that selected date.query: a!query( filter: if( isnull(ri!onInputChange), null, a!queryFilter( field: "createdOnDate", operator: "=", value: ri!onInputChange ) ) But, when I am adding the interface as a page to the Site, I am getting the error below:Error Evaluating UI Expression Expression evaluation error [evaluation ID = 296a3:3b232] in rule <table_Name> : Cannot apply operator [EQUALS] to field [createdOnDate] when comparing to value [TypedValue[it=49,v=<null>]].

I have created a web api for uploading documents into appian applicationa!localVariables( local!body:http!request.body, local!key: http!request.pathSegments, local!keyNumber:regexfirstmatch(pattern: "\d+", searchString: local!key), local!requestStructure: rule!PRE_FormatRcoDocumentRequestFromMyWorldRequest(jsonRequest: todocument(local!body), key: local!key), if( or( a!isNullOrEmpty(local!requestStructure), a!isNullOrEmpty(local!key) ), a!httpResponse( statusCode: 400, headers: { a!httpHeader( name: "Content-Type", value: "application/json" ) }, body: a!toJson(a!map(error: local!requestStructure)) ), a!startProcess( processModel: cons!PRE_PM_UPLOAD_DOCUMENTS, processParameters: { uploadDocuments:local!requestStructure, intakeMain:'recordType!{9228ede4-797f-443e-ba77-59aeed242b7a}PRELUDE Intake Main'( 'recordType!{9228ede4-797f-443e-ba77-59aeed24

I have 2 synced records. The first one is notice and the second is notice history I have a grid that displays info from the notice history record, and I am trying to sync it when the related record of notice is updated, but it is not syncing.. My record type is: recordType!BTTNoticeHistory My identifier is: pv!notice[recordType!BTTNotice.fields.noticeID] Any help would be much appreciated!