General

Hi Appian Community, Currently, our process automatically deactivates users (change status to inactive) that did not login to Appian for more than 30 days. The issue, however, is that the users that were deactivated manually have the same inactive status as the automatically deactivated ones. I would like to source ideas on how I can get this list of dormant users. Advance thank you for the people who will respond to this.

On the FAQ --  What is the cost of the certification exams? Each exam attempt costs $200 (US). Appian Partners receive a 50% discount. We do not currently offer regional discounts. (Note: There is no longer first free attempts for partner practitioners but recertification will be free) As an employee working for Appian partner. Could you suggest how the 50% discount can be availed. I see no option during payment at the time of scheduling exam.

I am trying to understand the working behaviour of foreach . i have tried this below code from appian doc. a!forEach( items: {"January", "February", "March"}, expression: a!localVariables( local!month: fv!item, a!forEach( items: {1, 15}, expression: local!month & " " & fv!item ) )) the code throws the below error.Kindly help.

When using the sftp smart service, is there any way to search for a file in a folder, ideally with some kind of wildcard option? I've got a folder with a list of files named something like <FILENAME><SOME_RANDOM_NUMBERS><DATE>.csv and while the filename part stays the same, I don't necessarily know the number or date attached to it ahead of time. Is there some way I can pull the latest file called <filename>*.csv or something? Or do I HAVE to know the exact file name to download it?

i configured all the node inputs of a!docExtractionResult() smart service properly. i used this smart service in process model. i assigned that task to application administrators group. when i run this process model, i got this error message "The document extraction instance [docExtractionId=8,545] does not exist, has been deleted, or you do not have sufficient privileges to access its data. Please submit this task to complete. You will be prompted with an error message upon submission." But, the document is there with the specified id(8545) and also i am having the required previleges as iam  in application adminstrators group. Please provide me some info regarding this. Thanks in Advance.

Hi, We're using on-premise Appian with MSSQL(Sql Server) Db that includes both Appian Primary DB and Business DB. We're on the steps to move to Appian Cloud. Could anyone tried and share your suggestions how to migrate Appian Primary DB to Appian Cloud pls? We understand Appian Cloud uses Maria DB, trying to find if there any better approach OR schema backup tool available for this use case pls? Thanks.

Hello all, We have set up new environments and write to data store in to a table having PK and 4 columns it self takes 1.34 second which seems to be too high . Issue we are facing with the other nodes which is inserting more data and time is at higher end which is impacting the perfomance and response time of the process. Is there any possibilty to update some configuration or setting at server side so that write to data store takes lesser time ? Usually write to data store should not take time in seconds to just insert 4 columns . Any pointer will be helpful . We have on-premises env whihc is newly setup . Thanks in advance, Pooja

