Discussion Categories

I have a table with 100,000 records. In the development environment, I used queryEntity to retrieve the data without issues. However, in the production environment, the dataset is much larger, and performance has become a concern. I tried optimizing the query with selections and filters, but the large volume still causes problems. I considered using a stored procedure to handle the data retrieval with specific conditions. The downside is that any future changes to the database schema would require updating the stored procedure, leading to additional maintenance work. To address this, I implemented a paging strategy in Appian. I retrieve the first 100 records using pagingInfo and then loop through subsequent pages to fetch the rest of the data incrementally. This approach helps manage large datasets more efficiently within Appian. is there any approaches other than these , can you guys help me with this?

I have a workflow consisting of three forms: Customer Details, Address, and Health Care Details. Customer Details Form: After filling out this form, I save the information to the customer table via an API call. If this operation is successful, I proceed to the next form. If it fails, I delete the customer entry from the table. Address Form: Upon successful submission of the customer details, I fill out and submit the address form. Health Care Details Form: After successfully submitting the address form, I proceed to the health care details form. However, if an error occurs while saving the health care details to the table (for instance, a failure in the write operation), and no entry is created in the health care details table (which uses the customer ID as a foreign key), I need to delete the previously saved entries in both the customer and address tables to maintain data consistency. The challenge is that if a node fails during this process, Appian halts further execution, m

We are using 'Export Data Store Entity to Excel' smart service to write data into Excel files. We built a process model which copies an excel template and writes into the copy of the excel template to generate an excel file using this smart service.This smart service is pretty much doing a good job other than few issues which we are trying to find resolution. Here are couple of questions if you can help with. 1) We notice that formats maintained in the Excel template is getting lost if we write some values into that specific cell. Is there a known way to avoid this? (Please see the screen shot attached) 2) Also - we notice, in the cells, if we write numeric values, the generated excel is comming up with this 'comment' icon in cell corner. We tried to write the value as numeric to the cell. But looks like still that is not fixing the issue. Is there a known way to avoid this? (Please see the screen shot attached) 3) Is there a way to delete a sheet from the excel in the

hi team, we are trying to run 2 smart services in signle saveinto but one smart service is running in the backend but 2 nd smart service not working, is that validation in appian?or did i missed anything, could you please suggest me? thanks

Hi All, I am encountering the error mentioned in the subject whenever I try to open the summary of one of the requests. In the record view, we have configured the following expression: rule!summary_interface(record: rule!qry_record()). Note: When I switched from rule!qry_record to rv!record, the error disappeared. Initially, we suspected that the issue was caused by a large dataset. To address this, we reduced the query size to ensure it evaluates within 50ms. However, the error persists. To investigate further, I opened the summary interface object and tested it by passing the query rule directly. When I clicked "Test Object," it loaded without any errors. However, when I opened an unnamed interface and invoked the interface using the expression: rule!summary_interface(record: rule!qry_record()), the same error occurred.Also in error message , its specifically mentioned about one child interface which just shows grid data around 20 items. If i remove this interface from summ

Hi everyone, just wanted everyone's opinion on one of our process. We have multiple categories for which we have different set of user roles. They are stored in DB like category 1 -> category 1 roles with their users. And the count of rows is roughly 4000 in production. Role are 1 till Role 11. Categories are like 100+ and there can be multiple users for a role. Also, we have few user groups for few of our oversight roles so whenever there is change we add or remove users from group. So the thing is for Role 1 - Role 6 we are checking throughout application by querying the record with a batch size of 1 and with a single field, if it returns we believe the user has that set of access and we show the screen accordingly. For the rest we use if they are part of user groups and show the content accordingly.My question is what would be a better approach for this? To have groups for all roles and then whenever there is a change add/remove in all user groups? Won't t

I want to create a generic process model for update constant. I used update constant smart service as it required constant as input which is of type content constant. so i want to pass constant as process parameter. is it possible or is there any other way to do this?

I am using an RPA smart service within my process model.I pass through data to the RPA Smart Service which a bot will run to retireve data from a 3rd party application. PolicyNumberThe goal is to pull that information (policyNumber) out of the robotic task to use in the rest of the process model. At the moment the bot successfully captures and stores the data in the Variable, but on the Process Model side, it is still showing 'no value'. The result of the variable on the robotic task after a successful run:Any assistance on helping to retireve this text string or even persisting this data would be greatly appriciated.

