Foundation

Hi, Is there a way I can call an expression rule inside a process model and save different values from the expression rule output to the pv! variables for further use.

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

Hi, I am trying to generate a word document using "MS Word 2007 Doc from Template". The element which I am passing to a process model is having data like "Test & 1234". When I try to generate the document with this value, it is throwing an error when I try to open the generated document. Where as if I updated the value with "Test1234" and generate the document, I was able to open the word document without any issues. Any advises please. Let me know if you want any further details.

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)

I have data saved in Appian DB , I want to export all the data into an excel   and store in a location ,and the data need to be deleted from DB,   But before deletion I need to send an EMAIL   (after a week ) as kind of reminder that Data will be deleted  . Then I have to remove all the DATAS from DB . And this process need to be performed on the starting of every month .   Is it the correct approach ?  I am getting 2 files from 2 tables , but Encryption node allwos one document to be protected with password .how will they be passed  to get encrypted 

Hi, I am using a a!linkField with a!startProcessLink to call a process Model. Also, trying to pass parameters inside processParameters like processParameters :{Id: 10, User:LoggedInUser()}. Now, how can I catch these parameters inside my Process Model. Appreciate if someone provide any clue. Thanks.

We are getting error in Export data store entity to Excel  smart service when try to export data from table  There is a problem with task "Export Data Store Entity to Excel" in the process "XXX" Either selection or filters are invalid: The field [abc] does not exist. (APNX-1-4505-009)

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,  I want to check if the status is Start/ In Progress  or Completed. 1. if the list is  {"Start"; "Start"; "Start"}, result would be Start 2. if the list is  {"Start"; "In Progress"; "Start"} or any combination that the values are not the same, result would be In Progress 3. if the list is  {"Completed"; "Completed"; "Completed"}, result would be Completed. please help. Thanks,

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.

even if delete the font configuration in this smart service its taking the font from its previous version.  new document is not updating as per the current font configuration . what is the issue? can anyone help me in this pls

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 .

I'm using "PDF from Single DOCX (with Fonts)" smart service in the process model to convert word file to a PDF with the same font, but the smart service convert the document to PDF with different font. What is the correct way to convert it with the same font?

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

Hello, Recently I was provided with a requirement to extract certain data from PDF documents. The PDF documents should be extracted from a common mailbox and then few data available within the documents will have to be extracted automatically and stored in a database table. The whole process should be automated and there should not be any manual activity present within this process apart from reconciliations if any.  After going through the documentation, I came across the inbuilt application IDP and the basic Document Extraction smart services which can perform the data extraction task. As IDP requires some manual activity, I prefer document extraction services as a better option for this requirement. Can use Appian RPA to automate the steps required in using IDP to achieve this functionality ? Is this a better option than using the smart services ? Please suggest the best way of achieving this requirement. 

I have 3 buttons and two buttons must to be disabled if I select one of the 3 butttons. I tried with the follow code on disabled property: a!buttonArrayLayout(     buttons: {          a!buttonWidget(               icon: "check",               size: "LARGE",               value: local!buttonVal = 2,               style: "DESTRUCTIVE",               disabled: if(local!buttonselected = true, if(local!buttonVal = 1, "SECONDARY", false), false),               submit: a!save(local!buttonselected, true) ) },      align: "CENTER" )

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

Scenario:  A user opens a task and sees an actionable interface (they enter data, click submit, it goes back to the process model, etc).  The interface displays several key pieces of information the user needs in order to complete the task.  In addition, there is a button/link/widget on the interface that will open a second window with a lot more details regarding the context of this request.  Both windows need to be open at the same time and the user can tab back and forth between the two in the browser (or set the two side-by-side using two browser windows) as they complete the user input task.  The action interface has a dozen or two fields.  The details interface has a couple three or four hundred pieces of information. NOTE:  There are no record types being used here.  The details data is a large XML object that comes from an integration which will likely be placed into a similarly large, hierarchical CDT structure. Question: