Best Practices

3043 ms peak average - MVS Export CDT to Excel (0005e34f-02ca-8000-6ee0-010000010000) -> Export Data Store Entity to Excel ( Health Check report) Export Data Store Entity to Excel smart service is taking too long to convert what will be the alternative of this service to replace with.

Hi All, We have a requirement where we need to automatically save data to DB from site page if user is not performing any action for defined time.Please make a note that we looking for a solution which would save data without any user interaction.Any help is highly appreciated. Thanks!Mayur Mondhe

I am looking for some advice on achieving the auto save functionality within the Appian interface. 

Hello, I would like to inquire about the best practice for converting a large PDF document to base64 (approximately 500 MB). Currently, when using the base64todoc node in the process model, the conversion takes a considerable amount of time to complete.Could you please advise on the most efficient approach to perform this conversion and achieve the shortest possible processing time? Thanks,

Hi all,What is the recommended best practice for implementing a multi-tenant application in Appian?The following considerations are particularly important:Performance - The solution should scale efficiently as the number of tenants and users grows. Data Restoration - We need the ability to restore data for a specific tenant to a previous point in time without impacting other tenants. Security - There must be zero risk of users from one tenant accessing or viewing data belonging to another tenant. Maintainability - The solution should be easy to manage, support, and extend over time.I would appreciate any recommendations, architecture patterns, or lessons learned from similar Appian implementations.Thanks.

Just curious if CE will upgrade to 26.7 soon or it waits for 26.9

I want to create custom Hub for my 4 applications where user can create request, view the request, work on assigned tasks , how can i do , please suggest me the possible approach

We have an external event that can impact up to 1M+ Case records. For each affected Case, we need to: Update 3 fields in the Case table. Create a corresponding Event History record. We're evaluating the following approaches: Option 1 – Appian Write Records Approach A Query Cases in batches of 5000 Use MNI to process each Case in a single Write Records node to update the Case and create the corresponding Event History record Loop until all affected Cases are processed Approach B Query Cases in batches of 5000 Update all affected Cases for the batch in a Script Task Construct the corresponding 5,000 Event History records Use one Write Records node to bulk update the 5000 Case records Use a second Write Records node to bulk insert the 5000 Event History records Loop until all affected Cases are processed Option 2 – Stored Procedure Use a stored procedure to bulk update Case records and bulk insert Event History records Persist affected Case IDs and Event History

We have an external supplier portal in Appian where we need to implement MFA to hide sensitive sections on interface until verification is completed within the session. Preference is to avoid app-based authenticators as some suppliers are hesitant to install anything. Has anyone implemented something similar? Looking for suggestions on: Step-up MFA approach for external Appian portal users Conditionally showing/hiding sections based on completed verification App-free options like email OTP or SMS OTP that work well in Appian

I am currently preparing for the Appian ACD101 exam and came across a question that I am not completely sure about.Questions: How do you refer to the metadata of a process model object within the process model expressions? For example: the creator, name, or description.A- Process Properties, referred to in process model expressions using the pp! domain. B- Process Variables, referred to in process model expressions using the pv! domain. C- Process Model Properties, referred to in process model expressions using the pm! domain.Which option is correct, and how would you explain the reasoning behind it? I would appreciate any insights from those who have studied this topic or have recently taken the ADC101 exam.

Hello: I am trying to create a RecordType synchronized with a web-service.  One of the data objects obtained doesn't always have the same number of sub-data points (see nutrients in the image).  In order for me to store the nutrients values, right now, I am creating 20 columns (assuming a max) and using a forEach to store each value.  Is there a better way to do this? Thank you.  

Hi Community, I'm building an HTML-to-PDF generation flow and need to embed an employee photo (stored as an Appian Document) directly into an <img> tag as a Base64 data URL, like this: <img src="data:image/png;base64,{BASE64_STRING}" /> I want to construct the value in an Appian expression as: "data:image/png;base64," & base64Data My question: Is there a built-in Appian expression function to convert a Document to a Base64 string? Using the Appian document URL directly in <img src> does not work. Thank you

How can I optimize the performance of my Appian application?

I am considering implementing pessimistic locking in Appian. However, I have heard that pessimistic locking can potentially degrade performance because it restricts concurrency. In practice, how much impact does pessimistic locking typically have on performance? Also, from a best practice perspective in Appian, what kind of design or implementation approaches should be considered? Specifically, I would appreciate guidance on topics such as: In which scenarios does pessimistic locking have a significant performance impact? When should pessimistic locking be used, and when should it be avoided? If pessimistic locking is required, are there any design techniques or best practices to minimize its performance impact?

