Discussion Categories

I am executing a process model from an interface on button click using a!startProcess, and saving some of the process variables (lists) on the OnSuccess parameter of a!startProcess into UI variables. The process model has chaining enabled on all connections, both in the parent process and two sub-processes.  Both sub processes run synchronously, and execute at the same time.  In both sub processes, I loop over an integration using a counter variable (not MNI). The issue that I am seeing is that the saves on the OnSuccess parameter of a!startProcess execute before the process is complete, so I either get no results from the process at all, or partial lists.  When I monitor the process, it executes successfully and all the expected values are there. How can I ensure that the entire process executes before the OnSuccess saves execute?   The process typically takes between 1-3 minutes to finish.   Note: The goal of this process is

Hello,  I'm facing the following task - I need to be able to generate a unique sample from a table/view. A couple of notes: This is a large table, about 25 million rows This table will need to be filtered first, then sampled To filter, this table will need to join on other tables, which is why I'd like select the random sample from a view instead of the table The random sample would need to pull from a relatively uniform/normal distribution (basically not skewed) This random sample will need to pull from live data - there cannot be a 1 day delay or anything This table is a CDT in appian, due to point 1 DB system is Oracle I don't just need a list of random numbers, but I need a sample of random PK IDs These are the things I've tried/investigated: SAMPLE() I'm not able to get it to sample on a View, it throws some sort of primary key error. People have also reported that SAMPLE pulls from skewed distribution of data and I'm hoping for something more u

Hi all, I have a requirement as: I have 2 pickerfieldusers as A and B where A can select max 1 user and B can select max 5 user, requirement is when we select user in A then B cannot select that user which is already selected in A and should throw validation error as "A user cannot be selected in B". I tried putting validation as : validations: { if( contains( local!taskAdditionalAssignee, ri!record['recordType!{a6f5f29e-a89e-495a-afae-702df167aa19}RECT Record Tasks Sync.fields.{d0fec037-4f71-4d05-a7ef-766635d0ff13}taskAssignedTo'] ), "Assignee cannot be added as additional assignee", null ), } but when I open this form then as A and B both contains null value so same validation error throws comparing both A and b having null value which becomes similar please help me how to achieve this

