General

Hi everyone! I work as a QA Engineer on an Appian project and we are using Cucumber for Appian and ran into an issue with the built-in 'Sort by Grid' step, we have built a fairly basic smoke test script to tab through the applications pages and also to try and sort through some columns in a grid that would pop up.  ## View Contract File Tab Then I sort grid "[1]" by column "Contents" #Then I sort grid "[1]" by column "[1]" We've attempted both ways to no success.  On the UI, we have the 'Contents' column unsorted here: and after clicking the content SHOULD sort like this: When we run the script. It does not seem to be able to sort the column at all. The script will end at the Sort step indicating an exception error with the 'Element not existing':2022-08-18 15:25:18,542 [main] ERROR com.appiancorp.ps.automatedtest.exception.ExceptionBuilder - Sort Grid - Contentsorg.openqa.selenium.NoSuchElementExc

The paragraph field displays characters over 4000 while read only in my interface. But when I click the record and navigate to the summary view on the site it gets cut off at 4000 characters. There is no scrollable bar neither does the browser scroll bar change to fit more text. All text data is being passed in just not displaying properly in summary view, trying to figure how to have the paragraph field display all text.

We have files that are loaded on a shared drive and we use FTPS to load the files into Appian. They are now going to change this so the root folder on the shared drive will have yearly folders: Example folder structure: Appian\Files\Upload\2020 Appian\Files\Upload\2021 Appian\Files\Upload\2022 I am trying to figure out with in a Appian Process model how I can tell it to check to see if with in Appian\Files\Upload    if the year folder I am looking for exists in that directory because it may not yet. I need to basically have it tell me if in     Appian\Files\Upload     does 2020 exist Does anyone have sample code of checking for a folder on a shared drive? Thank you

