Governance

We have DEV, QC and Production Cloud based Appian environments. When developing on the DEV environment, and creating a new Record Type which then creates a new SQL table on our cloud database schema, it generates a SQL script for you to create the table. There is also a checkbox option to apply that SQL script immediately for you to your source schema.  The same happens if you update the Record Type fields. A SQL script is generated to alter your source table for you. I'm interested to hear how everyone handles their database changes across environments when using Record Types that generate the source tables for you? Do you download and store every single SQL script as you make changes to a Record Type? If so, where do you store them? Do you manually run those scripts on your databases for each environment? Do you deploy them as part of a package which only has the SQL scripts? Or do you deploy them as part of a package which includes both the SQL scripts and your ap

Hello!I'm having a doubt about the use of the function index(), as a best practice in Appian development.In the Appian documentation appears as: index( data, index, default ), but I know that we can use the function as: index( data, index, index, index... (as many as needed), default ), to navigate between an object and it returns the value needed. The question is: Should I use nested index() functions? or Is better to use just one index function with many indexes inside? Example: {CountriesES, CountriesUS, CountriesNL} -> Cities -> Town 1 - Index(CountriesES, "Cities", "Town", null) 2 - Index(lIndex(CountriesES, "Cities", null), "Town", null).

Hi I am Learning Appian development, i have doubt how to combine two text local variables please hep me on this a!localVariables ( localVar1: Text := "Hello,", localVar2: Text := " World!" ) local!combinedText := local!localVar1 & local!localVar2

Hi All,          In our SaaS Environment, the basic user we create is not able to access the tempo interface. Only if we change him to Admin user he is able to access the environment. Has anyone faced a similar issue?

how tow write the if condition to check the two local variables are equal or not ?

Hi We are using SAML Group Synchronisation to sync Azure AD groups to our Appian groups. All works correctly. However, due to a temporary situation, we will have two Azure AD groups which should be mapped to the same group in Appian. See below, where we have the attribute 'memberOfValue' and a group name, we would need that attribute repeating. e.g. Attribute - Value memberOfValue - Group1 memberOfValue - Group2 I am thinking this is not possible and that probably we have to set up a second saml sync group with the correct attribute, then add this group as a member of the Appian group. Anyone had this scenario? Thanks.  

Hi, Currently, we are considering the possibility of configuring SAML as the authentication protocol for internal citizens, while using OAuth as the authentication protocol for regular citizens. We would like to be able to choose the authentication method based on the application being used. My specific questions are as follows: Is it possible to configure both SAML and OAuth simultaneously in Appian for different user groups? How can the appropriate authentication protocol be determined and selected based on the application being used? What are the best practices or recommendations for achieving this dual authentication configuration efficiently and securely? Thanks!

Hi All, Has anybody integrated with GraphQL End point which retuns a JSON formatted response. i

Hi All, Can anyone please help, on how we can disable the login.jsp page, so that, when users tries to access it, there will be an error throwed. Warm Regards Vineeth

Has anyone seen this message before? Filters are working in lower environments but not in prod. This message is displayed for all record types regardless of number of data.

Hi All, Second error: Appian environment went down and became very slow. From Appian admin we received the tomcat.std logs: 2022-11-22 03:00:07,489 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.core.expr.portable.storage.StorageDoubleTimestamp - Incorrect type (java.sql.Date) for DateTime variable (2022-06-08). Expected Type: java.sql.Timestamp. Auto-correcting to "2022-06-08 00:00:00.0" 2022-11-22 03:00:07,489 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.core.expr.portable.storage.StorageDoubleTimestamp - Incorrect type (java.sql.Date) for DateTime variable (2022-06-15). Expected Type: java.sql.Timestamp. Auto-correcting to "2022-06-15 00:00:00.0" 2022-11-22 03:00:11,412 [RecordSyncScheduler_Worker-1] INFO com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: 2] completed for job [group: record_load_group, name: 2] 2022-11-22 04:00:00,708 [RecordSyncScheduler_Worker-2] INFO com.appiancorp.record.service.quartz.LoggingTrig

