Discussion Categories

Hi everyone, We have configured a process report to retrieve all active processes. Additionally, we have a query to obtain the active process ID for each case based on the Case ID. However, we are encountering an issue where multiple values are appearing in the column of the process report (mapped pv value for column in process report). As a result, some of the active process IDs are not being queried correctly. Could someone please help us understand why multiple values are appearing in the process report? Is it because the process report contains the value changes from the process history?

a!localVariables( local!choiceValues: cons!VS_VALUES(list of array : "AB","BC","CD",) local!dropDownValue, local!value, a!multipleDropdownField( choiceLabels: local!choiceValues, choiceValues: local!choiceValues, value: local!value, saveInto: { a!save( local!value, if( contains( save!value, index(local!choiceValues, 1, {}) ), 0, save!value ) ), a!save( local!dropDownValue, if( contains( save!value, index(local!choiceValues, 1, {}) ), remove(local!choiceValues, 1), save!value ) ) } ) ) Hi All. Hope you all are doing well.  I am using multiple dropdown and working with records. The above code i am trying to edit already present value in the multiple dropdown. Above is the code .  If i try displaying the selected value i am unable to deselect it and

Hi,What trying to create a sample data for a Record Type but is throwing the below error. Even tried suggestion given on the error but again throwing the same. Kindly let me know what else can be done. 

Hi Team I am using an environment specific date constant. This is an array of dates constant .. I want to deploy to higher environment but in such a manner that the constant should be null ( because I will be appending values in it via process model as part of logic later ) While deploying I am passing nothing in the custom properties file  eg :   content._a-0000ed12-853e-8000-9c18-011c48011c48_2772176.VALUE= But when seen in higher environment it comes like this :  I wanted it to be blank ( i.e. nothing in the constant ) .. somewhat like this :  Is there any way we can achieve this via custom properties ?

How can i check what value appian returns?

If a user belongs to two different application groups and both the groups are added to user start page (different application), which application start page will they see after logging into Appian?

I'm trying to delete using a delete action inside interface using a stored procedure because I also need to delete related data from other tables. However, I'm facing an issue: the entity is successfully deleted from the database, but it still appears in Appian. I have a subprocess that runs after the stored procedure to sync all the updated tables, but the entity remains visible in Appian until I manually trigger a sync—after which it disappears as expected. Does anyone have any idea what could be causing this issue? Any insights would be greatly appreciated! here u can see the main subprocess sync : and an example of one subprocess sync:

Hello, Previously, in v24.4, I was able to configure a data source for SQL Server. Now, in v25.1, I can't. Any suggestions? Here the error: Thanks in advanced! Allan

Hi, I'm new to Appian and apologies if I missed something really obvious.I'm running into an issue attempting to capture selected choices and their respective labels of an a!multipleDropdownField(). I've declared 4 local variables to hold the list of available choice labels, available choices, selected choice labels and selected choices. a!localVariables(  local!arrChoiceLabels: {"Option1", "Option2", "Option3"},  local!arrChoiceValues: {1, 2, 3},  local!arrSelectedLabel: if(    a!isNullOrEmpty(ri!rec.selected),    {},    split(ri!rec.selected,";")   ),  local!arrSelected: if(    a!isNullOrEmpty(local!arrSelectedLabel),    {},    wherecontains(local!arrSelectedLabel,local!arrChoiceLabels)  ), Then I tried to plug them into the multiple dropdown field,  a!multipleDropdownField(    choiceLabels: local!arrChoiceLab

Hi all, For context, I'm trying to display a record type "Files" which as of last week has hit the memory threshold (800,000+ records). The record type is still legacy. When I try to access the record via Tempo > Records > Files, I'm displayed with  "The Requested Record Type Is Not Available An error occurred while retrieving the data for "File". Details: Unexpected error executing query ...." I've tried a few approaches but the most noteworthy one is  :  1) Updating the default filter criteria to only show Files that were created the last 2 years. The problem with this is if I need to access something older than the 2 years I won't be able to. In short, I just want to limit the Record List view to maybe 200 records but the data source having access to all 800,000+ records so that I can still have a functioning record that can display the appropriate views when accessed individually. Thank you.

So I have a process where a user uploads a .csv or .txt file with numbers. Those numbers are then extracted and ran through various validation checks. When a user uploads it in a .txt file, no issue. When it's a .csv file, the very first value, a fn!char(65279) is always added before it, so it's failing the validation check. Like so: When I copy the expression and paste it into the rule input of my validation expression rule, that first number always fails the validation check. But if I remove the fn!char(65279), it passes and works. A quick google search showed me that this is some sort of whitespace character. So I tried adding trim() to the variable that hold each individual extracted number, but that doesn't appear to make a difference. Does anyone have any idea? To either prevent that char from being extracted with the data, or to remove it after extraction? Thanks for any help.

Hi everybody!I am getting a weird error when I try to select a connected system to create an integration object. As soon as I write anything on the connected system field: I get this error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 87317:f0efe] : Unable to find Connected System Template with the id "plugin.[uipath-connectedSystem-rwm].[UiPathConnectedSystemTemplate]@2" I don't understand why the error mentions a plugin as we are not using any plugin for integrations/connected systems.Has anyone seen anything similar?Thank you

I have made changes to the custom.properties file, specifically:appian.feature.selfManagedMonitoring=true. I validated and deployed the changes, and also restarted the server after deployment. However, upon checking the configure.log file, the configuration changes are not being reflected.

