Governance

I have a local variable local!allProcesses: rule!myGetAllProcesses().data which contains data from a database. The columns are processId, processName, processYear and processQuarter. I now want to have choiceLabels of a drop-down menu which combines processName, processYear and processQuarter. The corresponding choiceValues will be the processIds. Obviously, the following code works only as long as I have only a single row in the database:    choiceLabels: { concat( { local!AllProcesses.processName }, " for ", { local!AllProcesses.processYear }, " Q", { local!AllProcesses.processQuarter } ) }, choiceValues: {local!allProcesses.processId}, Otherwise, for more than one row in the database, the error code will read Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at fun

I want to build weather application, in that I am using third party api for different city so that it will work dynamically. But I didn't get how to work with dynamic value with help of API and Integration. API:api.openweathermap.org/.../city Waiting for answer. Thanks

What is the Best Practice for importing an existing application and view its objects in Designer ?  Step 1) Download the application in zip file and drop it in Appian Designer after clicking on "Import"Step 2) Checkbox appears that says "....import customisation file......"I see that there is a checkbox for import customisation file, when do I check this ? Kindly share the steps for application import for existing zip file, assuming it is downloaded from Appian AppMarket

Anyone knows of Appian functions / components / icons like the fileuploadfield where I can trigger print to pdf function ? 

I am new at Appian and eager to learn, so please help me if you can as I have already searched and found nothing. I can't find Appian Admin Console as shown in screenshot, how can I get it?

How to avoid sending the email of a new user? In our installation we don't need to send the email with the password because we have implemented the single sign-on to connect to Appian.

Hi, about Appian authentication, is it possibile using SAML-based SSO using SAML 2.0 specifications and SHA-2 (SHA-512) signature method algorithms? Or exist a plugin on the Appian Market with this functionality? Thanks! Gabriele

For process start forms, I use an OR gateway that goes to an end node if the pv!cancel variable is true. I don't want to implement the same flow for user input tasks as it would kill the process without a way to retrigger. The approaches I'm considering are: Looping back to the user input task if a user clicks cancel to trigger a new task Omit the cancel button from the form so that user would just have to reject They both effectively force completion or reassignment of the task. In both cases, process or data manipulation would be needed to address a task that's lingering or deemed unnecessary. I just want to gauge which of the 2 options do people find themselves doing.

I have noticed that with the Maria DB upgrade from MySQL in cloud, it will change the datatype of calculated view fields that come out to be varchar to text.  Anyone else have this issue? It causes issues as the CDT does not match due to the type change and the data store will not publish.  What steps did you take to rectify it? Thanks,

Hello, In appian we are using SAML authentication for first login but after new user creation they can't login and even after resting the password. Error : The username/password entered is invalid. usernames and passwords are case sensitive

What is best way to manage dropdown data from database? 1) create a table for each dropdown or 2) 1 table for all dropdowns. Also please consider relations between tables, for example Country, States and Cities. And with consideration of scalability, like more dropdowns or more dropdown labels.

Hi, We are aiming to have a DEV environment with HA topology to be able to develop some integrations to be then promoted to PROD via CI/CD. These developments won't be as frequent as the developments in Appian so, the need of the HA is residual. Is it possible to scale down the Appian environment easily? Having a single node up most of the time and only have the 3 from time to time? Is it just a matter of shutting down 2 nodes and change the topology.xml file?  

Need help/possible options,  Client wants to migrate PRODUCTION Appian primary APPIAN_SCHEMA  and  BUSINESS_SCHEMA from Sybase to Microsoft SQL. Is there any possible solutions to migrate or refresh the inflight Appian PRODUCTION instance intact after Db migration.

