Discussion Categories

What are the steps involved to migrate appian from on-prem to cloud.

Hi everyone, I’m a PhD student researching low-code development. It’s impressive to see more and more people discovering low-code and no-code tools and using them in their work. I recently completed a study in collaboration with a consulting company that provides low-code solutions to its clients. Through interviews, I learned that many people without formal software development education are now able to step into this field thanks to low-code platforms. For many, this has created new career opportunities and pathways into tech. I also noticed that consulting firms often play an important role as partners of low-code vendors, acting as a bridge between platform providers and client companies. Beyond these observations, I’m interested in understanding how developers themselves feel about working with low-code development platforms—both the benefits and the challenges. Based on the collected responses, I found Appian was one of the most mentioned platforms. I beli

Hi Everyone, Is there any way or smart service to generate the .MSG file whenever receive an email to Appian . We know, there is smart service eml and msg conversation plugin but would like to do it in one step and don't want to dependent on the too many third-party plugins. Also once generated the .MSG ,need to read and  display in the UI screen . Please let mw know, Any implementation around it. Thanks!!

Hello! When it comes to AI tools in the context of automation testing (e.g. AI generation of automated tests, AI automatically fixing broken locators after a change, etc.), what support, and compatibility from/within Appian is expected currently and in future?

Hi Team, We are using Kafka Tools plugin to utilize consume and Publish Kafka services. We can able to perform publish Kafka service without any issues. But when comes to Consume Kafka we have questions as follows, Consume Kafka service shows isSuccess output as true but it didn't received Kafka server. To find reason which log we should check? What is the difference between Group ID and Topics? whether we have to pass both as same? Deserializer Class Name field is not mandatory? if we pass "io.confluent.kafka.serializers.json.KafkaJsonSchemaDeserializer"  as deserializer it throws error like io.confluent.kafka.serializers.json.KafkaJsonSchemaDeserializer not found by com.appiancorp.cs.plugin.kafka [50] And in the process model, why TM_Transaction variable is not populated with value after consume Kafka service showing it is success?

  a!gridLayout( labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Reference Number"), a!gridLayoutHeaderCell(label: "SiteID"), a!gridLayoutHeaderCell(label: "Activity"), a!gridLayoutHeaderCell(label: "Structure Type"), a!flatten(a!forEach( items: local!TaskParagraphCDT.TaskName, expression: { /*a!gridLayoutHeaderCell(label: fv!item & " Status"),*/ a!gridLayoutHeaderCell(label: fv!item), } )), a!gridLayoutHeaderCell(label: "Rule"), }, columnConfigs: {

I have connectedsytem with  authentication type as OpenIDConnect .I want to deploy it to QA but I don't see the any keys in property file .Can I deploy it directly without property file?can someone please help .Thanks!

I am using AIKnowledgeAssistantField() smart service And here I want the history of the queries asked and the response got from the AI AssestantWe have a field to capture the history i.e "conversationValue"But how to we use if is not properly mentioned anywhere My requirement it to upload the document and ask few queries related to the document and then capture the Audit history so i want all the queries and the responses saved somewhere.I tried using Document Chatbot but there also i did not find a way to save the history or there are any logs that have been captured. If its not possible in AIKnowledgeAssistantField is there any other way we can get the Audit history 

Hi,      We want to surface/view (not store ) salesforce documents in Appian . We already have an Salesforce connected system , we uses  SOQL integrations to expose the data points . I was just wondering can we use SOSL with the same connected system to return the documents (using RETURNING Document clause in SOSL).  Not sure whether SOSL can return docs . Or we need integrations with salesforce REST api to get the documents in Appian . Our users just have to view the documents on demand. We don't want to save them as Appian docs. Can anyone worked on similar use cases . Your inputs will be appreciated. Thanks in advance, Mike 

Hi everyone, We're building a bi-directional integration between Appian (BPM) and an external multi channels systems CRM, Mobile, Kiosk, Corebank etc. We have two architectural approaches and are looking for insights or best practices from the community: Approach 1: Task-ID Driven • CRM receives a generated Appian task ID via API • CRM later calls a second Appian API to complete that specific task by its ID Approach 2: Event-Driven Integration with Correlation ID (Using Appian Events) A shared correlationId (UUID) is generated and passed between CRM and BPM. Appian subprocesses register to Receive Message Events or wait via correlation-aware logic. CRM communicates by sending events (e.g., KYC_COMPLETED, DOCS_SUBMITTED) using a unified API. Appian routes events internally using correlationId + eventType. What I'm Looking For: Is there an Appian-recommended best practice for choosing between task-based vs event-driven integrations? Are Receive Message Events and cor

Before Importing an application and properties file, Can we pass the value of a data store in the properties file like ##TestDS content.a_<uuid>.VALUE=jdbc/TESTDS  can we do this ?

I have a scenario where I need to  create a pie chart based on a record type for example cmgt_task.I want to show two datas in a pie chart (20%-80%),one having due date as today and completed on as today date and other one will be all open work items that is having due date as today.How can I proceed with this,like do i need to do two seperate queries or it is possible to implement using one query using aggregation.Kindly help me with this scenario ,If I can do it through aggregation then how can I will give different filters for thsese two  datas1.all the completed work items having "due date" as today and "completed on" date as today.And also "is completed "as true and "status" as completeda!queryFilter( field: 'recordType!{ee5aa46d-0228-430f-a794-1134a11fbcc0}CMGT_Task.fields.{3d96454c-776f-4b29-9413-d7fffa3ebaeb}statusId', operator: "=", value: cons!CMGT_REFID_STATUS_TASK_COMPLETED ),

I need to create a dynamic DOCX document that includes a table with 11 columns, where each column should automatically adjusts its width. I have attached a code snippet that generates a DOCX document with a table showing only 8 columns. The remaining 3 columns exceed the page width, so they aren't visible. Please help me to fix it.   SAP Number Part Number Description Manufacturer Group Spare Qty Delivery Date Price Total Remarks ", a!forEach( items: local!selectedEquipments, expression: concat( "", "" & fv!item.sapnumber & "", "" & fv!item.partnumber & "", "" & fv!item.description & "", "" & if( a!isNotNullOrEmpty(fv!item.manufacturer), fv!item.manufacturer, "--" ) & "", "" & fv!item.group & "", "" & if(fv!item.spare, "Yes", "No") & "",

Hi Every one, We are getting similar issue mentioned in -  [mention:60d851851e654d28b5c4a0dae2c486c7:46448885d0e64133bbfbf0cd7b0fd6f7]  We are getting 2 times the status code in postman and also when it goes to front end (UI part not a Appian - it is build in adobe cqms ) the status code is coming as duplicate for both the success/failure case. webapi- code Can any one  help and let us know, why are getting  this issue . Any help would be appreciated.

In my Appian environment, I’ve noticed that some groups have UUIDs that start with SYSTEM_GROUP_ followed by the group name, instead of the usual alphanumeric UUID format.How can I logically identify or classify these groups separately from regular groups?  When I use scimGetGroup() on these SYSTEM_GROUP_ groups, it doesn’t return any group attributes, unlike the other groups with standard UUIDs.Is this expected behavior? And is there a workaround to retrieve attributes for these system groups?

Product: Apryse WebViewer Component Plug-in Product Version: 5.5.1 I am using Apryse webviewer in Appian for document comparison. I am passing 2 appian doc id as parameters. But as soon as the interface is loaded it shows " Error while loading document ". But when I am manually uploading the two doc it works fine. Here's the screenshot of the error. . This is the code used for apryse webviewer ... webviewer( label: "WebViewer", labelPosition: "ABOVE", validations: {}, height: "AUTO", hidden: null, key: null, url: null, serviceAPIKey: null, appianDocId: { 224563,788333 }, preflattenDocuments: null, documentFolder: cons!FOLDER, uploadChunkSize: null, userDisplayName: null, enableReadOnlyMode: null, enabledElements: false(),

Is there a built in function for fuzzy match in Appian?

Hi Team, we are trying to implement record field validation through applyvalidation function , its not it working as expected, please refer below screenshot, this is the screenshot of pre-configured validation code  in UI we tried to implement validation but it didn't worked as expected , as shown below, please suggest if missed anything configured. Note: I have tried this logic appian community edition thanks in advance

In the grid I am getting the same plan name whatever plan I select in the dropdown , Can anyone help me fix this? a!localVariables( local!wmsPlans: index( rule!WMS_qr_Plan( columns: { 'recordType!{a64248d4-beb2-46af-9f5f-eb0f79b17649}WMS PLAN.fields.{f39ad615-5340-4968-8dd2-3b4d81474095}planName', 'recordType!{a64248d4-beb2-46af-9f5f-eb0f79b17649}WMS PLAN.fields.{a8baeebc-1ffb-4f0a-9096-d148777d3756}planId' }, clientId: 11, planStatus: "Active" ).data, {} ), local!vetRequestPlans: index( rule!VET_qr_RequestPlans_ByFilters(requestId: 1188 ), {} ), local!additionalCITplans, local!plansSelected, local!editablePlans: if( length(a!flatten(local!plansSelected)) > 0, reject( fn!isnull, { a!forEach( items: local!vetRequestPlans, expression: if( contains( local!plansSelected, fv!item['recordType!{9339afa7-3440-42ac-9d18-6e89a7

I noticed a behaviour , just curious to understand more details if anybody knows Using API backed record for read only grid,   case1:- For data: a!recorddata() was used and  action was configured as below       a!recordActionField(         actions:a!recordActionItem(                     action: 'recordType!myRecord.actions.myAction',                     identifier: fv!identifier case2:- For data: a!queryrecordtype() was used and  action was configured as below       a!recordActionField(         actions:a!recordActionItem(                     action: 'recordType!myRecord.actions.myAction',                     identifier: fv!row[recordty

We have deployed a table to higher environment  and used in required objects to perform operations, we want t o add 2 columns to it . How can we achieve this , also will there be any impact on the objects as its already in higher environments .

We are getting the following error every minute in the stdout.log. java.util.concurrent.ExecutionException: com.appian.data.client.AdsUserInputException: APNX-3-1100-022: Query target must be a valid table reference. Invalid: "df_records"."10414987-1995-45eb-9baf-eebaf764386a_live" at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205) at com.appiancorp.record.query.ads.ComplexSyncedRecordQueryRunner.runQuery(ComplexSyncedRecordQueryRunner.java:156) at com.appiancorp.record.query.semanticsearch.LowLevelSearchDecorator.runQuery(LowLevelSearchDecorator.java:46) at com.appiancorp.record.data.sourcedataaccessors.RecordReplicaDataAccessor.lambda$getRecordsInner$2(RecordReplicaDataAccessor.java:132) at com.appiancorp.record.data.sourcedataaccessors.RecordReplicaDataAccessor.getRecordsOptimistically(RecordReplicaDataAccessor.java:176) Sync has not been scheduled for the record. (UUID:

I know this question might be a little different and weird than any other here before, I was just re-structuring my resume and i just wanted to know as what all technical skills i can add in my resume as an Appian Developer. I would be pleased if any senior of mine from here would help me out a little with that small issue of mine.

Hi Everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8] Scenario: I have a scenario where 150 columns to be exported as excel. Limitations:Using Export Data Store Entity to Excel, it supports only 50 columns. Solutions tried: Tried using multiple Export Data Store Entity to Excel with different Starting Cell (A2,AY2,BY2). Issue: The excel sheet is updating only with the last Export Data Store Entity to Excel Data. Previous Node data are getting erased. What is needed? I need all the 150 columns to be updated in the same Excel Sheet(Single sheet).

I have a scenario where I need to  create a pie chart based on a record type for example cmgt_task.I want to show two datas in a pie chart (20%-80%),one having due date as today and completed on as today date and other one will be all open work items that is having due date as today.How can I proceed with this,like do i need to do two seperate queries or it is possible to implement using one query using aggregation.Kindly help me with this scenario ,If I can do it through aggregation then how can I will give different filters for thsese two  datas1.all the completed work items having "due date" as today and "completed on" date as today.And also "is completed "as true and "status" as completeda!queryFilter( field: 'recordType!{ee5aa46d-0228-430f-a794-1134a11fbcc0}CMGT_Task.fields.{3d96454c-776f-4b29-9413-d7fffa3ebaeb}statusId', operator: "=", value: cons!CMGT_REFID_STATUS_TASK_COMPLETED ),