Good dayI have robotic process, that uses the e mail to send notifications and retrieve information from the mail body or the attachments. Today by the morning, i am notified that the robotic process arent reading the mail. i'm Using this dependency com.sun.mail javax.mail 1.6.2 I'm using this process:public ArrayList getTodayNewEmails() //throws Exception { //EmailInfo toReturn = new EmailInfo(); local_server.info ("Obteniendo los correos nuevos de hoy..."); ArrayList messagesList = new ArrayList(); Properties props = System.getProperties(); props.put("mail.store.protocol", "imap"); props.put("mail.imap.auth.plain.disable", "true"); props.put("mail.imap.host", host); props.put("mail.imap.port", ""+port); props.put("mail.imap.ssl.enable", "true"); props.put("mail.imap.starttls.enable", "true"); props.put("mail.imap.auth", "true"); props.put("mail.imap.auth.mechanisms", "

Hello, I have a question about SharePoint integration. I have created a connector between appian and sharepoint, where I am trying to use one of the possible operations which is adding a document. To add a document it is required to provide the destination path of the folder and also the document itself. The problem is that despite the fact that I got write and read permission from the administrator for all objects on the page, I still get error: SharePoint returned a 401 HTTP error error-result-guidance SharePoint returned the following information: A potentially dangerous Request.Path value was detected from the client (?). Tank you, Michael

I am trying to fetch document metadata from sharepoint Integration which I have bult using pre built sharepoint connected system by appian. As I am retrieving the data I could not find the document data for its size, extension etc how can I achieve this as  I need the data to store document information in table.

Hello! I am playing around with the PDF tools plug-in and I was wondering if there is a way to create tables using the Create PDF Smart Service. And if so, do you have any example? Thanks in advance!

Hi Everyone,  I recently attempted the Appian L2 certification but unfortunately did not pass. I've been studying using Appian Community videos, documentation, and the official exam objectives. To further enhance my preparation, I'm seeking specific documentation links and topics that are directly relevant to the L2 certification. This will help me verify if I've missed any crucial topics. Additionally, I would appreciate any recommendations for mock exams or practice scenarios focused on senior developer-level questions.  

I have added the Wyndhamm Power Outage app from the App Catalog, then I need to add my user to the Technicians group but this group doesn't exist. The Appian Community Edition is on a later version - 24.4 - and the exercise is based on 24.2 version. In Security Summary a warning is detected: "Missing administrator group. No basic users will be able to administer these objects, which includes editing their security or deleting them".

Hi team , In SFDC integration , we are using SOQL query in operation to fetch some data for a given financial id , need to understand how to write the query to fetch data for multiple values involved.Current implementation - concat("select Id, Name, Reference_Type__c, System__c, Seq__c from SRS_Service_Request_Related_Order__c where RO_Service_Request__c " ,"='",ri!serviceRequestNo,"'");How to write above for fetching data for multiple financial id's involved , ri!serviceRequestNo will be of multiple type of string . Tried to replace above = with IN operator in where clause, it shows malformed SQL as integration error.Thanks

I have an odd problem.  I have a read only grid what shows a value one way on the interface, but differently in the excel download. Here is what you see in the interface vs the excel spreadsheet. Here is the offending code in the Grid. a!gridColumn( label: "Residential Status", value: rule!CMS_GetCurrentResidentialStatusId(fv!row['recordType!CMS Clergy Member Status Report.fields.clergyId']) ), Here is the expression rule. a!localVariables( /* * Get list of current resendential type addresses for clergy member * ordered by start date */ local!residentialAddressData: a!queryEntity( entity: cons!CMS_ADDRESS_CLERGY_ASSIGNED_ADDRESS, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field: "clergyAddress.residentialStatus.status" ) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", logicalExpressions: { a!queryLogicalExpression(

Hi team , In SFDC integration , we are using SOQL query in operation to fetch some data for a given financial id , need to understand how to write the query to fetch data for multiple values involved.Current implementation - concat(Select shareclass_c from breakdown_c where financial_id= ' ''' ,ri !finId) ;How to write above for fetching data for multiple financial id's involved , ri! finId will be of multiple type of string . Tried to replace above = with IN operator in where clause, it shows malformed SQL as integration error.Thanks 

Hi ,  We need to implement a requirement that limits the number of concurrent sessions per user. For example, if User A logs in through Session 1 and then attempts to log in on another device via Session 2, Session 1 should be terminated. Ultimately, we want only one active session per user at a time. The "Limit Number of Concurrent Sessions Per User Account" setting will allow a minimum of two sessions, but instead of terminating the first session, it will trigger an error when attempting to log in with a new session. is there any way to achieve this functionality? . The Application is on premise 24.4

Ran into an issue where any writes to record A were failing because record B had a sync issue. Record B was the Event Type Lookup for Record A, which was why record A writes were failing. The error in our logs is below: It sounded like the issue here: (+) Appian Community, however the difference was that our scheduled daily sync for record B passed just that same morning. No updates were made to record B, and no new data was added to record B recently enough to cause the issue. In addition, while there was a warning icon next to Sync History for record B, there was no history of any failed syncs, and once I manually synced, the error and issue went away. I'm not sure what happened how to go about checking what kind of invalid data popped up. Anyone ran into this before? TIA

What is the main difference between a!queryRecordType, a!queryRecordByIdentifier and a!recordData. When to use a particular one?