Discussion Categories

Hi, I have a local variable with multiple values. I used foreach loop to iterate a grid. I got multiple grids based on the number of values in the local variable. I have another variable containing users. The user name should be displayed at the top of each grid. Example if there are 4 grids I need to display 4 names . Each name above each grid. I want to know how to merge these two values to display each user names at the top of each grid. local!user:ri!selectedLeaderIds (contains Users)

How to trim this text: "UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_Integral_-_MARSHA_BISHOP_-_banking-mb_jfblaw.ca" to  Integral_-_MARSHA_BISHOP_-_banking-mb_jfblaw.ca

HII'm working with the following table structures and need to display approval tasks to users based on the current milestone of each request. A task should be shown if the user is either directly assigned or belongs to the assigned group. Each row in Request table has multiple rows in approval table. Is there a way to achieve this using records (not a database view) given the structure below?  CREATE TABLE `table_request` ( `col_id` INT NOT NULL AUTO_INCREMENT, `col_loan_key` VARCHAR(32) DEFAULT NULL, `col_loan_1` VARCHAR(32) DEFAULT NULL, `col_loan_2` VARCHAR(255) NOT NULL, `col_manager` VARCHAR(100) DEFAULT NULL, `col_sponsor` VARCHAR(255) DEFAULT NULL, `col_milestone` INT DEFAULT NULL, `col_status` INT DEFAULT NULL, `col_submit_date` DATETIME DEFAULT NULL, `col_created_date` DATETIME NOT NULL, `col_created_by` VARCHAR(255) NOT NULL, `col_updated_date` DATETIME NOT NULL, `col_updated_by` VARCHAR(255) NOT NULL, `col_is_active` TINYINT(1) NOT N

I am trying to follow appian academy tutorial.  In the steps i have to call a record type using rule input in an interface. However, when i type my record name in New rule input type it is not shown. What can i do?

I am creating editable tree grid. I want to save the identifier value in local!selection. GridLayout and GridRowLayout are in two different rules.GridLayout in an interface and GridRowLayout is in a expression rule. the selection saves values in local when the selection style is "ROW_HIGHLIGHT" but not "CHECKBOX" Can anyone help me resolve this issue?

Hi, does anyone know what's the difference between using WhatsApp Business Connected System (plug-in) and Connected System with the base URL https://graph.facebook.com/

I am having one form ie. customer form, I need to hide the 2 fields like dob and email id from basic user automatically , like we can keep showwhen condition in the form itself but it is manual process , need to do automatically .. is there any way to do this? in appian

We are experiencing an unusual issue in our application running on Appian version 24.4. When users fill out a text field and tab out, the value is not immediately saved to the associated local variables or rule inputs. Interestingly, the value only seems to persist after entering text two or three times. This behavior is inconsistent and unexpected. Has anyone else encountered this issue or identified a possible root cause? Any suggestions or workarounds would be greatly appreciated.

I am in a site and I need to open an interface/site in a new Tab, and I need to pass more than 500 items in a List of Text format to the new Tab site

