Discussion Categories

Hello Appian Community!We currently have the export to CSV enables on all of our reports. We did have our production environment go down as a user was confused and exported the same report 27 times which started a sync of those reports and took down our prod server for high memory usage.What came out of this were some questions, is there anyway to show to the user that they have selected the export to csv button like a loading bar? Currently when a user selects this button it appears nothing is happening and then a document will pop-up after several minutes once completed. The next issue is we are experiencing some pretty slow load times. If we were to export a csv report in our UAT environment with 5000 lines we are seeing it take roughly 10 seconds. With that exact same report in production for 5000 lines we are seeing roughly 15 minutes. Is there any way for us to investigate this export feature to understand why we are seeing such slow load times?  Thanks, Jordan

I want to add  a field in db which should store data in array format . I will get this data via integration and i want it to be in an array. can someone help Integration output : { email :Test,addid:1193u, remove id:123, status:success, statausmessage:{     {          message :test1 success,           date:       }         {             message : test2 failed,             date:          }       }}

Hello, I have to get data from a Microsoft Access DB and put the data into Appian to run reports. I read online and it appears that I need to create an ODBC connection or use a tool like UCanAccess Driver. Is there a way to do this within Appian out of the box or with a plugin?

Hello community! I am very confused by this error. I have the below screenshot of an update function that is meant to update a record type called GF Utility where the rule input coming in is of type GF Utility.  I'm pretty sure I have 3 keys and 3 values but whenever a user logs in, the error in the subject pops. I tried testing the rule in the expression and it works just fine. Is there something I'm missing? I would appreciate all the help I can get on this and also if there is anything that needs clarification, please let me know! Also, here is the error in screenshot format as well

Hi, I'm trying to retrieve the data from tomcat-stdOut.log but it gives me a null value. Currently this function only works for me with login.audit

Hi Team, We have performed load test on Appian interface calling web integration using JMeter , we want to see the (CPU and Memory) during the test duration. Can you please help me to trace where can I find it ? Thanks  Bihitak

Hi Team, I am facing below error while deploying interface which has record type as a precedent. I have recently added 2 columns in record type and deployed it to other environment for the first time deployment went successfully with interface any record type later I made small change in the interface then I am unable to deploy the interface even though I have added record type to avoid the missing precedent issue. ERROR content _a-0000e6f8-8866-8000-9bc2-011c48011c48_1560555 102914 The content [id=102914 uuid=_a-0000e6f8-8866-8000-9bc2-011c48011c48_1560555] was not imported because a required precedent is missing: recordField [uuid=AFPFVisit location=Interface Definition] in record type [id=22 uuid=928b33df-26a0-46a4-8de9-540217145302] cannot be found. (APNX-1-4070-005) (APNX-1-4071-006) Kindly help me if you have any solution. Regards, Sireesha

hola que tal? estoy trenizando un problema al crear un campo de registro y es que me dice error al mometo de poner este código: a!match(value: rv!record[SPX Launch.success],equals: true,then: "Success",equals: false,then: "Failure",default: "Upcoming")... estoy aprendiendo así que lo copie del curso que estoy haciendo de aquí pero me dice error y la verdad no se como solucionarlo, alguien sabe?

