Discussion Categories

We have a column in the Appian database table with data type as 'long text'. We want to facilitate storing and retrieving string around 8000 characters size in this table column. This will be a master data and will not be fetched in interfaces. (Also it may not always be 8000 in string length) But we will fetch this column in the expression rule for some evaluation and running rules. We are noticing that this column with long text is getting truncated in the expression rule when we retrieving the data. Our Record Type does not show any option to select "Extra Long Text" when creating a Record Type from this database table. This documentation indicates that we should be able to map the varchar or text to 'Extra Long Text' https://docs.appian.com/suite/help/25.1/about-data-sync.html Am I missing anything here?

Hi all, I am using the function a!startProcess() to trigger a process model from my interface. Is it possible to use the onerror parameter to show a custom message on the screen when the process fails to start or breaks for some reason. If it is possible can you please guide me how to achieve it ?

I have(had) an issue with a Selectable Editable Grid and I don't know if this is a bug or not. BUSINESS USE CASE I actually have two grids.  The Use Case here is to have the user assign a speaker to a parish for a parish event. One grid shows unassigned approved speakers and the other shows parishes that do not have a speaker.  There are two local variables that are loaded with this data; speakerEvents and parishEvents.  The user selects the Speaker, then selects the Parish before submitting the data. Here is the JSON for one of the grids. a!gridLayout( label: "Unassigned Approved Speakers", labelPosition: "ABOVE", emptyGridMessage: "There are no Unassigned Approved Speakers for this Event.", headerCells: { a!gridLayoutHeaderCell(label: "Speaker"), a!gridLayoutHeaderCell(label: "Type"), a!gridLayoutHeaderCe

Hi, I am trying to generate a CSV file from HTML(convert HTML to CSV plugin), but in the plugin's smart service, there is a parameter called 'CSS query' (text type). I am confused about what to put in that. Can anyone help with this? You will see this parameter in data --->input section

Hi All, Anyone who used Azure blob storage for storing unstructured data, could you provide some insights on its ease of integrations, maintainability and performance. Also, are there any other alternatives (apart from sharepoint and Appian document repository) for storing unstructured data?

The client has AWS Db with JWT AuthenticationThere is no JWT Authentication provided in appianHow can I connect with their AWS DB now ?

I am not able to enable the RPA agent from my system, I have followed all the instructions mentioned in appian documentation like JAVA_HOME setup, Certificates everything. One time it got enabled and and after that I am not able to enable it again so I have tried uninstall and install several times but no luck. Please see the attached log 2025-04-09 09:25:19,418|INFO|com.novayre.jidoka.client.JidokaClient.parseArgs:447|Using the default reset after long connection fault value: 0|main|0|242/4,096|2025-04-09 09:25:19,418|INFO|com.novayre.jidoka.client.JidokaClient.parseArgs:449|Using the default connection timeout value: 600|main|0|242/4,096|2025-04-09 09:25:19,418|INFO|com.novayre.jidoka.client.JidokaClient.parseArgs:450|Using the default lock runnable value: true|main|0|242/4,096|2025-04-09 09:25:19,418|WARN|com.novayre.jidoka.client.JidokaClient.readConfigurationFromPropertiesFile:652|An optional property has not been read: configuration.log.level|main|0|242/4,096|2025-04-09 09:25:19,

I have create a record type using a view, Which has more than a million data.But in performance im getting the below error "Expression evaluation error [evaluation ID = a8853:4ed82] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.. (APNX-1-4198-000)"

I want to generate an excel document by using "JSON To Excel Converter" in process model. Even though I am passing JSON correctly I am getting the below error error:

A task is assigned to a group.One of the user from the group accepts the task and be idle (do nothing, performs no action).After one hour the task should be reassigned back to the group.Please help here on how to acheive this?

I have two or more dropdown component and I hope that these dropdown components can share one choice list. For example I have a list like {choice 1, choice 2, choice 3, choice 4,...} In dropdown 1 the choice list should be  {choice 1, choice 2, choice 3, choice 4,...}, when I choose choice 1 in this dropdown, the choice list of other dropdown should be  {choice 2, choice 3, choice 4,...},  when I choose choice 2 in dropdown 2, the choice list of other dropdown (expect dropdown 1 and dropdown 2) should be {choice 3, choice 4,...} Can appian do like this?

Hi there! I am using this process. When CSv file is generated, it starts from row number 2. Can anyone please guide me how to set row 1?

I need to start a process using an email trigger. Is there any way to configure this process model using the Process Model Properties dialog? Thanks in advance.