In my use case, A Customer is linked to multiple Units in a one-to-many relationship. On one interface, I have a customer selection, and based on the selected customer, the corresponding units are displayed in a dropdown labeled "Unit." This is achieved using an expression rule within a refresh variable. Additionally, there's an option for the user to add a unit on the same page for the selected customer. For this, I'm using a Record action, where a pop-up window opens for data entry. Once the user submits the data, the unit list in the dropdown is refreshed to include the newly added unit. This is done using the "refresh after record action" feature. While this functionality works as expected in the browser, it does not work on the Appian mobile application. Any suggestions?Here is the Code Snippet local!units: a!refreshVariable( value: rule!FAA_QR_get_Unit( customerTpi: ri!assetRecord['recordType!{20d559ec-3d4b-4870-9672-f594295b09f7}FFA Asset.fields.

we have this grid but the user wants like below how can we transpose this grid to row wise grid

Hi, We currently manage a fully functional Appian HA distributed environment that contains: 3 application servers 1 web server 1 database server I had some questions regarding a migration that is being planned from a corporate level that involves IP addresses being changed for our servers hosting Appian. (Effective May 11th, 2023) If IP addresses were to change for our servers hosting Appian: 1. What issues would this cause to our Appian HA environment? 2. Which actions need to be taken in order for Appian to be fully operational when the ip changes occur? Let me know if any additional information is needed. Regards, Chetana

Dear community, Modal popup windows are a very frequently asked UI element Appian does not provide OOTB. The purpose of a popup is to make any UI element fade into the background and provide an isolated area to require a specific input from the user. In Appian, we cannot implement this visual style directly, but we can achieve a very similar behavior. Instead, we hide all UI elements and display a single centered card layout. This card contains all the necessary elements. When a user clicks a button, the popup is closed, and the rest of the UI becomes visible again. Read my blog post for more details. https://appian.rocks/2023/06/20/popup-windows-in-appian/ Cheers, Stefan.

why there is no user context in an expression in a node output

I would like to force logout a user without user interaction. I know that Appian has Session timeout, but I would like to logout a user on a specific workflow (after 30 sec) without disturbing Appian default session timeout settings.

I have a form where user can upload document, I can see the documentId and the document name in localvariable in the form, but when I try to resolve the document content, like using excelreadcellsbynumber. But it feels like the document content is not available, does it mean the document is actually not uploaded at the moment. Since this form is a startform of process A, I try to use startProcess in this form to initiate another process B, but it seems the document is not available in process B as well. Can anyone explain if there is a rule that document content will only be available after submit this form

Hi everyone, I’ve created a GET method Web API that returns a list of countries in the HTTP response. The Web API also includes a query parameter for the username. Now I need to log each Web API call by saving the endpoint name, response body, query parameter, and the current date and time into my Web API Log record. However, the issue I am facing is that Appian doesn't allow the execution of the WriteRecords smart service within a GET method Web API and gives me this error: Smart Services cannot be executed in Web APIs that have a method of "GET." Does anyone have any suggestions on how to handle this case without changing the API method to POST, PUT, or any other? I would appreciate any help. Thank you! For reference, here’s an example of my Web API code: a!localVariables( /* Retrieve all avalaible countries from the corresponding Record Type */ local!countries: a!queryRecordType( recordType: 'recordType!ABC Country', paging

i have this {a!map(memberId: "test ui "), a!map(holdReason: "test ui "), a!map(description: "test ui "), a!map(summary: "test ui ")} wants an out put like a!map( memberId: "test ui ", holdReason: "test ui ", description: "test ui ", summary: "test ui " )is this possible ??

While i am practicing, i created a record type and when i am trying to generate record event types , i am getting an error " You must have edit access to at least one of the applications this record type is in to generate event record types ". I read a similar content and checked the following, but there were no problems. ・Record Type is added to any Application. ・There are not Missing Precedents. I can generate record event types about 8 days ago, but I can't do it 5 days ago.  I saw an article saying that it was automatically resolved so I left it alone, but it hasn't been resolved yet. ・Similar Content community.appian.com/discussions/f/data/35375/generate-record-event-type/137648 If you know, I look forward to your reply.

We deal with sensitive documents and for the sake of security, we are looking for a way to upload docs directly from Appian UI to S3 instead of temporarily saving it in Appian folder and deleting it later. 

I have this statement as the SQL statement on a Query Database node:UPDATE `ThisTable` SET `Status`= ac!closedStatus WHERE `TableId` in (ac!ListOfTableIds) ac!closedStatus is an Int, ac!ListOfTableIds is a list of ints. When I run the process, the Query Database node errors with this error: There was a problem executing the SQL query. SQL Message : class [Ljava.lang.Long; cannot be cast to class java.lang.Long ([Ljava.lang.Long; and java.lang.Long are in module java.base of loader 'bootstrap') I know I've gotten "IN" working on query database before, I just always forget the trick. Does anyone know it?

Hi , I have a scenario , where if a request is rejected by a user , the same request cannot be delete by the same user who rejected it . a!buttonWidget( label: "Delete", icon: "times", value: cons!Deleted[2] saveInto: {ri!buttonAction} style: "DESTRUCTIVE" showwhen: and( ri!readonly = false, loggedinuser() = ri!maker ---- this is just a rule input with type text a!isNotnullorempty(ri!rejectedby) ), disabled: if( ri!rejectedby = loggedinuser(), true, false ), validate:false Can anyone please help me with it . Thank you in advance.

We are facing multiple production incidents due to objects at different versions in all different environment.  Can any one please suggest what is the best governance practice we should follow to avoid these issues. Here, Appian support team make direct changes in Production objects mainly constants according to the incidents raised but they are not moved to lower environments. hence, when developer take changes from lower environments, it overwrites the production object, causing issues.  There are multiple heavy applications with more than 500 objects. How to keep all environments in sync? 

Hello, my team and I have used the new AI skill for an email classifier and we have several questions regarding the process.For some context, we need the AI to classify emails into three groups, lets say A, B and C. To train the AI we uploaded: for group A around 139 eml files, for group B around 103 eml files and around 70 for group C.Once it was "trained", it said it had an accuracy of 100% and it  concluded there were no errors in the training process nor the actual classifying process, but as seen in the picture, it seems the model was  only trained with few of the files we uploaded for each group.  We were a little surprised when we took a look at the metrics since 1- they were extremely successful and 2- the ai didn't use all the files we uploaded from each type. We still went ahead and tested it with new emails, 1 from group A, 2 from group B and another 2 from group C. The results showed all emails but one were classified as group A, and the

Hello everyone, I’m working with an interface grid that is prepopulated with different documents. There's also an "Add New" button that allows users to upload additional documents to the grid. Requirement: Users should be able to upload new documents. They should also have the ability to replace the prepopulated documents with new ones if they find an issue. When a document is re-uploaded (i.e., replaced), the old document should be replaced with new one, and not saved. Essentially, we want to fully replace the old document with the new one. I’ve read in previous posts that the target attribute on the a!fileUploadField component, when set to a folder, creates a new document in that folder. If set to a document, it’s supposed to replace the existing document by creating a new version. However, I’m encountering issues with this approach. Here’s the code I’m using: a!fileUploadField( target: if(

We have an expression rule that has not been modified since 2017. The developer who wrote the rule originally is no longer with the company. This rule is executing without error in our DEV, UAT, and PRODUCTION environments. However, when I go to the rule in Appian Designer, it's throwing an error, saying there is an undeclared local variable. Indeed, there is an undeclared local variable, and it is referenced multiple times in the rule. However, this rule is somehow working, otherwise we would see dozens of errors in Production on a daily basis (according to the rule's Performance Trends, it's hit several hundred times a day). How is this rule able to work correctly when it's called in Production, but becomes a problem when it's being modified in Appian Designer. It's worth noting that the rule is called by an Interface that (again) has not been updated since 2017, and still uses "load" and "with" instead of "a!localVariables" - and

The excel sheet contains some blank rows to divide the sections which I can't change, how can I skip these blank rows when reading from excel sheet. I see this readexcelsheet() function in other post seems it can decide which row to start, is it deprecated?

we are using chartcolumn in our application. Can we increase the X axis and Y axis labels. currently appian provide XAxis Style, YAxis style options are "NONE" and "STANDARD". please let me know if we can make these labels bold and italic/underlined. Thanks

I got 2 of this. one is Intergrate Designer and one is API Web designer. I already configured all the parameter and the endpoint seem the same from 2 of them. I use test request and both of them return success (200) but only Web API designer post data to database while Intergrate Desginer doesn't. Integration Designer :  Web Api Designer: Can anyone know what is the issue and how to resolve this one.

Hi, I am trying to call a process from parent process model but the start form in child process does not open and flow just pass through it. I tried with activity chaining or used subprocess but nothing worked. One way i know to change the process start form to task based form but wanted to check if there is any other way without it? Parent PM: Child PM:

I have a read-only grid that pulls the data from record type . I am trying to enhance the feature to add an update link to the page to enter new rows and thats needs to be updated in the Table .  Is there a way to achieve this without a CDT ?                                                                                                                      (or) Is there a way to update a table from the interface without a CDT?