Foundation

Hi, I'm adding a grid field into the interface, involving columns from a record type. There is one column called updatedDateTime, and what I want to query is data which were updated within the last 2 days, that means now() - updatedDateTime < 2 days (or 48hours) or . The column format is now dd/M/yyyy hh:mm a I cannot find out how to write in the filter parameter of a!gridField() so please help!

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!

I'm trying to send an email to group members, I sent it successfully, but how to call the recipients one by one in the body of the mail e.g. Dear ABC, XYZ, PQR I want to show like Dear ABC 

I want to add multiple rows in an editable grid layout by selecting a number using Interface

Hi, What might be the best approach to generate a PDF document in Appian using process model smart services. Thanks.

Hi, In Production context, a process raised an error on a Write To Multiple DS Entity node because of a mandatory field is set to null. When editing the process, I can see that some process variables are editable ("Modify" button is visible) but the PV for my concern is not editable (type CDT). From the link below, I've read that 2 solutions are possible to fix and resume the instance : 1/ Creating a new PV, then assigning the latter to the Write To Multiple DS Entity node...    (but I don't see any way to add a new PV, as the "variables" tab from process properties is not visible from the monitor process instance view)  2/ Using the IFM Manager plugin. What would be the best way (more simple) to correct the process and then resume it please ? https://community.appian.com/discussions/f/process/13373/how-to-add-a-process-variable-in-already-initiated-process-instance-and-map-this-new-process-variable-to-a-form-i

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

Hi I started working from the last month as Appian developer Need help or suggestion Tying to implement custom autogenerated primary key in sequence. Example - INVREQ0001 , INVREQ0002 and so on. If someone knows how to generate this then please let me know Many Thanks in advance

How to mask specified number of integers ex:- ######7890.

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

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?