Hello people! I have a problem with the dropdown component. My component is initially initialized with the value of a null variable, but when I change it to a valid value according to the range, it works normally, but when I click on the selection option (placeholder), I get the following error Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'interface' at function a!dropdownField [line 1098]: A dropdown component [label="Estado"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was and choiceValues was AC; AL; AM; AP; BA; CE; DF; ES; GO; MA; MG; MS; MT; PA; PB; PE; PI; PR; RJ; RN; RO; RR; RS; SC; SE; SP; TO. The variable has a null value and the component is understanding it as an invalid value. Can anyone help me?

Hi, We are using Compare and Deploy to deploy between environments where we have configured a service account so that objects will be deployed in the name of service account. However, we could see that deployment approver username also captured in design_objects.csv along with deployment service account whenever a data type is deployed. Can you please me in understanding the log behavior?

After upgrading to Appian 25.1, the logs indicate that all services are up and running. However, HTTPS calls to port 8080 are not working.  Am seeing the following warnings in the logs:  “Ignoring JAVA_HOME; using ES_JAVA_HOME instead” “Unable to load the config file: /home/.aws/config — Access Denied Exception” Any help in investigate why port 8080 is not up and running would be much appreciated? All 15 requested services are running [analytics00, analytics01, analytics02, channels, content, download-stats, execution00, execution01, execution02, forums, groups, notifications, notifications-email, portal, process-design] 0 [main] INFO com.appian.data.server.Watchdog - Data Server is starting using the [ALL_COMPONENTS_MODE] startup mode.18 [main] INFO com.appian.data.TopologyFactory - Loading topology /usr/local/appian/data-server/conf/appian-topology.xml *************************************************************************************

i'm using Export Data Store Entity to Excel plugin is giving the above error  = a!queryLogicalExpression( operator: "AND", logicalExpressions: { if( pv!isAdvanceSearch, { a!queryLogicalExpression( operator: "AND", filters: { { a!queryFilter( field: "firstname", operator: "includes", value: pv!firstName, applyWhen: a!isNotNullOrEmpty(pv!firstName) ), a!queryFilter( field: "middlename", operator: "includes", value: pv!middleName, applyWhen: a!isNotNullOrEmpty(pv!middleName) ), a!queryFilter( field: "lastname", operator: "includes", value: pv!lastName, applyWhen: a!isNotNullOrEmpty(pv!lastName) ), a!queryFilter( field: "screeningstatus", operator: "=", value: pv!scrStatus, applyWhen: a!isNotNullOrEmpty(pv!scrStatus) ), a!queryFilter( field: "country", operator: "=", value: pv!country, applyWhen: a!isNotNullOrEmpty(pv!country) ), a!queryFilter( field: &quot

a!richTextDisplayField( value: a!richTextItem( text: "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum." ) )] Example:  My Test should be this way, no matter the words amount __ ___ ______ __ ___ ___, __ _____ ___ ____ ______ __ ___ ______ __ ___ ___, __ _____ ___ ____ ______ So, how would I be able to justify a text? Because I haven't seen such option.  

I have a main zip file that contains other nested zip files. I need to extract all these files and apply some custom naming rules to the extracted files. Here’s what I’m looking to achieve: Extract the Main Zip File: Unzip the main archive to access the nested zip files. Nested Zip Files: Perform some validation on the names of the nested zip files. I'm facing two problems: 1-When I try to extract a zip file that contains nested zip files, it doesn't extract them correctly and doesn't output any errors. However, if I include other types of documents, like .docx or .txt, they are extracted correctly. 2-How can I read the contents of a zip file (e.g., the names and types of the nested files)? I’m using a zip extractor, but it doesn't seem to offer this option. Does anyone have any ideas on how to solve these issues?

Appian delivers process automation powered by enterprise AI, empowering organizations to design, automate, and optimize business processes through a unified platform for process orchestration, automation, and intelligence. This latest release, 25.2, introduces significant advancements and exciting features across the platform, including highlights on the new AI Document Center, document record type, smart search preview, and the agent studio beta.Join our team of Appian experts as they delve into the key highlights of this release. Tune in to see Appian 25.2 in action and engage with the experts by asking your questions.Turn on notifications to make sure you don't miss it!

Hi All, I am trying to send a document to external system that accepts form-data. I am using the content type "Multipart Form Data (multipart/form-data)". I would like to change the file name only for the integration call (without renaming the document in Appian). However, Appian automatically sends the document with its document name, not able to update/rename the file name.  Is there a way to override the filename in the request? Thanks in advance for your help!

We have created an interface using a!headerContentLayout() with isHeaderFixed: if(a!isPageWidth("PHONE"),false,true) and it works great if you are simply on the page.  But if you use it in a Record Action with a Dialog box the Fixed Header does not work. Is there a way to fix this?