I have a question while using the a!pickerFieldCustom Component example in Document. a!localVariables( local!pickedState, local!stateLabels: { "Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", "Ohio", "Oklahoma", "Oregon", "Pennsylvania", "Rhode Island", "South Carolina", "South Dakota", "Tennessee", "Texas", "Utah", "Vermont", "Virginia", "Washington", "West Virginia", "Wisconsin", "Wyoming" }, local!stateAbbreviations: { "AL", "AK", "AZ", "AR", "CA", "CO", "CT", "DE", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "NV", "NH", "NJ", "NM", "NY", "NC", "

The time i use for setting meeting using "Send Meeting Request" is 10AM, but the meeting is generated for 3.30PM.(GMT+5.30 hours)(I live in India). Is there any setting to correct this? Like the process model time zone or something else? Currently i am working around this using =(pv!InterviewInviteDetails.startDateTime - time(5, 30, 0, 0)) in the Start parameter of the Send Meeting Request.

Hi All,  Hope you're doing well.  I'm trying to setup automated CI/CD on Azure.  VCS = GIT sits on Azure Below are the steps we're trying to achieve: Comit/Push the exported zip from local to GIT repo(using IntelliJ IDE) once the objects are committed into the repo, Trigger pipeline to add/merge the updated objects into existing application objects Build the Application - Generate the package .zip Import into the target environment Issue:  When executing the addContents action getting the below error message, please help me to understand the error if I missed anything. Error Message: 2022-07-07 00:25:03,353 - Missing git repository. Cloning automatically. 2022-07-07 00:25:03,353 - Cloning from <Repo URL> to <local_repor_path> 2022-07-07 00:25:04,954 - Local repo updated successfully 2022-07-07 00:25:05,162 - close() called when useCnt is already zero 2022-07-07 00:25:05,163 - There was an error completing the select

 I am getting this error whenever i m trying to generate the document { "error" : "APNX -1000-000" , "message" : "Invalid Content ID", "title" : "AN error has occured. Any suggestions?

Hi Everyone, if(     rimod1 = 2, {cons!member1,cons!member2),{} ) In the above code I try to get the value from 2 constant which contain group member, but I am getting value from member1 not from member2. can anyone help me on this.

"

I am not sure if I'm just doing/understanding something wrong or if this is a bug or what. When configuring a site, there's an option that says, "Show Tempo Link in Navigation Menu". I could have sworn that if I select never on that, that I wouldn't ever see the site listing when I click on that 9 square icon listing all the tempo sites. However, I am able to see the site listed. What am I doing wrong here? 

Hi, We have a grid layout, user needs to enter the necessary the data in the field by clicking on +Add row, every row has a dedicated Save and Discard button. the UI have Back (LINK) to go previous page. when a user click on + Add row in the table and enters data and don't click on save. click on back (LINK), and comes to the same screen again, ACTUAL RESULT: row value entered is displayed even row is not saved. EXPECTED RESULT: Row value entered should not be displayed. After clicking on Back (LINK) in UI and coming to the grid screen.  

Hi all, We've got a requirement to provide some documentation/information on two things: 1. Resiliency for our Appian instances 2. The Capacity and Performance of our Appian instances Our environments are cloud-hosted, does anyone know where would be the best place to find any info on this, either generic or specific to our instances? Can I find this myself or would I need to get in contact with someone from Appian? I've tried having a look but I haven't come across anything yet.  Thanks

I have a requirement where the files in our directory have the naming convention as: filename_{yyyymmdd}.{hh23miss}.txt abc_20220131.121314.txt The interface can and SFTP smart service combination can read the user input for file and date combination, but how can I retrieve a file which has timestamp associated? Newbie to Appian, please assist.

Hi All, Is it possible to make a variable static in appian just like java. So that it retains its value.

Hi Experts, Can someone explain me in-depth concept of a group type. What are the specific use cases where we have to go with creating Specific group type. Till now I have used only custom group types and groups at technical and business level. Thanks in Advance, Gaurav Singh

Is there anyone else that is completely new to the coding world without prior coding knowledge. I am considering doing a Full Stack boot camp to help me. I am not sure if that is the right path.   How long did it take you to grasp Appian and past the associate developer certificate? Have you been able to secure employment with completing the certificate through this site? 

As we all know , we don't have security for CDT unlike other appian objects. But I have a use case where I have to restrict the access to CDT , I just need viewer access and should  not be able to download or create new versions. Use case :  we created a separate group called Application Support admin . This group is basically to have a viewer access to application and to all process model This group is to monitor process instances in prod to debug any issue . To achieve this , we went with the below approach 1)Basic user with designer access 2)Create application specific group and provided viewer access to Application 3)We set the process model security to this group as viewer access with  this user belong to this group able to process models with only viewer access (cant start or stop process or create any new process model) and able to see all process instances (with viewer access - cant edit process also) But we see a risk here that, with this role - user is able

I have configured the Custom Sender while sending the Email. Everything is working fine. I am able to receive the Mail also but The sender Display name is getting Repeated.. Can someone help. Thanks

I am using an XML to render a report. Each row should display a single amount per case; for example: row 1 .--->  validation number   caseid   payee name  check amount     check no row 2 .--->        13331                   1234       john_name             120                   blank row 3 .--->        13332                   1234       john_name             240               &n

I have added two new columns to the CDT, When I am deploying these changes to production.are these two new fields mapped to the existing instances or not ?   Pls explain with one simple example.  Thanks in Advance!

Hi All,  As the application name and its prefix has been changed after the half way across the development, we are now in need to change the existing appian objects to the new prefix. While doing so, I'm trying to change the CDT, Data Store etc.. ( AFAIK  while is the most tedious task) but getting the below error : is there any best practices for changing the prefix for CDT , DB tables , Data store , records etc ? Can someone please elucidate ?  Error snap shot :  XSD File EM_table2XSD – < 1 KB The name and namespace of the new version of the data type must be the same as the current data type's name and namespace. Received namespace: urn:com:appian:types:EM, name: EM_table2