Is it in the roadmap to perhaps allow the Insights site for On Prem?  Either allow on prem to stream logs to appian (unlikely since there are likely security reasons to not be in appian cloud in the first place), or allow the Insights site to be an imported app and have it pull logs from the server or stream to the app the logs that are needed. Or even have Insights as a default site/app on all installs and it pulls the data needed [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi, My question is maybe a little naive but for increasing performance I was asking myself if use the showWhen attribute on 10 components is as good using an IF condition to masking all these components. I took 3 examples : 1/ Case showWhen on all components : ColumnsLayout(    columnLayout        TextField_1label: "1", showWhen: false)    columnLayout(        TextField_2(label: "2", showWhen: false)     ...     columnLayout(         TextField_10(label: "10", showWhen: false)) 2/ Case showWhen on layout component : ColumnsLayout(    columnLayout        TextField_1(label: "1")     columnLayout(        TextField_2(label: "2")    ...     columnLayout(        TextField_10(label: "10")    ),&nbs

Hi together,not sure if its a question or a discussion.i just discovered that isnull() for a nested CDT is not working properly I have a CDT Processdata {"id"(integer), "startedAt"(datetime), "attachment"(CDT attachment),...} which contains the nested CDT "attachment"   {"id"(integer), "document"(document)....} -> If I try to do isnull(ri!processData.attachment.document) it is not working and i always get false as result, even the value is NULL (100%)-> if I try      ri!processData.attachment.document= todocument(Null)   its fine. ->  isnull(ri!process.documenttest) is working, so it seems to be just an issue regarding nested document CDT as far is can clarify. a) is that a bug by appian? b) what would be your approach to solve it? What is your best practice here? Thank you all :)

We created a QR code to our workplace safety app hoping visitors and vendors could access the app that way but it doesn't take them to our configured app.  It takes them to a sign on screen that requires user name and password.   Anyone have any experience using QR codes to get right to their company's app?

Hi there, We have a self-managed environment, and we have Oracle as our primary database. Currently, we are trying to configure MySql as a secondary database and we follow the steps on this link: https://docs.appian.com/suite/help/20.4/Configuring_Relational_Databases.html#provide-data-source-connection-information. Performed steps: 1. install mysql-connector-java-8.0.23-1.el7.noarch.rpm in the <REPO_HOME>/tomcat/apache-tomcat/lib/. for this we moved the rpm file and runed the rpm -ivh command  to install. 2. we updated the <REPO_HOME>/conf/tomcatResources.xml.<ENVIRONMENT> file just adding the configuration for MySql  <Resource name="jdbc/AppianPrimary" factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@oracle_server.example.com:1521:ORACLE_FOR_APPIAN" usern

Hi, We are using SAML to asign users to groups upon login, using 2 different types of rules:  - Group based - matching SAML groups to Appian Groups (for example - Director)  - Rule based - matching user data (taken from SAML properties) to Appian Groups (for example - Office) We need to be able to create sub-groups using info from Groups + User data (to create a group for - Office Director). We need these groups to be able to assign tasks. We've tried multiple things but haven't ben able to find a solution to execute this online, and therefore have gone to a batch solution. Is there a way to:  - create a group from an interesection of 2 groups?  - create a group using group + user attribute data? Thanks

Hi All, Can some one confirm whether I can run/setup/install an Appian on my personal system  othan accessing 14 days trial. I know the location to download the Appian installer 20.0.0.4. Thanks in advance, Abdul.

Hi folks! [emoticon:33306c418930400bac28808410f8ac8b] I recently had to analyse a few projects in terms of their complexity. I had a look for any existing tools in the community to help, but I didn't find anything. So I thought I'd write a script to help. Whilst the results of this tool are no substitute for per-object inspection by eye, it can help in determining where to look first. I've created a public project up on GitHub in case this can help anyone in a similar position to mine. https://github.com/JFDI-Consulting/JFDIAppianSAILComplexityAnalyser Hope it helps someone! Joel

Hello there, I have a question about the "Administrator" user. As far as I know it is a super user that is not logged in the Appian logs and for this reason the user does not have access to the admin console. But, can the user access everything else? It is not listed in the Users section. How can I know what is the password of this user?  Also another question, comes the Adminsitrator user with every Appian installation out of the box? Many thanks!

Sample image is added. I need to change Group Type. 

Hi All, I could would like to your opinion on the two different approach which we drafted. Need to understand the pros and cons  Approach1:   We are creating one webapi and based on the path parameter it will be routed to respective Handler(expression rule)and the handler will respond back  Question: 1. Creating One web-API /per http method ,will it create high load to Web-api which will in turn make 503 exception(timeout) on prod? Approach 2: Creating a Web-API /per Package and which in turn as respective handler (expression rule ) for the response Question: 1)desired approach to solve the needful? 2)Pros and cons on Approach 1 over the Approach 2? Thanks in advance!

Is there a URL (e.g. /healthcheck) that would provide insight into the health of the overall Appian system? Ideally, it would provide a 200 status code when everything is good and a 500 with details when components are unhealthy. Thank you!