In my application I have a two record types with a One to many relationship. recordType!Workflow -> recordType!Task. I have process that needs to create a Parent record and child records. Currently I have two Script Process Nodes.  Process 1. Creates workflow record and store in pv!workflow. Process 2. Creates multiple task records and appends to pv!workflowTasks. Then I call Write records to store the records to the db. My question is, do these have to be two seperate Script Process Nodes?  Or can I combine my logic into one Script Process Node where Output 1 creates the workflow record in pv!workflow and then the second output creates the task records and appends them to pv!workflow.tasks?

After upgrading to Appian 25.1, the logs indicate that all services are up and running I dont see any error. However, HTTP calls to port 8080 are not working.  We’re seeing the following warnings in the logs:  “Ignoring JAVA_HOME; using ES_JAVA_HOME instead” “Unable to load the config file: /home/.aws/.config — Access Denied Exception” All 15 requested services are running [analytics00, analytics01, analytics02, channels, content, download-stats, execution00, execution01, execution02, forums, groups, notifications, notifications-email, portal, process-design] 0 [main] INFO com.appian.data.server.Watchdog - Data Server is starting using the [ALL_COMPONENTS_MODE] startup mode.18 [main] INFO com.appian.data.TopologyFactory - Loading topology /usr/local/appian/data-server/conf/appian-topology.xml ************************************************************************************** Regenerating the server certificate.warning: ignoring JAVA_H

Hi Am trying an interface where I expect to call the record action on click of the card layout. I took the inspiration from the inspiration page mentioned below, however not able to call the record action. Is it possible? https://docs.appian.com/suite/help/25.1/sail/ins-agent-home-page.html

I have a process where I have two script nodes.  The First creates a parent record type and stores it to a PV!: 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance'( 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{707eb7ae-ea9f-446e-9f88-d818ff7227fb}parentType': typename(typeof(pv!event)), 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{74c50dc1-dd17-43f3-92b6-98bf5753125a}parentId': pv!eventId, 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{c939f3ac-6a45-4ca5-9441-44aa056523ca}targetCompletionDate': pv!event['recordType!{f07fa26e-a28d-44ca-ab58-7ba4db20200b}WPA1 Event.fields.{987c7817-ad5b-4c64-b91e-0ab1087a91ea}endDate'], 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{d18891c0-c267-4d9a-8370-4bb662b7be83}createdBy': loggedInUser(), 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{d2b

Hello Community, We are building an enterprise-grade BPM platform using Appian to manage various distributed banking processes such as loan applications, KYC, onboarding, and more. One of our architectural goals is to ensure flexibility and scalability, especially when dealing with multiple business domains and product types (e.g., Car Loan, House Loan, Personal Finance). In our design, we have a universal process registry (PROCESS_MASTER) that links to all BPM activities. However, each product and process can introduce different sets of business-specific fields. We want to allow for product/process-specific data entry without creating a separate CDT or database table per product. Proposed Approach: Store shared/common fields in a structured APPLICATION_DATA table. Store product-specific or process-specific fields using a DYNAMIC_ATTRIBUTES table (key-value structure) linked by master key. Use Appian expressions and record interfaces to dynamically render fields based on metadata. Use

Introducing Appian Skill Badges! Build your knowledge across Appian and showcase what you’ve learned by passing free, un-proctored exams on specific topics. Earn badges, share them with your network, and advance your career. Academy Online launched Skill Badges for three areas of expertise: UX Design, Data Design, and Appian Government Acquisitions Management Fundamentals. Stay tuned for more badges launching later this year. Click here to explore the program! 

The dropdown field is malfunctioning, displaying all available values as a single combined option instead of presenting them as separate selectable options. Any idea what might cause this behavior.  This is the expression that I am using:  a!queryRecordType_24r4( recordType: 'recordType!{2c57b299-d666-427e-ba44-342541c31f8f}AMS Workflow Type', pagingInfo: a!pagingInfo(1, 5000)).data['recordType!{2c57b299-d666-427e-ba44-342541c31f8f}AMS Workflow Type.fields.{81363ed4-9bc0-44f3-b5ef-e723de125744}description']when i test it separately as an expression it gives me a list and not a single unit

I have a process model that includes a script task with the following output: rule!SC_getImportPregressoPc(id: pv!index) The problem I'm facing is that I'm incrementing the index by 1 in each iteration to move to the next item, but the IDs in my dataset are not sequential. For example, I have IDs like 5, 6, 7, but the next ID might be 500 due to filtering applied by the rule, causing my process to exit early when it reaches a gap in the ID sequence. How can I configure the process to iterate over only the IDs present in my filtered list, rather than assuming a simple +1 progression? Any guidance would be appreciated!