JuniorSeniorRecordswhat are the best practice you follow while creating query rule in Appain?Below are the best practices, I follow.1. Optimize Data Retrieval (Fields & Paging)Parameterize Selection Fields: Always pass fields as a rule input (List of Text/Record Field...Anonymous6mo ago1162
JuniorSeniorCommonDatabaseIf there is an error occurred in a queryEntity rule, what are the possible reasons ?When answering this in a technical interview, categorize your response to show a structured understanding of how Appian interacts with the database."Errors in an a!queryEntity() ru...Anonymous6mo ago1112
JuniorCommonScenarioQuery ExpressionsSometimes we encounter memory threshold issues while querying data in Appian. Why does this happen, and what are the best practices to avoid it?Why Memory Threshold Issues Happen in Appian1. Appian has a built-in memory cap for query results Appian imposes a memory threshold on query rules to prevent excessively large resu...Anonymous6mo ago401
SeniorCommonFrequently AskedQuery ExpressionsIf query entity rule is slow, how do you analysis and improve the performance of it?When a query rule is slow, I approach it systematically by checking rule dependencies, data volume, query design and indexing. Check Rule Dependencies FirstBefore optimizing the qu...#performanceAnonymous6mo ago251
SeniorLead/ArchitectScenarioQuery ExpressionsProvide all of the steps you would take to analyze feedback from users of an existing application, plan design changes, and complete a refactor of the application.At your firm's financial services client, a senior transaction advisory group has complained about an existing application. The group handles hundreds of high-value, current financial transaction approvals, related to many thousands of previously approved clients. Because these transactions are time-sensitive, multiple executives often monitor the same queue simultaneously to complete reviews assigned to their group. Their primary issues are not knowing when tasks are completed by other group members, abandoned tasks that have an "in progress" status, delayed task completion time, lack of transparency into assigned tasks, and an inability to reassign tasks they've accepted. Additionally, the group complains about load times for the high volume of data they manage, and irrelevant transactions and tasks showing in their dashboard. This question addresses delivery methodology and multiple technical design aspects (task locking, UI/UX, and query performance improvement).Delivery Methodology First, to address t...#tasklock#query_performanceridgesawfly51753w ago140
JuniorSeniorSecurityExplain Group rule in Appian - For group memberships, Or How to manage users in group dynamically?There is a feature in Appian which could be called as "Automatic membership rule" - Officially called as Membership Rules - allows us to add users by rule based criteria, and could...vivedhasri2311231mo ago120
JuniorQuery ExpressionsA developer creates a Connected System and an Integration object that calls an external REST API. During testing, the call succeeds, but in the process model the Smart Service using that integration occasionally returns a success: false result even though the HTTP response code is 200. What is the most likely explanation?In Appian, the HTTP response code and the integration success status are two separate things. An integration can return HTTP 200 (meaning the server responded w...#integrationsAnonymous5d ago40