Hi  a!radioButtonField( labelPosition: "COLLAPSED", choiceLayout: "COMPACT", disabled: ri!isReadOnly_bool, choiceLabels: cons!CR_APP_TXT_CHOICE_LABELS_YES_NO, choiceValues: touniformstring( cons!CR_APP_INT_CHOICE_VALUES ), value: fv!item.overrideFlag_int, saveInto: { fv!item.overrideFlag_int, if( isnull( fv!item.id_int ), {}, { a!save( fv!item.updatedBy_txt, loggedInUser() ), a!save( fv!item.updatedOn_dt, now() ), a!save( fv!item.updatedByRole_txt, rule!CR_FN_getUserRole( inputUser

I am using trying to pass httpResponse.result in one of the expression rule .. in script task  rule!OIT_getTransactionDetails( httpResponse:ri!httpResponse.result, activeStatus:ri!status ) But it returns Error like Invalid index: Cannot index property 'result' of type Text into type HttpResponse. I know its casting issue , tried with index function also but it returns null then .. not the  values which  i want to retrieve

I have a data with following format- [entity: somevalue , data:[id:1,name:a],[id=2,name:b] Now i need to pass data part in loop. As it has 2 occurrences for data so loop should run two times. And for each occurrence it should pas only relevant data. 1st occurrence-  [entity: somevalue , data:[id:1,name:a] 2nd occurrence-  [entity: somevalue , data:[id=2,name:b] As data is type of array so not able to do indexing here. Any suggestion.

Hi, 1. Whenever we import/export or publishing application, is it possible to change the name of the package created.? 2. does this maintain the same artificate, if the package name changes?

Hello, is it possible to create a GET API returning downloadable link?  PDF or jpeg format.

Hi, every one Does Appian have any experience migrating Java applet-based systems to Appian's server-based systems? If Appian does not have any experience, please let us know about it. Thank you .

Hi everyone,  We have a need to clean up documents in our lower environment as it is consuming a lot of disk space. We identified two folders whose contents aren't needed currently. However, I would like to back them up just in case it's needed in the future. However, when I download the folder as a zip and subsequently unzip it, the folder hierarchy is different than how it is on Appian. It might not be a big deal for us but I did want to ask the community if they know of a way to preserve it? Following is the difference in hierarchy Hierarchy in Appian FY 2020 Report 1 12. September 9/30/2020 Report 1 9/29/2020 Report 1 9/28/2020 Report 1 Report generated per day 11. August 10. July 09. June 08. May 07. April 06. March 05. February 04. January 03. December 02. November 01. October Report 2 12. September 9/30/2020 Report 2 9/29/2020 Report 2 9/28/2020 Report 2 11. August 10. July 09. June 08. May 07. April 06. March 05. February 04. January 03. December 02. N

Any plans to expand a!submitUploadedFiles() beyond portals? I have use cases where this could be useful in a standard application.

Hello, Do you know how Appian dates are formatted?   I created a transaction at 5:01PM CDT and it appears on the database as 2022-08-12 22:01:18.070 Thanks

Hello, I have a requirement to export a grid data to excel. The data like, I have 5 Regions and each reason have 3 Groups and each groups have 9 stages and each stage have data of 6 columns. so I have  to export below table. Can any one suggest which smart service can I used for this. Group-1 Group-2 Group-3 Region-1 DD/MM Daily Weekly Target Differ DD/MM - 1 DD/MM Daily Weekly Target Differ DD/MM - 1 DD/MM Daily Weekly Target Differ DD/MM - 1 Stage-1 11 1 4 15 11 10 11 1 4 15 11 10 11 1 4 15 11 10 Stage-2 8 0 4 15 11 8 8 0 4 15 11 8 8 0 4 15 11 8 Stage-3 8 0 5 15 10 8 8 0 5 15 10 8 8 0 5 15 10 8 Stage-4 10 3 5 15 10 7 10 3 5 15 10 7 10 3 5 15 10 7 Stage-5 6 0 4 15 11 6 6 0 4 15 11 6 6 0 4 15 11 6 Stage-6 5 0 2 15 13 5 5 0 2 15 13 5 5 0 2 15 13 5 Stage-7 4 0 2 15 13 4 4 0 2 15 13 4 4 0 2 15 13 4 Stage-8 3 0 1 15 14 3 3 0 1 15 14 3 3 0 1 15 14 3 Stage-9 4 2 1 15 14 2 4 2 1 15 14 2 4 2 1 15 14 2 Group-1 Group-2

Hi All, I have a requirement that have to show "ID" along with status ("Active"/ "In-Active") in record title, and only the status color should be changed as per status value. When the status set as "Active", the record title for status shows in green color and for "In-Active" its in Red Eg:- "10024 | Active" or "10024 | In-Active" Can any one help me on this how can I change half of the record title color ?

I am trying to apply sorting on the primary key, while getting data is batches its breaking when the data returned from the query entity rule is null. If sorting based on any other fields its working fine, with or without data Code used:  a!pagingInfo( startIndex: 1, batchSize: 5, sort: a!sortInfo( field: "agendaItemIdPk", ascending: true() )) If we get the data we batch size -1 its working fine. Has anyone faced this issue if yes then whats the way around?

Hello, I have a requirement to export a grid data to excel but I am confuse which smart service to be used for this. The Data is like, I have 5 reason and each reason have 3 groups, each group have 9 stages, each stages have 5 column data. the CDT/ Table fields are: Id (Primary key) Reason group stage data1 data2 data3 data4 data5 Reason-1 Group1 Data1 Data2 Data3 Data4 Data5 Stage-1 stage-2 stage-3 stage-4 stage-5 stage-6 stage-7 stage-8 stage-9

HI All, I am trying to set the length of 2 fields as VARCHAR(1200) but I am getting an error like max length of row reached. What is the max length of a field in mariadb.And I can see datatype "Text" as well,what is the difference between "text" and "varchar".If I use text then can i set my 2 fields length to 1200? Thanks In Advance, SSP

Hi, I am trying to create an email where I can use process variables in the email smart service of Appian. How can I use the process variables in email ? Can u pls help? The process model looks like below -  Thanks in Advance,

Good Day Everyone, Can someone tell what is the passing grade for Appian analyst certification? How many correct answers does one need out of 60 to get a passing grade, to obtain Appian Analyst certification? 

I have a validation on a dateField that I am trying to use a rule inside of the if statement. See below.validations: { if( and( rule!someRuleThatDoesntWorkHere(a, b, c), rule!someRuleThatWorks(a) ), "message goes here", {} ) } I get a "Cast Invalid Could not cast from Rule or Function Reference to Boolean" when I  add the first rule. Is there something I should look for specifically.

CAn any one tell how can I do the following in Interface, 1. I want a multiple selection option on a grid, having submit,cancel button on the bottom. 2. Another grid below the above one to get the data populated in this grid based on selection made on above grid after clicking submit button. 'Please help me, i am new please provide detail solution I would very helpfull. Thank you for understanding

Hi Community, One of our new project ask is to have Appian support branching, merging and deployment basically to set up complete CI/CD. How can we do that? We need more than one developer working on the same object and then merging them like using git version control. Any suggestions will be appreciated. Thanks,

I have a requirement to dynamically generate a word document from a template and will need at a certain point to insert images in different places.i have a list of assessments and for each assessment will need to generate a map picture of the location of the assessment (the number of assessments can vary and is not static) i was able to bring the list of assessments information but have no idea how to bring for each assessment the right map image generated ? i have attached the following screenshots for more clarity  When i try [#list logo as logo] ... [/#list] it insert all the images in one column like the following Please any suggestion how to solve this issueThanks

I was able to trace this issue down to the interface object. The new error from the design view when I click the EDIT link is: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!dropdownField [line 454]: A dropdown component [label="Relationship to Child"] has an invalid value for "choiceValues". Duplicate items are not allowed in the choiceValues array, but choiceValues was 4; 15; 54; 23; 27; 28; 29; 37; 41; 42; 43; 40; 44; 1; 2; 3; 4; 5; 6; 7; 8; 46; 9; 10; 11; 12; 13; 14; 15; 47; 16; 49; 48; 17; 18; 19; 54; 50; 51; 52; 53; 55; 20; 21; 56; 78; 39; 22; 57; 58; 59; 60; 23; 24; 25; 26; 61; 62; 63; 27; 28; 45; 29; 64; 65; 30; 77; 70; 66; 67; 68; 69; 31; 32; 33; 34; 71; 72; 35; 73; 74; 36; 37; 75; 38. item: a!dropdownField( label: if( local!isDependent, "Relationship to Parent", "Relationship to Child" ), placeholder: "Plea

Hello, I receive the error below when trying to edit a case: Expression evaluation error [evaluation ID = 8bac2:ea07c] : [Lcom.appiancorp.core.data.Dictionary; cannot be cast to com.appiancorp.core.data.FieldAddressable Any ideas will help. Thanks