Governance

I have a table with value column. Already I have implemented download link in my report based on the table. I need to add a new column with formatted value, front end I have done this, but download part, how can I manage(I dnt want to change backend table)

Hi Guys, In my project, we currently did a webapi to get the base 64 from system and pass into different system as base64. Due to this in prod we are facing large memory sizing and I came to know instead of passing bas64 we have a option to pass todocument to reduce the memory size . However, my question how other system can read if we are passing document? Please confirm the approach is possible or else suggest some other approach. Thanks, Pradeep Sridharan

Can anyone please help me on subjected issue as I am not able to access admin console. Also while debugging the process model, it is not getting completed after user input task form has been submitted. Kindly guide!

As there is so much white space shown .. how to prevent in interface ,extra white space

Hey Everyone,Not a technical issue just a question about the folder sizes in Appian. When I'm looking at folder I can see it has a size of 48.2 GB. But when I open it to see what is inside of it there are only a few items, where the size doesn't reach anywhere close to the stated 48.2 GB.

How to add social media icons and when we click on it , it should direct to a particular page?

Hi Team, We are using SQLBackupAndFTP tool for taking backup of database in MariaDB (Appian). We have installed the tool while setting up, getting an error stating that Database is not detected. Please find the attached snippet for reference. Please help us here to fix the issue. Thanks in advance. Best Regards, Raj

Hi, Is there a way to limit the number of concurrent sessions for users authenticating against SAML IdP, specifically Azure? We've tried configuring the limit as described in https://docs.appian.com/suite/help/20.4/Appian_Administration_Console.html#account-locking but it seems it's only applicable for Appian-based authentication. Thanks

Hi All, I came across a question where the environment should get upgraded to latest version. Should we start upgrading the higher environments first and go down to lower environment upgrade or vice-versa, and what will be the impact in both cases. Can someone help in knowing this impact?

Hi Experts, I have a requirement where I need to store 100 phone numbers in a given field, i.e Targets for now. And then to filter the data on all the columns considering if user searches with 555 then 2nd record should be returned Currently I was using a single table with structure as shown below TargetID (num) OrderID (num) Targets(varchar) 1 1 +91-9999999999+91-9999999999+91-8888888888 2 1 +91-9999999999+91-9999999999+91-8888888888+91-5555555555 Now, due to some performance issues, we need to get that targets column to be moved to a separate table and store all the phone numbers as a separate row, as shown in below tables TargetID OrderID 1 1 2 1 id TargetID Targets 1 1 +91-9999999999 2 1 +91-9999999999 3 1 +91-8888888888 4 2 +91-9999999999 5 2 +91-9999999999 6 2 +91-8888888888 7 2 +91-5555555555 Kindly suggest as how this can be implement, do we need to use nested CDT or if there is any other way possible. Thanks, Gaurav Singh

Should the conf.data.search-server.restclient.apiKey be the same on all nodes/servers in a distributed installation?

Privacy error while clicking on the Appian login link: Receiving the below screenshot error while hitting the Appian login basic link. After clicking on the login url we are receiving "Your connection is not private" error (full error message is as per the below screenshot).  We are always made to click on the "Advanced" option and then only the login page showing username and password appears. Please suggest how to avoid this privacy error everytime and how to go directly to the login page.

I got this from the Health Check Report: DSGN-0009 Appian Design # of objects with no admin group Medium 83 83 objects do not have an admin group defined. All objects should have an admin group explicitly defined or inherited from a parent container. Is there any fast way to identify which objects do not have an admin group defined? I hope I don't have to go one by one because I have thousands of objects.Thank you so much!

Hi Everyone,  From Postman, I am calling the Appian Web API. If it success i am getting status code twice(200 200) in the response. same for error scenario. I need to change anything? pls suggest solution for this. Thanks..

