General

Just a question regarding the exact location and order that variable data is saved in.  I have noticed that saving a variable in a child interface that was passed into it as a rule input also changes the related local variable in the parent interface, which is normal functionality that is explained in several tutorials.  However I also noticed that saving a set of identical SAIL code into a local variable and then changing another local variable results in no change.  For example if a dropdown option like this were selected it immediately resets the variable, local!madeFromCDT, back to the default:local!madeFromCDT: cast( typeof(type!("arbitraryType"), {abitraryField: null}))), local!sailInterfaceDropdown: a!sideBySideLayout(     item: rule!nestedDropdownfield(          choiceLabels: local!listOfYesNo          choiceValues: local!listOfYesNo     &n

Hi All, We are getting "this.folderid" is null exception on email poling process model and failed to create process instance. This issue is happening intermittently, on the same PM we have instances where process instances are successfully initiated. We haven't configured any folder on the start node, as there was no requirement for us to capture the email attachments. However at times we will receive attachments. The same email was successfully instantiating process instance on lower environments. 2024-12-30 14:20:46,647 [Appian EmailHandlerBean - 1475] INFO com.appiancorp.process.emailpoller.EmailHandlerBean - EmailHandlerBean received email message. ([XX] [Order to Produce] Account No. XXXXXXXX (Police Ref: D/XXXX/XXXX)) 2024-12-30 14:20:46,947 [Appian EmailHandlerBean - 1475] ERROR com.appiancorp.process.emailpoller.EmailHandlerBean - Error receiving message in EmailHandlerBean MDB jakarta.mail.MessagingException: Message could not be sent; neste

I am a bit confused about the differences between the old and new pricing models and would appreciate some clarification. From what I understand: The old pricing model was based on the number and types of users. Each type of user was priced separately (e.g., Standard User at $75, Infrequent User at $9, and Input-Only User at $2). There were also minimum criteria (100 minimum users and 500 minimum Input-Only Users). All plans were fully featured. The new pricing model, however, seems to be feature-based. It appears they are charging based on the features you need, as they not mentioned about users (correct me if I am wrong). I want to clarify : Does the new model still differentiate between types of users like Standard User, Infrequent User, and Input-Only User? Or do they now only consider one type of user for billing purposes? Is there a minimum number of users required to be purchased in the new model, similar to the old model (e.g., the 100 user minimum) or not? I

I have a RecordType STG with multiple Records in it. I need to have that data inserted/copied to another RecordType TARGET. Both have the same columns and data types defined in them. With the exception of Unique Identifiers  (ID Column) in both the Tables, I want the rest of all columns data to be moved from STG to Target. Can you please advise on how we can do this. I was thinking Script Task in a process model, but need some guidance on this.

Appian Community Team, I need to have an Expression Rule that does the below: Takes 2 Rule Inputs: 1. reviewID (Number data type) 2. file (Document Data type, this is Array holding list of documents) I need to write an Expression rule that iterates through the Rule Input file and then outputs a list of Record Data ReviewDocument, this ReviewDocument record will have data points from both Rule Input reviewID and File. Can you please advise on sample code for this.

We have two variables aslocal!legacyData {"OTHER", "Number Block Request", "OTHER", "CRIS3-AB", "CRIS3-AB", "CRIS3-AB", "CRIS3-AB", "CRIS3-AB"}, local!legacyOrderValue {"JADE844610514", "76944", "SR-01028013", "I4166196233", "I3433620146", "I3433570105", "I6139550170", "I3432220101"}As of now we are getting data in below format But we want to display data in below format

I have a usecase where there are two arrays : one is empty and second one has some values Array1 : {"",""}, Array2 : {1:1,2:2} After removing null or empty values from Array1 using filter function filter(a!isNotNullorEmpty,Array1), I have got empty array which is of List of Varient type Now I want to apply difference function difference(Array1,Array2) Since both are different data types, im being thrown error as invalid types. If I have any values in Array1 like {1:1}, it would be of type List of Dictionary, but now here it is List of Varient since nothing there in the Array. How can I perform difference function operation now? Is there any workaround to convert list of varient to list of dictionary ?

We are getting the expression evaluation error that start index must not be greater than total count. We got the scenario from the user when this issue is occuring. For example, there are 25 tasks in a grid. In 1st page, we will show 1 to 10 tasks, 2nd page with 11 to 20 and last page will have 5 tasks. This count is same for 2 users. Both users open the same page and 1st user completes lets say 5 tasks. So for the 1st user, the task count gets reduced but for the other user, the count will not get reduced since he hasnt performed any action in the page. Now when he clicks on the last page icon in the grid, the following error pops up. Any suggestion to solve this issue?? The tasks are being queried from task report.

Is there any way to search all our constants for constants with a particular value contained in their list of values? Our options are By name/description, UUID or UI, or by expression. None search the values of our constants. 

Usually once the document is stored in the correct folder, but is some cases it is getting stored in temporary folder and Geeting the error while trying to access the site, so can we know why in some cases document is getting stored in the Temporary folder, is there is any condition to store the document in temporary folder. 

Hello All, I am trying to create a document search feature where the user is expected to search for documents only with document name as input. I have already tested "Content Tools - findDocumentByName()" function and realized that it only works when the full name of the file is provided as input. I want to have the partial name string search capability where the system can output list of documents with names containing the search string. Assuming the document metadata(e.g. doc id) is not stored in DB, is there any way to solve this?

Hello Appian Community, In the project I'm working on we are designing a flow to automate deployments using Jenkins. I have tested Appian APIs to download packages automatically. But when I use the API (https://docs.appian.com/suite/help/latest/Application_Package_Details_API.html)  to obtain package information from an Application, it only returns the packages created in that environment. But I want to download a package that I have deployed using "Compare And Deploy" and therefore I have not created in this environment.  Could you tell me how to download the package that has been deployed? Thanks in advance!

Hi fellow devs, There is a scenario where I have email address available to me like: "testuser@gmail.com" and this email address has some username at the backend like this: "Test_user". Now what I want to do is on the basis of email I want to fetch username. Previously I was using this function to fetch username out of email address: index(getusersby(pv!ccperson,3,1),1, null) (this function gives output in expression rule but in process model don't know why its not working and gives error) but now it seems like this function is no longer working. I am unable to find any other function through which I can perform this functionality, any help in this regard would be helpful.

How can we get 1st index elements of each array in different new array. Like{2,13,65}{7,15,45}{14,3,56}So output of 1st elements should be {2,7,14}And for 2nd and 3rd {13,15,3}{65,45,56}

Hi All, We have installed Appian on Kubernetes, but the current file upload size limit is 1MB. Could you please advise on how to increase this default upload file size? Thanks in advance.

I have a record type called "Case", and it has a field called "assignee". I also have an interface, in the interface, I have a grid field that show all cases, with multi-selection enabled a dropdown field allow user choose an assignee a button, called "Assign Selected Cases in Batch", after user multi-select cases and select assignee from dropdown, allow user to click this button to assign multiple cases to 1 assignee in 1 click To do so, I created: a batch assignment process model (works perfectly) In the interface, I declared: a refresh counter called local!caseDataRefreshCounter, initialize with 0 local!cases, as a refresh variable, with refreshOnVarChange set to local!caseDataRefreshCounter, and it is corresponding to the "data" field under my a!gridField the button widget implementation of "Assign Selected Cases in Batch" is a!buttonWidget( label: "Assign Selected Cases in Batch", saveInto

Hi people, I have requirement where i need to find the X path of an XML file. We have functions to retrieve a value using the X path. But our requirement is retrieve the X path instead of the value, So that the user will use that and cross verify the xml file whether its matching. Here is an example. Input: <Document> <customer> <details> <name>xyz</name> <address>abc</address> <contact> <phone>45667778</phone> <employee> <company> <department> <id>6786</id> </department> </company> </employee> </contact></details> </customer></Document> Output: for Retrieving the name XYZ this would be the X path "<Document><customer><details><name>" this is actual output we require And this is the output we need for nested X path. "<Document><customer><details> <contact><employee><company><depa

I want to add a certain number of zero to the left of an integer number and save it to an Integer rule input..I was using text(value,"0000") this function which gave me exact format but when I save that to an Integer variable , all zeros had been removed. Id type is Number(Integer)for ref:  { a!textField( label: "Text", labelPosition: "ABOVE", value: text(tostring(ri!Id), "0000"), saveInto: ri!Id, refreshAfter: "UNFOCUS", validations: {} ), a!buttonArrayLayout( buttons: { a!buttonWidget(label: "save", style: "OUTLINE") }, align: "START", marginBelow: "NONE" )}

Hi Community, I'm working in a project where data ingestion is very important and we get data from csv files. The problem I have at the moment is that with the plug in ps-plugin-ExcelTools in particular with the smart service Import CSV to Database I need to set the charset input (e.g UTF-8 default or UTF-16). Due to the fact that I could receive files in both encoding format, the question is: Is there any solution to get the encoding of a file?  I find a solution saving the document in Base64 into Db and analyzing the string obtained. Does anyone have a smarter solution? Thx in Advance. Bye bye

I'm trying to change the color of the validation in dateField(), but I'm not sure if we can do it. Does any one know if it can be done? Thank you.

{ a!localVariables( local!data: a!recordData( recordType: 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{1ce64732-409c-43eb-ad89-865ecbd09000}CURRENT_REVIEW_STAGE', operator: "=", value: "Initial Review" ) }, ignoreFiltersWithEmptyValues: true ), fields: { 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{6aa0c857-afe2-486b-bdeb-6a01ff3ed63f}id', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{ef25fa56-4caa-4eed-bafa-10a295456244}LOAN_ID', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{1ce64732-409c-43eb-ad89-865ecbd09000}CURRENT_REVIEW_STAGE', 'recordTyp

Good afternoon, I need to create an Any Type variable in a process to maintain the format. For example, I will send rule!example from the source and I want it to be preserved. It works between rules with Any Type variables, but I can't do it in the process. Does anyone know a way to create Any Type variables in a process? Thank you very much

am encountering the following issue when attempting to start the Appian server as a local instance for plugin development: Error when running engine scripts ERROR com.appian.komodo.engine.KLicenseVerifier - Error starting K: null As per the possible solutions mentioned in the KB article, I have already: Requested and applied a new long team license to my local instance. Verified that there have been no changes in the following: The operating system. The CPU count. The Fully Qualified Domain Name (FQDN). Ensured that no more than one hostname resolves to the local network IP of the machine where the license is installed.

Good morning. Is there any way to know, using the ID of an object, what its dependencies are and which application it belongs to from a rule? Thank you very much.