General

Is there a limit for the number of objects in an appian application ? will there be performance decrement if the number of object is increased from 100 to 500 ?

Hi Team, I want to calculate time in hours between two date time like on  18th 8am to 18th 10am :- 2 hours 18th 12pm to 18th 8pm :- 8 hours  total :- 10 hours Can anyone please help calworkhours is not working properly.

Hello,  how can I access to my expression editor? I already got my appian community, but couldn't access to the expression editor 

I have the below sample json variable. i want to get the number of values under tags.  local!Json:{ tags:{ "description": " ", "displayName": "" }, { "description": "", "displayName": "" }, { "description": "", "displayName": "" }, }, To achieve this, i have tried using  count(local!Json.tags.displayName). it is throwing the below error. "Cannot index property 'displayName' of type String into type List of Variant". How to resolve this?

Hi everyone, Hope everyone is doing well and safe. Can any one help me with Leveraging activity-chaining with example.? How can we pass data from one process to other process by using start process smart service? Thank you all in advance! Regards, Kiran Sajjan

I'm trying to insert one  image to my word document i have seen a lot of post about this topic but any of them work for me most of them tell how to add an array  of images  but i  just have  one image that i want to be shown in my word y  updated the field in the word document i also edited the fields i have the image as a bookmark i sent the  image as dinamic cdt  with and without the index added i made sure this constant has a value also this constant is referring to a image  i tried to pass in xmlformat  converting my pv variable and converting it into a document to make sure and nothing i also tried to  add the image as xml . i also tried everything  with this template an nothing

Hi all, As per my understanding these objects Query Rule and Expression rule are same, then Why it's given in filter panel for Query Rule? Is it any other way to create QR? We can filter by Expression Rule on filter panel. It doesn't show any objects if I filter with Query Rule. What is the purpose of this filter Query Rule? Please clarify on this... thank you in advance!

I'm trying to use the file upload functionality in Appian Interface and is there any way I can restrict from uploading the file with the same name which already exists in the db or even if it allows the upload is there a way to over write the existing file with the latest file?

Hi Everyone, I am getting a variable of type Map from Appian RPA Integration in Execute Robotic Process smart service, the values are coming like below as a single Map variable: { varABCIndex=26, varSiteNameIndex=16, varCurrentMonthTotal=64, varProjectIdIndex=24, varExcelModifySourceFilePath=, varOutputDocId=164646} Suppose I want to fetch value of varOutputDocId from this map variable, so how I can fetch this value. Please suggest.

Updated to "Arial" font and size "small", but when inspect the content in mail it is showing me Arial, Helvetica, sans-serif. If Arial then it should be only Arial, why all these right?

HI am getting like this error  what might be the reason?

Hi   Is there any option in appian to  sync user role information from UI to DB and viceversa. Thanks in Advance

I would like to know if there is any limitations in terms of number of rows or the memory limit to export the data to excel by using export DSE to excel smart service. As I am aware there is a limitation of 50 in terms of columns. I am curious to know if there is such limitations in terms of rows or the data limit.

i have 3 columnslayout i will show 2nd columnlayout when i click a link on first columnlayout, using showwhen:not(isnull(local!selectedcards)).---->it is working fine Same way, if i click a link on 2nd columnlayout i want to show 3rd columnlayout(using same showwhen()).------->it is working , but it is not hiding 2nd columnlayout. it is displaying both 2nd and 3rd layout. How to give condition for this in showwhen?

Hii Guys!! where we can find the saved draft forms in process model can anybody help me to share about this please

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