Hi All, I have created an Interface and it has card layout , when clicking  on the link, the related interfaces having those graphs will get displayed. In goals interface above progress bar, there is New Goal button, upon clicking that a form layout will get displayed, A form layout gets populated , It will get filled based on the validations once this is done, I tried to click the create button , so that new goal will get displayed in the goals interface. As of now, I am unable to proceed further, atleast it should throw some exception, i will try to trace out the issue, I am unable to proceed further. I have provided the code for create button . may i know what could be the issue, is there a chance in Appian that error will not get displayed and it will not proceed as well. Here is the code snippet part of the button: a!buttonArrayLayout( buttons: a!buttonWidget( label: "Continue", value: local!currentFormStep + 1, saveInto: local!currentFormStep, style: &quot

Hi, I am getting this error ( The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete ) on DOCX From Dynamic Template node of my process model. In this process we are combining / merging multiple DOCX files to one.   Please help me with it.

Hi All, i have a query related to logical expression  as you can see their is a logic mentioned in below code which is i am using in a database table but now i need to use this logic in expression rule to show grid field so any one can help me to implement this logic or you can give any example we requird the filter on below case where status in('Started','Pending','Suspended','Resumed','On Going') OR ( in('Cancelled','Completed')AND ModifiedDate >= (GETDATE()-7))

I am getting this below error, while debugging Request Maintenance process model ERROR An error occurred while evaluating expression: =localize("de","","fr_CA","","ru","","sv","","pt","","ko","","el","","fr_CH","","it","","fr_FR","","iw","","es","","ar","","zh_HK","","en_GB","","th","","en_US",tostring("Request Maintenance for Vehicle: "pv!maintenance['recordType!{b5aaf6ce-8d6c-4517-b332-68ba3a0c3655}W003SA Maintenance.relationships.{6b611f24-010d-41e4-a738-f889ab7c2bea}vehicle.fields.{fc426423-e013-40d4-b3a3-505e88858e0d}vin']),"ja","","es_MX","","zh_CN","","pl","","t

I want search all records with not matching two keyword (CLOS & CANS) like: 1. ADVG XCLT QRPR 2. ADVG CLOS QRPR 3. ADVG CLOS CANS 4. ADVG PQRS QRPR from the 4 rows I want to display first and last rows. Rows having two word like CLOS and CANS shall not be display. So, I want to know which keyword I shall use in query function. Not Includes function work only on keyword. But this query have more than one keyword. Please advice.

Hi When I am trying to deploy a record type from Dev environment to Test environment I am getting below error as shown in below image.  Can anyone help please Regards Kumar

[p_appian_l1_03@unofz1go logs]$ cat tomcat-stdOut.log.2024-07-30 | grep XE7G2com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Contact your application administrator for help resolving this issue. Provide them with the following issue identifier: XE7G2 (APNX-1-4533-000)Caused by: com.appiancorp.suiteapi.common.exceptions.AppianException: Contact your application administrator for help resolving this issue. Provide them with the following issue identifier: XE7G2 (APNX-1-4533-000) We are getting same error on UI and in log other than above nothing is there in the log, how to find out where is the error or what all things should be checked  Any pointers will be helpful Thanks  Pooja  

Hi, I am trying to get a day's worth of rdbms-audit logs.However, I have tried the following expression, but could not get the logs that have been evacuated.Any help would be appreciated. Thanks in advance. Appian version:24.1 Log format: rdbms-audit.log.yyyy-mm-dd.* readlogpaging( logPath: "audit\rdbms\rdbms-audit.log." & tostring(year(today())) & "-" & substitute( padleft(tostring(month(today())), 2), " ", "0" ) & "-" & substitute( padleft(tostring(day(today())), 2) & "." & tostring(pv!LogCounter), " ", "0" ), startIndex: 1, batchSize: - 1).rows

Hello, I've an issue with a record type. I pass it to a process model, but when I start the process, the relative process variable result to be null, or with null fields. I tryed also to cast the record type in cdt before sending to process model, but anything changed. Someone can help me please? I leave some code below. Thank you version 1: link: a!startProcessLink( label: "SALVA", processModel: {cons!PVATRP_PRC_SALVA_OPERAZIONI}, processParameters: { operazioniInput:ri!operazioni, autorizzazioni: ri!autorizzazioni ) version 2: edit:  I realized that by running the process from the designer, it works correctly. The problem occurs only from the web site

Hi, I have created a dynamic form and have set the necessary values to the properties of the fields like this: required: true, requiredMessage: "*", validationGroup: "Questions" In the Button I also set the necessary properties like this: submit: true,validate: true, validationGroup: "Questions" In design view validation is working fine. The screenshot: But when it is running in the site, validation is not working even after clicking the button. The Screenshot: Can any one please help me regarding this and kindly clarify the reason?

I'm doing the step-by-step guide for appian developer where we're recreating the Acme Automobile example application and I encountered an error when trying to display the vehicle images in the grid. I followed all the points in the step by step guide exactly and the error I keep encountering is the following: Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 5]: User Does Not Have Rights to Perform this Operation The expression I'm using to display the image is the following:  if( a!isNullOrEmpty( fv!row[recordType!W#SA Vehicle.fields.image] ), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!W#SA Vehicle.fields.image] ) where the W#SA is only a placeholder and I have replaced it with my own prefix of course (references work). If anyone has any suggestions or gu

Hi all, I'm new to low code platforms. I've written an application (a statistical model) in Javascript. I want to develop some additional components in a low code platform such as some basic screens with a user interface and a database which will store the data to be sent to the model. The plan is to commercialise the model so we will also need to have controls over user access, billing functionality etc. I would appreciate any feedback as to whether Appian is a good platform for doing this, and/or whether there are any other recommendations. Thank you for your help.

Hi, is there a way to get the failed process model instances via an expression rule, like a function or something?

Hello Everyone ,  so i was having query regarding Doc Extraction skill's , anyone is having idea that how we can achieve Checkbox field extraction without having Reconcile DOC task ? because of this issue i have to look for AWS services for the same , it would be so useful if checkbox and table field we can extract automatic from Appian itself without having reconcile task! 

Hello Appian Community, I'm currently working on a Task where I need to clean up multiple versions of Appian objects, particularly interfaces and rules. Manually deleting each version is proving to be very time-consuming. Is there an efficient way to delete these versions in bulk? Any scripts, plugins, or built-in functionalities within Appian that could help streamline this process would be greatly appreciated.

Hi All, We have Appian Site URL like  careers.appian.com/.../ We need to get data from the Query string i.e search=software and location=McLean, Virginia The business case is we need to share this URL to 3rd Party APP , in which they have something called button action where they will configure this URL and send data from their APP to this URL using Query string and we as Appian has to get the data into our system  Is it possible or Not ? Thanks Bihitak

Hi, We are trying to use Kafka Tools plug-in to consume and publish from Kafka with Schema Registry from Confluent Cloud. This plug-in does not support AVRO format in Confluent's Schema Registry, so we're evaluating if we could solve this by creating a Smart Service Plug-in to serialize/deserialize with the AVRO Java libraries. The idea is to serialize the messages before using Publish to Kafka and then deserialize the data after Consume from Kafka stores them in db. Does anyone know if these Smart Services can send and receive the binary in AVRO format? Has anyone tried to do this or something similar? Thanks in advance