Is there any way in Appian to capture the previous state?I have a form with a couple of dop downs where the user selects different assignees for different tasksI want to able to send an email only to the changed users. Is there any way to compare old user values with new ones to see if changes happen?

Hello all, I have come across certain columns of different tables which are not being used in anyway. To validate  this, I have done the following : Check for CDT dependencies Check for record type dependencies Search for usage of the field/column globally in the application Based on the above, it appears that these fields are not being referenced by anything. But prior to deleting the columns, I wanted to get your feedback regarding the following: Does the above process ensure that the columns can be deleted without causing any issues ? Is there anything else that needs to be checked prior to deleting such columns (Process Models, integration etc.) ? What is the best way to delete such columns in Appian ? Am I supposed to deprecate these columns prior to their deletion ? Thanks

Hi everyone,  I'm having a multi layer nested CDT (Nested CDT that is a column in another nested CDT column of the main CDT that uses as data type) which is taking too long to query data and sometimes causes time out error. I would love to have some suggestion to optimise/ replace it with something else if possible.  Thank you 

Hi everyone, I’m working on a large and complex process where we are not using User Input Tasks. Instead, we implemented a pool-based approach, where each group has its own pool of requests. All request data is stored in the database. We also have an Admin Configuration interface that allows the admin to enable or disable certain tasks for specific groups. For example, in the database we store a boolean flag: true → the request/task should appear in the pool false → the request/task should no longer appear On the interface side, we are using a grid that queries the database and filters the tasks based on this flag to display the pool for each group. The issue we are facing is the following: When the admin disables a task (changing the flag from true to false), the request still appears in the pool grid. It only disappears after performing a hard browser refresh. The standard refresh mechanisms in the interface do not update the grid immediately. My questions are:

Hi, What is the most efficient way to retrieve data from a large table (more than 4 million rows) in Appian? When I use queryEntity to fetch data from this table, it takes a long time to execute, which negatively impacts Appian’s performance. How can I improve the data retrieval process? My current approach to solve the issue: I split the data retrieval into smaller batches. Specifically, I: Created multiple records that point to the same source table. Used the foreach function to query each record in batches of 5,000 rows. Used the union function to combine the results from each batch. Used the union function to combine the results from each query record. Then, combined the results across all the records to get the complete dataset. I’m concerned about future system complexity.Do I really need to create multiple records and change the system design just to retrieve all the data from a large table? Or is there a better, more efficient way

In one of our production apps, we currently send emails directly from the main process models using the Send Email smart service. As volume is increasing, we’re starting to rethink whether this is the best long-term approach. For those who’ve worked on larger implementations — do you keep email logic in the main process, or move it to a reusable subprocess? Also curious how you’re handling retries and basic monitoring in production. Just trying to sense-check our design as the app scales.

Hi everyone,  I'm curious to know if anybody using Lightspeed Devops CI/CD pipeline with Appian. if so what's your take on it. Thank you

Hi , have 6 integrations in the process model flow , it should be run in sequence manner and each integration is depending on previous integration call, now i have to complete the process model within 5 see , could you please let me best approach to follow ? thanks!

Hi everyone, I’m starting a new application in Appian and I want to choose the right approach for storing and managing data. Should I go for  Data Store (CDT + Data Store mappings) from there creating record type or  Directly use the Record Type backed by a database table What's the purpose of data store generally? I meant by for the modern Appian developement do we need data store necessarily  Since this is a new build, I want to follow best practices and avoid making architectural mistakes early. My Question For a fresh application, what is the recommended approach for: Application/master/transactional data CRUD operations Reporting and relationships Security and scalability Long-term maintainability Should I rely on Data Store, PDP, Record Sync, or directly use a Database-backed Record Type? If you have any guidelines, comparison points, or real-world experience on which option is better in 2025 Appian architecture, please share your insights. Notes : 

Hello Appian Community, I’m exploring Appian Case Management and came across some implementations described as “case management style.” However, when researching, I see references to Appian Case Management as a native framework. Observations from typical implementations: Short-lived processes triggered on UI submission Routing logic partly handled via staric Match() expressions State stored in database tables Audit/history maintained manually in tables My questions: 1. In Appian, is Case Management a native framework that you configure, or is it just a coding style/pattern? 2. How can we objectively distinguish a true case management implementation from a hybrid or DB-driven workflow that only simulates case management? 3. Are there official Appian guidelines or best practices confirming this? Thank you for your guidance!

Hi Team, which tool is better to use for testing with appian application for automation testing? thanks!