Hi Team , As per installation documentation , Appian suggested to use oracle OpenJDK for JAVA_HOME. But the linux machine we have has already IBM java .  Will it be possible to install appian with IBM java. or  Do we need install open jdk which comes with appian installer for JAVA_HOME. is there any advantage of using openjdk

Hello guys, I failed for the developer exam for the second time now. I studied for the Appian developer test for 180 hours, but i still failed the exam TWICE now. I'am lost i feel like i know everything but the way the questions are formulated is very hard. I just want to review the exam so i can maybe change my studying style.  i used the exam checklist, i studied the developer course, i took the practice test 12 times and i studied the appian documentation. ANY TIPS? thanks.

What are the best storage capabilities of Appian?

Can someone list out the pros & cons of Compare & Deploy functionality Appian provides. And What could be the reason one should go with separate outside Automate process of Deployment for e.g Export Package and Update into Repo and move along in upper environment via DevOPS tools and if there is any Database change then also use Repo to upload and then Move along with Jenkin Build and other tools.

Is there a way to create application and add provided artifacts into it on Appian using Process model or some other mechanism. Problem statement : Create Backup application from higher environemtn with provided artifacts added into the created applicaiton. export it before code promotion 

Hi all, This is my uses case. I have a reference table with 2 columns (id(PK) and description)  with all the possible statuses: 1 - Ongoing; 2 - Completed, ..... I need to insert an entity case, that it has a FK to that statuses. For instance, idCase = 1, idStatus = 1. So my question is, what is the best approach to map the value (Ongoing, Completed, ...)  into my case CDT? My initial approach is to have a CONSTANT with the status values: "Ongoing", "Completed" and get the id by a query rule to the table status. Thanks in advance.

Hi all, I have to deal with metadata on my processes. Most of them upper 20 parameters. My engine rule Will need to Fetch the specific parameter and its value coming from interfaces, data bases or integrations. So I wonder what It is best way to deal with them for performance: 1) create a CDT with upper 20 fields (and It could be defined more than 50 fields) 2) create a CDT with 2 fields: key and value and work as a list. 3) Define a Map as any type objects. Thank you.

Hi, everyone. I'm learning from "Online Course - Advanced Expressions: Part 2".I have a question about "Exercise: Looping Functions (Online Course | Learning at Appian)". Exercise: Looping Functions(Online Course | Learning at Appian) The answer of "Scenario 4" is 1333 (1332 + initial value 1), but adding all the values of "local!sensor" gives 1361.The last value of 29 in the third map seems to be ignored. a!localVariables( local!sensor: { a!map(data: {125,92,22,63,73,28,19}), a!map(data: {35,65,92,22,63,73,28}), a!map(data: {2,35,65,22,63,73,18,29}), a!map(data: {9,35,65,63,35,28,19}) }, .... .... reduce(fn!sum, 1, local!sensor.data) ) Is the answer 1333 correct?Is this behavior by design? Regards!

Hi Appian Community, I want to implement a simple Try... Catch within my Web API sail expression to test the request body being a valid JSON message. I still notice that the Try() function is not publicized in the documentation but it has been an easier implementation. And in posts that mention Try() function it heavily cautions that it is not recommended and could become unavailable. I looked into using some regular expressions off Google that match for JSON as an alternative but found they aren't compliant with the regex plugin. Example Regex /(?{((?\"([^\0-\x1F\"\\]|\\[\"\\\/bfnrt]|\\u[0-9a-fA-F]{4})*\"):(?\g|(?-?(0|[1-9]\d*)(.\d+)?([eE][+-]?\d+)?)|\g|\g|true|false|null))?\s*((?,\s*)\g(?:\s*)\g)*})|(?\[\g?(\g\g)*\])/ What are some recommended HTTP Request Body validation expressions that can validate whether the message is JSON or XML? It would be great if WebAPI object can handle the content-type validation automatically for us. Below code is using try() function to test f

How important is using a deployment account?

What is the best practice for naming a datasource in Appian? In DEV, UAT, PROD can what should be the name of datasource be provided?