Hello,  Does anyone know if it is possible to make a related action visible or not depending on the user?.Because I want only the user who performed the action to be able to edit it again, this is my table Thank you very much

Hi, please archive? thank you!

Does Appian SAML SSO work with http (not https) IDP requests. Is it mandatory to have all the systems running under https rather than http to be compatible with saml SSO? What is the rule?

Hi,  For the creation of Users in Appian, what the different validations for it. Please help me with it. E.g max char for the firstName and lastName Thanks

Hi, We are currently runnning on Appian 23.1 with Linux OnPrem servers. We are using Apache Webservers. Can we replace Apache web server with Citrix NetScaler Load Balancer. Is any one using this setup. We have two sets of environments (one with high availability for certain applications) and the other is Distributed( for other applications). Kindly advise on the use of load balancer and provide any documentation on the same. Regards, Chetana

Hey everyone, I've been going through the Appian Documentation for the "Send E-Mail Smart Service", and I have a question about adding recipients in the "To:" field. The documentation suggests various methods for adding users or groups, such as typing their names, selecting them from a list, or directly inputting email addresses with semicolon separation (;). One concern I have is the design flaw when manually entering individual users, without using a group. Is there a way to find them later through some interface that allows me to find these users? My goal is to detect whether any of the manually entered individual recipients (e.g., the logged-in user, or any user that we will enter) appear in the "To:" field by searching through ALL the Process Models at once. Additionally, I'm uncertain if there is a way to search through all the Process Models (maybe by using: Process Modeller -> Tools -> Generate Documentation). If you have any insights

Hello I have this setup: - Inner interface that allows to view or edit a record, but it has no buttons - There are outer interfaces that include the inner one, adding to it action buttons or extra fields - The inner interface calculates a field (e.g. cost=number of parts * cost of each part). The result of this calculation is shown to the user in the inner interface, but it also should be stored in a field of the record type. The problem I have is that the inner interface cannot save the calculated cost to the record rule input, because it has no buttons and therefore it can't use a single a!save. The calculated field is shown to the user in a readonly or disabled textField, but its saveInto is innefective when its value changes after the calculation. saveInto works only when the field is enabled and the user types into it. The outer interfaces can update the record type using a!save in its buttons, but they must repeat the call to the calcu

Is there a limit on the number of packages which an environment can contain?

Hi folks, I want to know if Appian has got an anonymous reporting features(whistelblowing) by the user of an application/site, like this one in the link: Compliance & Government Affairs Hotline Solutions - Life Sciences | Appian. I don't find anything unfortunately, not in the documentation neither in the support section. Does anybody has some idea? Thanks in advance

I'm using the connected onboarding solution for a demo and there are a bunch of really old tasks showing up in the My Tasks and Group Tasks view.  I thought if I cancelled the onboarding, it would clear out related tasks, but it didn't.  Now i'm stuck with a bunch of orphan tasks in the user interface which makes for a pretty messy demo.  How can I safely get rid of old tasks from the UI?

In the Appian Designer, we can see the NEW tab which shows all the design objects like process model, record type, Data type, interface, etc.  Can we customize that view i.e. can we restrict the limited objects to a specific group of users? Please let me know that will be most helpful.

Hi, I am trying to upgrade from 22.1 to 23.2 in my local machine. while starting the services, all engines are running in Primary mode except exec02 engine.I am getting below error in db_PX021_2023-09-07_1335.log 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Default) INFO .u "Hashing count of 10432 UUIDs into short hash for table U" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 0% Migrating from version: migrate_null_process_history_221" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 10% Updating version tag to: reset_analytics_timer_type_221" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 20% Updating version tag to: reset_analytics_timer_type_222" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 30% Updating version tag to: reset_analytics_timer_type_223" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 40% Done: migrate_process_model_history