Discussion Categories

I am experiencing issues across all my Record Types in Appian. Below are the details of the errors: When access any Record Type, I receive the following error: The data source cannot be reached or its configuration is invalid. Please contact your system administrator. There is an option to "Change Source Configuration," but upon accessing it, no modifications can be made and says: Editing the source of the record type will break all configured relationships.You do not have access to the configured data source. You can choose other data sources and tables, but you will not be able to select the original table again. When trying to access the Data Preview of the Record Types, another error appears: The System Has Encountered an Error HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = 2DENF]: Array is expected as second parameter, but received: . Additional Information: These errors seem t

I have a requirement where i  am updating the constant by using update constant smart service .The constant is having multiple values when i am updating the constant all values are getting updated with new value.Is there any way where we can update the constant at particular position. Example: I have a constant with values {"Apple","Grapes","Orange"}, by using update constant  smart service i need to update constant value Grapes to Pomegranates remaining values should not be modified. Thanks in advance

Why does the below peice of code does not work with records as rule input.  if( fn!isnull(ri!array), true(), length(ri!array) = 0) If I pass empty record in ri!array it should return me true, but it is returning false.

Hi Team, I have below text and I want to convert it into a Date and Time. Example: Text:  "01/07/2025 12:00:35 PM" Date and Time: 01/07/2025 12:00:35 PM or 01/07/2025 12:00:35 PM GMT+00:00

Looking to create a DSE to existing Appian cloud database or any recordset in the Appian Community Version. Not able to find any instruction or guidance where I can accomplish this. Can I get some information or help on this?

We have a synced entity based records with 13,000 and 50,000 rows respectively. However when trying to export the excel from the record list without applying filters will not do anything (not downloading even a blank excel), However in some cases applying filters download the excel but sometimes not. I looked into tomcat-stdOut.log I see this error message. 2024-03-28 17:52:52 WARNING [http-nio-8080-exec-558] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI example.appiancloud.com/.../download-grid, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected. Not sure how to resolve this or what needs to be corrected. Any ideas or suggestions?

Hi, We have 3 interfaces and 1 RecordType. 2 Interfaces call a RecordType and the latter calls a third interface. Example:    InterfaceA => RecordType => InterfaceC    InterfaceB => RecordType => InterfaceC  My Question: How the InterfaceC may know which source Interface (A or B) have called the RecordType please? The 2 interfaces A and B calls the RecordType with a RecordLink like : link: a!recordLink( recordType: cons!TST_RECORD_TYPE, identifier: fv!row.id ) The RecordType calls the InterfaceC using the Summary action (Tab View).

Hi,I have a situation where I have 2 groups, one is an administrator group and the other is a basic user group.There is a basic user action to submit a comment and upon submitting, an email will be sent to the members of admin group and basic group.Now while a basic user adds comment and submit it, there is a process error which says - An error occurred while evaluating expression: =toemailaddress(  a!forEach( items: a!groupMembers( group: cons!HS_ADMIN_GROUP,      direct: true,      memberType: "USER"    ).data,    expression: user(fv!item, "email")  )) (Expression evaluation error at function a!groupMembers: Expression evaluation error at function 'a!groupMembers': Insufficient permission). FYI - Process model security --> Admin group - administrator access, Basic user group - Initiator access.Can someone help me fix this issue.Thanks in advance

