General

I have a requirement for formatting the field where it should be  of 7 digits + a space + 4 digits = 11 digits with a space in the middle. e.g. 1234567 1234.Any help will be appreciated. Thanks, Shobhit

Hi All,         4 environment – Dev, Test, UAT and Prod. Production support team are not given administrative access to Prod.      Which is the least level of access that they should be given? Best Regards.

Hi All,    Pls answer the below question  I have five pages in Site.But i want give access to User Particular Page only.  Pls explain it  Thanks in Advance!

am getting above error for the code, correct me if am wrong

Hello, I am trying to filter for duplicate record and only return 1 row/record for the image below: I am currently storing the returned in a local variable: Any help will be appreciated. Thanks

When I export an application, where is the information for the Appian version stored?

what I am looking for is a generic qry that will return the primary record when the case number is duplicate as shown in the image (242xxx)

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,