Best Practices

Hi everyone, I'm seeking guidance on best practices for handling a specific scenario in Appian. Here’s the situation: I have two records: Record A, with a primary key column named A1. Record B, with a primary key column named B1. There is a one-to-many relationship from Record A to Record B. I'm retrieving data of Record B using the 'relationship/related record data' from Record A, in both interfaces and expression rules. I've also defined the reverse relationship in Record B as many-to-one from Record B to Record A using the same column. However, when deploying, I encounter an issue with missing objects. Could you advise on the best course of action or Appian best practices for managing this type of relationship? Is there a recommended approach to avoid such issues in the future, or is there an alternative method for defining relationships? Thanks!

I have handle two XML files daily, each with a size of 50MB or more. These files are transferred via SFTP or FTP. Our goal is to extract specific values from these files, check their existence in our database, and either update existing records or insert new ones as necessary.Requirements: File Retrieval: Automate the retrieval of XML files from an SFTP or FTP server. Store the files temporarily within Appian or an external file storage service. Data Extraction: Parse the XML files to extract a list of values. Given the large file sizes, efficient parsing and processing strategies are needed. Data Validation and Update: Compare extracted values against existing database records. Update existing records with the latest values or insert new records as required. Performance Considerations: Handle large files efficiently, possibly by processing in chunks. Ensure database operations (updates and inserts) are optimized for performance.can any one suggest some best approach to do this.

HI Team, is there any documentation around Appian's Secure Coding practices which can relate to OWASP ? ~Gaurav

How does too many nodes in a process model increase memory footprint? Too many nodes in a process mode reduce readability and maintainability. However, not sure how it impacts(increase) memory footprint. Please provide your thoughts..

What will happen to the objects that are last modified by a user whose account is going to be deactivated soon?What are the precautionary steps that need to be taken while deactivating a user in appian? What about process models which are configured to run as whoever designed the process model??

These two functions are returning the same thing.is there any difference? 

Hi team, There are two interfaces, namely interfaceA and interfaceB, and interfaceB is a sub-interface of interfaceA. In the sub interfaceB, two localVariables are defined, namely b1 and b2. In the parent interfaceA, there is a button. I want to implement a function. When the button in interfaceA is clicked, b1 and b2 in interfaceB can be operated. How to achieve it? Is there a recommended solution? Thanks a lot!

Hello Techies, I am looking for ways to extract a list of environment constants in my application. I know I can export entire list of constants and look up the properties file but is there a better way within designer to achieve it?Thank you!

Hi Appian Community, [mention:5357deb643314f689f0553cc98556414:23b05a61c3e5445190d9bfa00453bce4]  [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:92ac9d4559ff43edb28eaa01ed77691b:e9ed411860ed4f2ba0265705b8793d05]  In our recent Pen testing report it was found that JSessionID is Visible in the browser's Developer tools under Inspect functionalities. Creating Security concerns in pen testing report . Anyone had previously been with such issue or Have any Idea how to handle the scenario.   

it apparently has no permissions, however it works when on interface, but it doesn't on the site. All permissions were conceded. This error message in instance details only happens when using the site itself. But when using the interface it doesn't. The S3 node simply doesn't access the document through the process model Any thoughts on it? Thanks in advance

Hi, Please find attached screenshot. How to remove the list of dictionary with size 'o'

how to find a process models by a particular smart services named like create user , sub process and script task....how we can filter??

I am using a!startprocess function from an interface to save some data to db, now lets say the process model being called encounters a run time error in some node, i need to show the user some custom message like ' some error occured' in the interface , onError dosent work here , as there was no issue starting the process.

Hi Community, Was going through documentation for breaking-a-chain and came across this point The amount of time between attended tasks exceeds the non-configurable limit of 10 minutes. Can anyone explain this pointer with example? What do we mean by when we say attended, unattended task. What is non-configurable limit and where can we see it It would be helpful if anyone provide explanation on breaking-a-chain in detail with example?

We have many objects and Applications, sometimes I know the object name, but can't locate to which Application it belongs to. Is there anyway I can find the belonging Application easily?

1.What Does Nullable = True or False means in XSD ? 2. i have installed an Appian from PlayStore in Mobile  . What is the server address to community .

hi, My team wanted to build a common library/application i.e. Global_CaseManagement where the application will be exported to 2 instances for 2 regions to share (similar to a common library), i.e. UK_Bank  and US_Bank.Let's name the rule as rule!Global_GetNextCase which used within a node by a common global process model namely ACTION - Get Next Case Given the rule Global_GetNextCase will have different logic for UK and US, what would be the recommended way to do the common rule override?The dependency graph as below :1. Global (application) -> ACTION - Get Next Case -> rule!Global_GetNextCase -> rule!Global_GetNextCase_UK2. Global (application) -> ACTION - Get Next Case -> rule!Global_GetNextCase -> rule!Global_GetNextCase_USThis way will create a problem where both UK and US rules will be imported into the instances respectively causing unwanted dependency issue, cause UK only needs&

Hello , Any best practices around how do we manage objects which are not required anymore ? Specially when those objects have been previously deployed to production.  Is it a best practice to delete such objects ? If this could be an option , then such objects could be easily deleted in the development environment but then how do we promote the deletion to high environments ? Or someone will have to manually delete them in the high environments ? Thank you. 

Hello all, currently I have 3 org, dev, QA, and prod.  I have made new inserts in a cloud data base table in the dev environment.  Given that the same table in the QA org have the same 14 entries as the table in dev org, what would be the best practice to deploy the update from said table from the dev to QA org.  Any help would be appreciated.

Over the pass few years much has changed for data structures within Appian, specifically with record types and custom data types (CDT). There does not seem to be any official documentation on how to convert an application designed using CDTs to one using records. While CDTs have not been entirely fazed out but rather relegated to support with plugins and smart services, it is often more performant and (based on Appian documentation) preferred to build using record types.  My questions are: For larger "legacy" systems is there a significant benefit to converting the existing CDTs used in process models, interfaces, rules, etc. to record types? Is there a fast and efficient way of converting these types from CDT to Record.

Hi！ As my requirement i need to queryRecordtype .Based on the results of a query using an expression rule in the interface dropdownI would like to select id when name is selected as shown in the image below. Thanks

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.

Can anyone help me for this so there is a task that I want to assign to user using Round Robin Scheduling so anyone has idea how I can perform this and get the best out of it 

Hello All,I wanted to give appian certifications. I am Appian developer do i need to give analyst certification prior to associate developer?Thanks

There is a requirement that we have a means for non-appian users to create new accounts in the application I am working on. Since Appian does not appear to have any built in means of allowing this, the current workaround is to make a web API that connects to an external site and kicks off a process model which can make new users. This kind of makes us nervous (particularly since there is no way to delete unnecessary users in Appian), so we added an admin approval step before the actual user creation stage, but we're still a little nervous about potential DDoS attacks and the like. Is there an in-Appian method to limit how often an API gets accessed? And if not, is there some other best practice to prevent attacks on Appian APIs?