JuniorScenarioExpressionsWhen extracting data from a PDF, the date is returned as a string, for example, "May 12th 2026" or "Apr 4th 2026". However, the corresponding field in the database is of type Date, so passing the string directly will not work.How would you convert this extracted string into a valid Appian Date before writing it to the database?I would use an expression rule to convert the extracted date string into an Appian Date before passing it to the database.For example, if the extracted date is "May 12th 2026", I w...#codingAnonymous1w ago180
SeniorExpressionsTake input as an Array : { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };Print it in 2-D form with where each sub-Array will have "N" elementsEx: Array : { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }; N=2Output= {{1,2},{3,4},{5,6},{7,8},{9,10}}a!localVariables( local!array: { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }, local!N: 2, local!list: ceiling(length(local!array) / local!N), a!forEach( items: enumerate(local!list) + 1...Anonymous1w ago151
JuniorSeniorScenarioInterfacesA UAT user shares a production error screenshot displaying the generic message: "Contact your administrator." It includes an error number (e.g., 954c8:bb743). You do not have production screen or data access, but you do have access to the Development environment and the production server logs. How would you debug and resolve this issue?Locate the Root Cause in the LogsAnalyze stdout Logs: I will first check the "tomcat-stdOut.log" file on the production server to locate the time of the error and se...#system logsAnonymous2mo ago952
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...vivedhasri2311232mo ago700
JuniorExpressionsGiven a string, write a program to count the frequency of each word and display the word along with its count.Input: "Hello, test string, test"Output: Hello - 1test - 2string - 1a!localVariables( local!data : "Hello, test string, test", local!data1: split(local!data," "), local!uniqData: union(local!data1,local!data1), a!forEach( items: local!uniqDa...#codingAnonymous3mo ago671
JuniorSeniorExpressionsIn Appian, Write an expression to check whether it is a Palindrome or Not ?The purpose of this expression rule is to determine whether a given string is a Palindrome.A palindrome is a word, phrase, or sequence that reads the same forward and backward.Exam...Anonymous3mo ago852
SeniorJuniorExpressionsIn Appian, Find vowels in the given array using expression rule. Expected output : { { word: "Apple", vowels: {"A","e"} }, { word: "Sky", vowels: {} }, { word: "Orange", vowels: {"O","a","e"} }, { word: "Fly", vowels: {} }}a!localVariables( local!words: { "Apple", "Sky", "Orange", "Fly" }, a!forEach( items: local!words, expression: a!localVariables( local!word: fv!item, { wor...#codingAnonymous3mo ago641
JuniorExpressionsHow to remove characters from a string ?You have a list of strings like:{"ABHello", "ABAppian", "ABWorld"}Each value starts with "AB", and the goal is to remove this prefix from every string.We can achieve this using a!forEach() along with the mid() and len() functions.a!localVariables( local!array: {"ABHello", "ABAppian", "ABWorld"}, a!forEach( items: local!array...#codingAnonymous5mo ago891
JuniorExpressionsDifference between now() and today() ?The difference between now() and today() mainly comes down to time component, timezone handling, and datatype (this is especially relevant in platforms like Appian, SQL, or similar...Anonymous5mo ago1202
JuniorExpressionsExpression based hands on a) Given 4 dictionaries of the students data with id, name and city, Asked me to remove the students which belongs to city Pune b) Update dict data, Change city name Mumbai to city name Bangalore Sample Data: local!students: { a!map(id: 1, name: "John", city: "Pune"), a!map(id: 2, name: "Sam", city: "Mumbai"), a!map(id: 3, name: "Ravi", city: "Pune"), a!map(id: 4, name: "Anu", city: "Delhi") }a) Solution :a!localVariables( local!students: { a!map(id: 1, name: "John", city: "Pune"), a!map(id: 2, name: "Sam", city: "Mumbai"), a!map(id: 3, name: "Ravi", city: "Pu...#codingAnonymous5mo ago1532