I have created these two below Expression :  a!localVariables( local!matches: where( a!forEach( items: ri!labels, expression: search( ri!filter, fv!item) ) ), a!dataSubset( data: index( ri!labels, local!matches), identifiers: index( ri!identifiers, local!matches) ))UI Snippet :  a!localVariables( local!pickedState, local!stateLabels: { "Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New J

Hi all, I was wondering if it's possible to provide context to and between user filters in a record? So if the user enters a value somewhere on the interface, can this value then be used to update a record filter? Like to update the list of options that are available? And is it possible to change the list of options in a filter based on what's been entered in another? Looking at the documentation I don't think you can, but I just wanted to double check. Thanks!

I am unable to find an example illustrating the appropriate content that should be included within this file to localize the function category name 

Hi Experts, I'm facing issue while calling the integration object from UI which seems to be getting timeout where as when I test the actual Integration Design object I'm not seeing any such issue. The timeout is configured as 300 secs in the integration object. Will enabling the "HTTP Request/Response Logging" can help in this case to identify the root cause? If yes, then who can access this log and from where and what information can they get from this Log?

Hi All I am trying to design a generic rule which will take recordtype. filter fields and filter values and filter operators and final filed as inputs and it should give result of that final field after ruining the query Record and applying the aggregation.It is working if the filter are single or multiple and all filter operators are "=","<>","<",">" but not when filters are multiple and operators are mix of in ,= or not in,= .here is the code i have used. a!localVariables( local!filterFields: { recordFields }, local!filterValues: { a!update(a!map(), "1", { 21, 27 }), true() }, local!filterOperators: { "in", "=" }, index( a!queryRecordType( recordType: recordName, fields: finalOutputField, filters: a!queryLogicalExpression( operator: "AND", filters: a!forEach( items: { local!filterFields }, expression: a!queryFilter( field: fv!item, op

Hi, When we give empty related record in place of ri!array in below code it should give me true as a result but instead it is giving false if( Â%A0 fn!isnull(ri!array), Â%A0 true(), Â%A0 length(ri!array) = 0 ) Here local!lrrfRec is the record and rgracslblLrrfSelectedCountries is the related record. We are passing this in place of ri!array. Please correct me if I'm missing something in the above code.

hello everyone , i need some help , how can i solve this , im trying to learn appian so i need some help to better understand it , 

hi,have a question about the Document zipper plugin I have a folder in Appian which I want to zip, the contents of this folder contain PDF documents in the following format: 00000.PDF where the extension is in capital letters. When the process that contains the document zipper node is launched, it creates the zip with all the documents correctly but the documents appear with the extension in lowercase. 00000.pdf Is there a way to keep the extension capitalized like the original documents in the folder? thanks

Hi All, I am facing an issue when using "Navigation" pattern available in Appian interface. I am having a read only grid in "Tasks" tab which contain related action for each record. Whenever I complete the action, the grid will be refreshed as expected but the tab will be automatically changed to "Workspace". Is there any way to stay in "Tasks" tab even after record action. Thanks in advance!

I have a group called ITC Administrators. It contains two users. When I populate the To: field with ITC Administrators, the node does not send an email. If I manually input the two users, the node will send an email. I have also tried with another group in the application, and it does not work. The process model does not show any errors in the monitoring view. Any ideas on what could be causing the node to not work with application groups?

i have an editable grid and in single row i have checkbox and textfields, i need to make textfield readonly false based on selected option in checkbox in that particular row. Please let me know if any workaround available for this

I have a requirement needs to update multiple constants with corresponding values. I have a constructive data type which will have the constant name in text and corresponding value. I am using update constant smart service to update the constant. Since i have multiple constants i have configured MNI to the smart service. while running the smart service i am getting the error "The constant specified is invalid or does not exist. Constant ID: null." Thanks in advance for the suggestions

I would like to identify the browser in use, to adapt my use case to it. Indeed, I have to (as per user requirements, I sware I tried not to) use a mailto, and Chrome is tremendously limited (less than 700 characters when sending to Outlook). So if Chrome is in use, I want to make the minimal email message. How can I know from the user interface, which browser is accessing my app? Thanks!

Hi, I have a long process (long running task) which calls a User Input Task to display a Main form with a text field. In that Interface I have a Related Action which calls a process to display a modal form, and when it is submitted, this later saves a new Text value in DB. When the modal form is closed, and I get back to the main form, my text field is not refreshed with the new data. So I've tried this little test in the Main form  : - On the saveInto of my textField I've added a writeRecords smartService to save data in the DB, and I've added a "GET" Button to get Data from DB (dynamicLink). If I enter a new value in my TextField, I can see that WriteRecords works fine, and the new value is well saved in DB (viewing it in phpMyAdmin), Then, if I click on the GET button, the underlying Expression Rule (EXPR1) gets some old data (why ? if the DB shows me correct data) If I execute the same EXPR1 outside of m

I have created a process where, depending on what is entered in a field, it either triggers a task with another form or a subprocess. I have tested the option to launch a new task, and it works well. However, when I test the subprocess, it stays with the green box, and the interface for the subprocess doesn't generate. Could someone help me?

Hello there, I recently upgraded to Appian 24.2, and wanted to use the styledTextEditorField in my existing application. Unfortunately, it seems to have an issue when displaying inside a dialog from a record related action. I call a process as a record related action, with the default openActionsIn = "DIALOG" in recordActionField > recordActionItem from my user interface. I have this interface (COR_Dtl), called as a start form of the above process:        a!styledTextEditorField(            value: "<b>KK</b></br><li>p</li>",            sizeLimit: 1000,            readOnly: ri!readOnly       ), When I call it with readonly = true, nothing appears in the dialog. With readonly = false, it shows correctly. I think

Hi All, I have a query if we have two array one is local!finalGridData and second one is local!origionalData. In the local!finalgridData i have updated data  local!finalGridData containing data like- 1. id:1, enddate: 21/01/2025 ,   id:1, endDate: 20/01/2025, id: 1, endDate: 19/01/2025 2. id:2, enddDate: 17/01/2025, id:2,enddate:15/01/2025 local!origionalData containing data like- local!finalGridData containing data like- 1. id:1, enddate: 15/01/2025 ,   id:1, endDate: 16/01/2025, id: 1, endDate: 14/01/2025 2. id:2, enddDate: 17/01/2025, id:2,enddate:15/01/2025 now we can see in local!finalGridData i have some updated data with endDate , but it also have data for id:2 which is not updated. so i want to fetch only updated data from local!finalGridData .  in this scenario id:2 data is not updated but in some cases it will update if user updated the date from UI . if both ids data updated then it's ok to send all the data but if not for all ids the