Discussion Categories

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.

I am using appian-locust to perform e2e load testing. When I form.click_record_link(label="Related Actions", locust_request_label="Any") I encounter following error  msg, Type of record link and label are found but on different component. How to solve this kind of problems? Seems we are bound by whatever appian-locust gives us.

Dear Team, I am writing to request assistance with configuring Content Security Policy (CSP) in the httpd.conf file for our Appian application hosted on an Apache web server. We aim to enhance our application's security posture by implementing a robust CSP to mitigate risks associated with script-based attacks such as Cross-Site Scripting (XSS). Below is the  CSP configuration  which i get on the application  Content security policy : report-uri /suite/rest/a/logging/latest/csp/report; report-to report;  is there any way to mitigate the issue 

Hi All I am working on version 24.3. I have started exploring Appian AI capabilities and to start of with I find a!recordsChatField() a great component to provide to the user. So as a use case; I have a record which has user filters available. I want to use a!recordsChatField() so that we can provide better experience to the users so that they can use natural language to get filtered records rather than using user filters of records. I have gone through the forum but didn't find any handy tutorial which provides practical example of using the a!recordsChatField(). The only thing i was able to find is the document for the component: https://docs.appian.com/suite/help/24.3/Records_Chat_Component.html Can anyone please guide how can I use this field. Any link to academy online for the same will also be useful.  Thanks in advance!!

I have a working hours set to 8:30 AM to 7PM EST, it should calculate only these hours for business days and remaining non working hours or non business days should not calculate.Example: requests submitted only calculate from monday-friday 8:30 AM to 7:00 PM ET. A request created on sunday 3PM. the clock starts at monday 8:30 AM A request created on Tuesday 6:45 PM. the clock starts at tuesday 6:45 PM/ pauses at tuesday 7:00 PM/ resumes at wednesday 8:30 AM. Earlier we had a plugin called calendar functions but now its archived, is there any other alternative way to do? 

I have created a service backed record type where my source is a sharepoint list. The record type is sync enabled. New record is added or updated frequently in a day so a daily sync is not enough. The client wants to have an option to trigger the sync manually via a click of a button. So far i have configure sync optionThe problem is only the existing record in my record type gets sync for updates made in sharepoint list but the new item i created in sharepoint is not sync in my record type.

We have a structure in db with an id, INFO, fatherID, level I have to given an ID, have to reconstruct all the Hierarchical Structure under the Given ID The Structure is a Three                                                                                           /------------ID1------------\                                  ID2[fatherID:ID1]                                                                               ID3[fatherID:ID1] ID4[fatherID:ID2] -/&nbsp

hi,  I been exploring End user reporting plugin the lower environments, While working in UAT, I came to know that record types configuration needs to be done in dev and then pushed to UAT. My question is ,will the plugin allow the EUR admins to configure the record types in Production environment, instead of pushing from lower environments.  Documentation says that we have to configure the records from scratch in prod. 

Hi All, Got below error when trying to decrypt the csv file using PGP. Does anyone know what can be done to resolve this class org.bouncycastle.openpgp.PGPLiteralData cannot be cast to class org.bouncycastle.openpgp.PGPCompressedData (org.bouncycastle.openpgp.PGPLiteralData and org.bouncycastle.openpgp.PGPCompressedData are in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader 

Idle Session Timeout (Minutes): The number of minutes that a user can remain inactive before the system signs them out. Users will be warned five minutes before their session expires. After two more minutes, if the user remains inactive, they will be signed out. The minimum valid value is 10 minutes and the maximum valid value is 480 minutes (8 hours). Users get the warning before 5 minutes of system expiry and after 2 minutes, the user gets signed out. Can we configure this 5 and 2 minutes. And is it possible to configure the timeout message.

I have used this code in my interface with different approaches and get this error everytime . I have used this code inside form layout and other layouts as well . Use simple without any layout In record summary view  Try it in expression rule and use that rule in interface  Expression evaluation error [evaluation ID = 15a08:f572c] at function a!documentsChatField [line 70]: a!documentsChatField cannot be called from user rule (APNX-1-4198-000) { a!documentsChatField( label: "Documents Chat", labelPosition: "COLLAPSED", documents: ri!record[recordType!SMRT Document Collection.relationships.smrtDocument.fields.documentId], height: "AUTO" ) }is there any other approach we can use for this component in our interface or if there is any other code reference that will be really helpful.

One of our customers has a requirement to send messages to students. Currently, we use AT&T's email-to-text feature to send these messages via email. However, AT&T is deprecating its email-to-text and text-to-email services, which means we’ll no longer be able to send or receive SMS messages using email. We're looking for alternative approaches to achieve the same functionality within or alongside Appian.Has anyone faced a similar challenge or implemented a different method for sending SMS notifications from Appian? Any guidance would be greatly appreciated.

I created a service backed record type with sharepoint list as data source. The record type is sync enabled. New list is created or updated frequently from sharepoint list on a day. So daily sync is not enough. The client wants to have an option like a button to trigger sync right away. So far, I already configure sync option for the record type. And created a process model to trigger the sync The issue is only the records available in my record type gets sync on updates.But the record I newly created in sharepoint list dont get sync in my record type. Appreciate the help you could extend to me. Thanks

I replaced all the cdt to interact with the data using records. for some reason it is not saving the values in the database, nor in the process history fields. But if I check the variables, the values are correctly populated. Is there something I'm missing?