Governance

a!sideBySideItem( item: a!pickerFieldCustom( labelPosition: "COLLAPSED", placeholder: "Department", suggestFunction: rule!INO_departmentSearchSuggestFunction( nameList: if( rule!INO_isBlank(ri!selectedDepartmentList), ri!departmentList.departmentDescription, index( remove( ri!departmentList, wherecontains( ri!selectedDepartmentList, ri!departmentList ) ), "departmentDescription", null ) ), departmentList: if( rule!INO_isBlank(ri!selectedDepartmentList), ri!departmentList, remove( ri!departmentList, wherecontains( ri!selectedDepartmentList, ri

We have 3 cloud based environments: DEV, QC & Production. When the Appian platform is being upgraded on the cloud, we can schedule the date/time it happens for each environment. General good practice is that you should upgrade your non-production environments first. After a period of regression testing on those environments, you upgrade your production environment. Now, if we upgrade our non-development environments first for a period of a week to give the developers and software testers time to do their regression testing, we cannot deploy any new features or bug fixes to production during this time as the Appian versions on DEV/QC are different to Production. This is a major problem if during that week of testing a critical bug is found in production that needs to be fixed and deployed to production ASAP. How do you all handle this?

Hi all,  i have this problem with the calendar: today is shown as saturday, but it's friday.  I don't understand how to change this setting, and i don't think it's depending by the timezone. Anyway, there isn't the UTC+2 for italy timezone.  Anyone have some idea?  Thanks in advance

In case of record sync failure, I want specific people to be informed instead of all system admins.

Hi, we need to configure VPN Tunnel for a new Cloud Environment. Client ask us if IKE use Aggresive Mode. We check, but we didn't find any information in documentation about it Could you help us? Thanks

Hello, I'm working with a dynamik k¡link element who adds a row to a table and I was wondering why this text shows and if it possible to get rid of it: "A new grid row will be added to the grid behind you" Thanks!

Hello everyone, We are currently facing challenges when it comes to identifying users who are part of Constants of Type "User" or "User or Group". This poses a problem when we need to deactivate someone's account and remove or replace them from all associated groups and constants. We have successfully obtained the list of group names that a user (e.g., the logged-in user) belongs to using the following code snippet: a!richTextDisplayField( value: { a!richTextBulletedList( items: { a!forEach( items: getgroupsformemberuser(loggedInUser()), expression: group(fv!item, "groupName") ) } ) } ) However, we still encounter difficulties in identifying users who are part of Constants of Type "User" or "User or Group". We are considering the use of constant descriptions to improve the search process for these constants. If you have any

Hi All, I moved an object from Application A to Application B. When I deploy the object from Application B to higher environment it adds the object successfully to Application B. But I notice that the object is not removed from Application A in the higher environment. What do I need to do for the object removal? Do I deploy the whole Application A? Does anybody have an insight on this? Appreciate your help on this! Regards, Sakshee

Hi, I have a google drive connected system, I use it in an integration to create folders in google drive. It works fine, but after a few minutes of inactivity or sign out my account, the authorization is canceled or expires and I have to re-authorize in my concept connected system for my integration to work again. How can I always leave it active, without the need to authorize it every moment?

Hi All, I wanted to understand how document is stored in Appian . Does Appian store it internally as a stream ? or there is some other sort of mechanism for same ? Please let me know if you have any sort of Appian forum links or you have some sort of understanding for this . This is just for my knowledge . Regards, Sparsh Shangloo

Hello Appian Community, My team and I are in the process of installing Appian version 22.4 on Windows 2016 Standard with IIS 10 and MS SQL Server 2016 Enterprise Edition. After following the steps from the guide and attempting to start the app and all its components (Service Manager, Data Server, Search Server, app) we get an error in the logs that ends with this entry 2023-08-11 13:39:10,957 [localhost-startStop-1] FATAL com.appiancorp.common.web.StartupHaltingServletContextListener - Appian initialization FAILED: see above stacktrace for details and starts with this entry 2023-08-11 13:39:10,935 [localhost-startStop-1] ERROR org.springframework.web.context.ContextLoader - Context initialization failed Here is an excert of the rest of the message: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.filterChains': Cannot resolve reference to bean 'org.springframework.security.web.DefaultSecurityFilterCha

We recently had the following scenario on our cloud based Appian environment. 1. We do all our application building / designing / development on our development environment.2. We promote our applications to our QC environment and finally Production.3. Our development environment recently had issues where the Appian support team had to restore it to a point from the previous day.4. Once our development environment had been restored to the previous days recovery point, we had effectively lost all our application development from the recovery point to the time the server became unstable. Question: What is your process to avoid or mitigate this loss of work/code if your dev environment crashes ? I come from a non-Appian environment where we develop our source code and then commit it to a source code repository.From there it automatically checks the source code for quality, builds the application, and deploys it to our development environment.If our development environment crashes

if( not(ri!executeWhen), { data: a!dataSubset( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, sort: ri!pagingInfo.sort, totalCount: 0, data: {}, identifiers: {} ) }, a!localVariables( local!employeeList: cast( typeof( { 'type!{urn:com:appian:types:INO}INO_employee'() } ), ri!employeeDataSubset.data ), local!staffList: index( local!employeeList, where( a!forEach( items: local!employeeList, expression: and( tointeger(fv!item.designationId) = cons!INO_DESIG_ID_STAFF, ) ) ), {} ), local!employeeIdList: index(local!staffList, "internalEmpId", {}), local!operationsCodeIdList: index(local!staffList, "operationsCodeId", {}), local!dateList: if( isnull(ri!selectedDateList), {}, todatasubset( a!forEach( items: ri!selectedDateList,

How I can improve the performance if there is long java work queue in engine performance log. Which one I have to do whether I have to increase application server or increase Ram. Which one is correct?

In my current project I need to make a element button integrated in a interactive grid visible for screen readers and if it this posible get this code in HTML: " aria-label=”Delete” And, if this action is not posible, what recomends to use in te grid to eliminate an element? Thank you

Hi! I'm trying to achieve this HTML structure in appian text field: <label class="" for="un">Name</label> The main request to get it: The screen readers must be able to read the text into the text (placeholder aren't visible in their opinion) Many thanks!

I'm working on a module called Query your Data. It's asking for hands on practice. Generate a Record Type Selection Query. It asks me the following: But the Query Your Data App is not available on the Appian Designer page. What can I do about this or did I miss buliding that somewhere along the way?  Numbered divider  Generate a Record Type Selection Query For this exercise, imagine you are an Acme Auto developer. You need to create a query that returns a list of vehicles. That list must include all Vehicle record fields and the cost field from the Maintenance record type. The query should only show the data property. In your Appian Community Edition environment, navigate to your Query Your Data application. Since you're creating a selection query, you will use the query editor to generate this query. Complete the following tasks and check them off when complete. Review the Check Your Work section when done or if you get stuck.

I am attempting to connect to my RDS Postgresql database and cannot get that connection working through Connected Systems. There is mention of opening a support case and having a driver created but whenever I use the Open Case button I get a 401 error. I haven't seen this mentioned, but is that not an option for the community edition? If that is the case, is my only real recourse to import the data to the appian database?

Hi! I made a request one day ago in order to recover my appian site. When I enter in appian community, I see the following information; When I click the "Check status" button, nothing happens. I received a no reply email which said that there would be a delay in my request, but I would like to ask how much time will pass until I can recover my site (or what is the "standard" amount of time), and how can I follow the status of my request. Thanks a lot!

Hi All,  What is the best practice/Appian recommended naming convention for database tables and fields? Previously the database table created by Appian were all lowercase, now in latest version, all (tables and fields) in upper cases. Is there any reason they changed it to upper case? For most databases, recommended naming convention in stored procedure is to keep the key words as upper case and fields in camel case/pascal case and table name in pascal case Please let's know your thoughts/recommendations. SG

When we create a new Record Type, Appian automatically generates a SQL script that can be run (either automatically or manually) to create the database table. It always uses UPPERCASE for both the table and field names. My question: is there a default setting somewhere that can be overridden so Appian instead uses lowercase names for tables and fields when generating the SQL script for us?

I have a data type for a SQL view TOS_CMS_VW_ClergyTitleStatusTypeDSE.  It contains fields describing various clergy members.  I want Clergy Id and Clergy Full Name in a lookup on an interface.  ClergyID is an integer and ClergyFullName is a text field. I created a constant for the data type and I am not trying to create a expression to pull the two fields I want for the dropdown, ClergyID and ClergyFullName. a!queryEntity(  entity: cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE,  query: a!query(    selection: {      a!querySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyId)),      a!qyerySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyfullname))    },    pagingInfo: a!pagingInfo(      startIndex: 1,      batchSize: 500,      sort: a!sortInfo(        field: cons!TOS_CMS_VW_Cle

We initially developed our Application on cloud and now we setup the complete database at on-premise and I was not able to connect from cloud Environment. Need help ?

Appian 23.2 We have MariaDB as a default Database. We have our SQL Server Database hosted in AWS. Can someone please provide me with the steps to create a new Data Source? Can I directly go to Admin Console -> Data Sources ->New Data Source -> Add SQL Server Details? or any additional steps that we have to perform? Thanks

Hi All  I have successfully configured a single sign-in solution that is working perfectly for our clients. I am also configured Attribute Mapping like Create New Users Upon Sign-In and Update User Attributes Upon Sign-In it works fine, but when it comes to Group Membership Synchronization I add one group(AD Test) in Azure Ad in which one user will be added and the same group added(AD Test) in appian under the group type (A Brand) when i try to access the appian With that user credential, I am successfully get the acess the appian  but no user will be added to the appian group(AD Test). Could you help with what I did wrong here?