Hi Process was getting errored saying the error like a!fromJson: Invalid index: Cannot index property 'body' of type Text into type Text) (Logic Output) in appian in the output of node passing the logic like below  tointeger( index( a!fromJson(it was integration:rule!UIP_GetQueueItemBy( OrgsUnitId: 100, reference: ri!reference (type of rule input reference is text) ).result.body ), "@odata.count" )) > 0 Kindly suggest on this for some instances it was working well for some it was erroring like above

Sure, here's a clearer and more structured version of your text: Hi Everyone, I have a requirement involving two tables: Tyre Data Table: Columns: TyreID (Primary Key), PartNumber (Foreign Key) Country Restriction Table: Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive (Boolean) These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries(all remaining rows). Export Requirement: We need to export the data in the following format: PartNumber Country1 Country2 … Country150 12345 1 0 … 1

I'm currently using embedded interfaces with Appian on cloud, but I will migrate to on-premises. Can I keep using them after the migration?And to migrate my applications from cloud can I simply export and then import them on premise, or is not that simple? Thanks!

Can we send hidden process variable data to sub process?

Hi, We have a custom email notification configured for a task and this is done using the tp!id parameter. the Task URL that gets generated looks like: /suite/tempo/tasks/task/<task-id>. When the user gets the task assigned and opens it from the tasks tab, it works fine. The URL for this contains the opaque task id. But when the user open the task via the custom email (tp!id), the task throws the error: The Requested Task Is Not Available The task may not exist or you may not have permission to view it. The same code works in one of our Appian environments - version 25.1.286.0 and it doesn't work in the environment - version : 25.1.236.0. Any idea if this has got anything to do with the Appian version? Thanks

I have an interface where a user is able to click on several choices in a checkbox. Each selection is stored as a separate row in a data table that is linked to their user data.  Adding new choices is easy as you just write a new row for that box. Removing them is a bit more tricky. Is there a standard best practice for this row addition/subtraction process? 

Hello, I have this interface where there is a grid that shows uploaded attachments and a button to refresh the grid whenever there is a new attachment uploaded. I am running into an issue where if the user clicks on "Refresh existing attachments" when the grid is empty, then uploads an attachment, the refresh button no longer refreshes. But if they upload an attachment and click refresh after utilizing the action, it functions as expected and the attachment shows on the grid. I am trying to cover this scenario in case a user for some reason decides to click refresh before uploading and the grid is empty. Thoughts?  a!localVariables( local!readonly: a!isUserMemberOfGroup(loggedInUser(), cons!FRR_viewerGroup), local!existingFolderId: if( isnull(ri!requestId), null, rule!FRR_GET_requestFolder(requestId: ri!requestId) ), local!existingAttachments: a!refreshVariable( value: if( isnull(local!existingFolderId), null, folder( l

Hi Do we have any plugins for below requirement, Tyre Data Table: Columns: TyreID (Primary Key), PartNumber (Foreign Key) Country Restriction Table: Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive (Boolean)These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries. Requirement: We need to export the data in the following format: Part Number|Country1|country2|.......country150 12345 | 1 | 0 |................|1|

Hi I have written this query to fetch result based on two filter criteria. When I am passing either of employeeId or Created by it throws the following error. But if I pass both employeeId and CreatedBy it works properly. Can anyone help as in what is wrong in this? The error: The code: rule!NGS_queryEntityRefresh( dataStoreEntity: cons!NGS_DSE_QPP_PERFORMANCE_TRACKER, returnType: ri!returnType, executeWhen: ri!executeWhen, queryLogicalExpression: a!queryLogicalExpression( operator: "OR", logicalExpressions: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "employeeId", operator: "in", value: ri!employeeIds, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "discussionTopicRefId", operator: "in", value: ri!discussionTopicRefIds, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "discussionSubtopicRefId", operator: "in", value

Hi I have a requirement involving two tables: Tyre Record Tye Columns: TyreID (Primary Key), PartNumber (Foreign Key)Country Restriction Record Type Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries. Requirement: We need to export the data in the following format: Part Number|Country1|country2|.......country150 12345 | 1 | 0 |................|1|

We're in the design phase of creating cross-channel communication for business processes. We use CRM, Mobile, Kiosk, and other channels to send and receive messages to and from Appian. Our goal is to develop a web API that enables message exchange between the various channels in our ecosystem. Outside of Appian, we have a solid architecture for data flows and event-driven management between these microservices. We're interested in learning about best practices for determining the target process ID in the receive API. We use the correlationId as a consistent key across all channels to avoid exposing internal IDs. After a process starts, we store the correlationId in a process variable. There are several approaches to obtaining the process ID using the correlationId, but we're looking for the best solution. One approach I've found is to create a process report to filter by the process variable. However, this would require creating separate process reports for each case.

I have requirement where I need to export data of the editable grid but issue here is I will be able to it in read only grid with help of parameter showexport but how to do it in editable grid.