When retrieving data through an integration, if an error occurs, I want to display a detailed error message to developers for debugging purposes. However, if an end-user encounters the same error, I prefer to show a user-friendly message that doesn't expose technical details.

 I have created a form and now I want  likenow how will the input details of this form will go when we click on save  button and also how access CDT and DS and how will data get saved [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:2df2892a4df7486f9775b4d2f0e405fd:e9ed411860ed4f2ba0265705b8793d05]  [mention:ba9672c2f5294cb98c0a2b8fb79cf967:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

Hi! In the Appian Designer, we have interfaces with text fields that save into rule inputs or local variables. When entering in data into each of these text fields, the data is only sometimes saved in the rule inputs or the local variables. Why is the user input not saving all of the time? Has anyone encountered this issue before? Below is an example with four text fields. Text1 and Text2 save into rule inputs ri!text1 and ri!text2 both of type text. Text3 and Text4 save into local!text3 and local!text4. User input is not saved every time the value changes. a!localVariables( local!text3, local!text4, { a!textField( label: "Text1", labelPosition: "ABOVE", value: ri!text1, saveInto: {ri!text1}, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Text2", labelPosition: "ABOVE", value: ri!text2, saveInto: {ri!text2}, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Text3", labelPosition: "A

I have a table with 100,000 records. In the development environment, I used queryEntity to retrieve the data without issues. However, in the production environment, the dataset is much larger, and performance has become a concern. I tried optimizing the query with selections and filters, but the large volume still causes problems. I considered using a stored procedure to handle the data retrieval with specific conditions. The downside is that any future changes to the database schema would require updating the stored procedure, leading to additional maintenance work. To address this, I implemented a paging strategy in Appian. I retrieve the first 100 records using pagingInfo and then loop through subsequent pages to fetch the rest of the data incrementally. This approach helps manage large datasets more efficiently within Appian. is there any approaches other than these , can you guys help me with this?

I have a workflow consisting of three forms: Customer Details, Address, and Health Care Details. Customer Details Form: After filling out this form, I save the information to the customer table via an API call. If this operation is successful, I proceed to the next form. If it fails, I delete the customer entry from the table. Address Form: Upon successful submission of the customer details, I fill out and submit the address form. Health Care Details Form: After successfully submitting the address form, I proceed to the health care details form. However, if an error occurs while saving the health care details to the table (for instance, a failure in the write operation), and no entry is created in the health care details table (which uses the customer ID as a foreign key), I need to delete the previously saved entries in both the customer and address tables to maintain data consistency. The challenge is that if a node fails during this process, Appian halts further execution, m

We are using 'Export Data Store Entity to Excel' smart service to write data into Excel files. We built a process model which copies an excel template and writes into the copy of the excel template to generate an excel file using this smart service.This smart service is pretty much doing a good job other than few issues which we are trying to find resolution. Here are couple of questions if you can help with. 1) We notice that formats maintained in the Excel template is getting lost if we write some values into that specific cell. Is there a known way to avoid this? (Please see the screen shot attached) 2) Also - we notice, in the cells, if we write numeric values, the generated excel is comming up with this 'comment' icon in cell corner. We tried to write the value as numeric to the cell. But looks like still that is not fixing the issue. Is there a known way to avoid this? (Please see the screen shot attached) 3) Is there a way to delete a sheet from the excel in the

hi team, we are trying to run 2 smart services in signle saveinto but one smart service is running in the backend but 2 nd smart service not working, is that validation in appian?or did i missed anything, could you please suggest me? thanks

Hi All, I am encountering the error mentioned in the subject whenever I try to open the summary of one of the requests. In the record view, we have configured the following expression: rule!summary_interface(record: rule!qry_record()). Note: When I switched from rule!qry_record to rv!record, the error disappeared. Initially, we suspected that the issue was caused by a large dataset. To address this, we reduced the query size to ensure it evaluates within 50ms. However, the error persists. To investigate further, I opened the summary interface object and tested it by passing the query rule directly. When I clicked "Test Object," it loaded without any errors. However, when I opened an unnamed interface and invoked the interface using the expression: rule!summary_interface(record: rule!qry_record()), the same error occurred.Also in error message , its specifically mentioned about one child interface which just shows grid data around 20 items. If i remove this interface from summ

Hi everyone, just wanted everyone's opinion on one of our process. We have multiple categories for which we have different set of user roles. They are stored in DB like category 1 -> category 1 roles with their users. And the count of rows is roughly 4000 in production. Role are 1 till Role 11. Categories are like 100+ and there can be multiple users for a role. Also, we have few user groups for few of our oversight roles so whenever there is change we add or remove users from group. So the thing is for Role 1 - Role 6 we are checking throughout application by querying the record with a batch size of 1 and with a single field, if it returns we believe the user has that set of access and we show the screen accordingly. For the rest we use if they are part of user groups and show the content accordingly.My question is what would be a better approach for this? To have groups for all roles and then whenever there is a change add/remove in all user groups? Won't t

I want to create a generic process model for update constant. I used update constant smart service as it required constant as input which is of type content constant. so i want to pass constant as process parameter. is it possible or is there any other way to do this?

I am using an RPA smart service within my process model.I pass through data to the RPA Smart Service which a bot will run to retireve data from a 3rd party application. PolicyNumberThe goal is to pull that information (policyNumber) out of the robotic task to use in the rest of the process model. At the moment the bot successfully captures and stores the data in the Variable, but on the Process Model side, it is still showing 'no value'. The result of the variable on the robotic task after a successful run:Any assistance on helping to retireve this text string or even persisting this data would be greatly appriciated.

Hello people! I have a problem with the dropdown component. My component is initially initialized with the value of a null variable, but when I change it to a valid value according to the range, it works normally, but when I click on the selection option (placeholder), I get the following error Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'interface' at function a!dropdownField [line 1098]: A dropdown component [label="Estado"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was and choiceValues was AC; AL; AM; AP; BA; CE; DF; ES; GO; MA; MG; MS; MT; PA; PB; PE; PI; PR; RJ; RN; RO; RR; RS; SC; SE; SP; TO. The variable has a null value and the component is understanding it as an invalid value. Can anyone help me?

Hi, We are using Compare and Deploy to deploy between environments where we have configured a service account so that objects will be deployed in the name of service account. However, we could see that deployment approver username also captured in design_objects.csv along with deployment service account whenever a data type is deployed. Can you please me in understanding the log behavior?

After upgrading to Appian 25.1, the logs indicate that all services are up and running. However, HTTPS calls to port 8080 are not working.  Am seeing the following warnings in the logs:  “Ignoring JAVA_HOME; using ES_JAVA_HOME instead” “Unable to load the config file: /home/.aws/config — Access Denied Exception” Any help in investigate why port 8080 is not up and running would be much appreciated? All 15 requested services are running [analytics00, analytics01, analytics02, channels, content, download-stats, execution00, execution01, execution02, forums, groups, notifications, notifications-email, portal, process-design] 0 [main] INFO com.appian.data.server.Watchdog - Data Server is starting using the [ALL_COMPONENTS_MODE] startup mode.18 [main] INFO com.appian.data.TopologyFactory - Loading topology /usr/local/appian/data-server/conf/appian-topology.xml *************************************************************************************

i'm using Export Data Store Entity to Excel plugin is giving the above error  = a!queryLogicalExpression( operator: "AND", logicalExpressions: { if( pv!isAdvanceSearch, { a!queryLogicalExpression( operator: "AND", filters: { { a!queryFilter( field: "firstname", operator: "includes", value: pv!firstName, applyWhen: a!isNotNullOrEmpty(pv!firstName) ), a!queryFilter( field: "middlename", operator: "includes", value: pv!middleName, applyWhen: a!isNotNullOrEmpty(pv!middleName) ), a!queryFilter( field: "lastname", operator: "includes", value: pv!lastName, applyWhen: a!isNotNullOrEmpty(pv!lastName) ), a!queryFilter( field: "screeningstatus", operator: "=", value: pv!scrStatus, applyWhen: a!isNotNullOrEmpty(pv!scrStatus) ), a!queryFilter( field: "country", operator: "=", value: pv!country, applyWhen: a!isNotNullOrEmpty(pv!country) ), a!queryFilter( field: &quot

a!richTextDisplayField( value: a!richTextItem( text: "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum." ) )] Example:  My Test should be this way, no matter the words amount __ ___ ______ __ ___ ___, __ _____ ___ ____ ______ __ ___ ______ __ ___ ___, __ _____ ___ ____ ______ So, how would I be able to justify a text? Because I haven't seen such option.