Discussion Categories

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 ),

I am not sure it is a basic or i am missing a point . We're working with a multi-interface navigation in Appian (6 interfaces navigated via buttons). When a user clicks a button to go to the next interface, the interface loads correctly, but the page does not scroll to the top. We do not want to use a process model with chaining to reload the form. We also tried using formLayout(focusOnFirstInput: true) but that didn’t help. How can we make the form automatically scroll to the top on each interface load using only SAIL/interface logic? Setup :headercontent layout hosts - header, contents {two interfaces}.interface1 have 2 columns , first column hosts navigation and other one hosts subinterfacesinterface 2 have buttons : Go Back , Save & Continue How it works:On the first page (interface), the user fills out the details and scrolls down to click the "Save & Continue" button. When clicked, the navigation counter increments, and the user is taken to the next pa

Hi Everyone, We have a way to use a Record type designed to have a database view as data source into a Records Chat Component? local!data: a!queryRecordByIdentifier( recordType: 'MY RECORD WITH DATABASE VIEW AS SOURCE HERE', identifier: ri!id ), a!recordsChatField( recordType: 'MY RECORD WITH DATABASE VIEW AS SOURCE HERE', identifier: ri!id, height: "TALL", initialMessage: concat( "For this instance of ", local!data['MY RECORD WITH DATABASE VIEW AS SOURCE HERE.fields.{processName}processName'], " process, I have the following data available: " ), suggestedQuestions: { concat( "When this instance was created?" ), concat( "What is the instance deadline?" ), concat( "What is the process version of ", local!data['MY RECORD WITH DATABASE VIEW AS SOURCE HERE.fields.{processName}processName'], " instance?" ) }, fields: { 'MY RECORD WITH DATABASE VIEW AS SOURCE HERE.fields.{instanceId}instanceId'

Hello - While going through the online Developer course, "Design Record Types: Model and Configure Your Data", I completed the course and survey, assuming I could go back into the activity.  However, now I am unable to view the activity, which will make the future steps unavailable to me.  Can someone please point me to a PDF of this step so I can complete it? Thanks in advance,  RaviG

Hello everyone.I'm using the web content field in Appian. I want to display a site, but when I add the URL, it says the site is refusing the connection. In the example image, I added the Appian page.I'd like to know what settings I should make on my end, or if the settings are for the server where the site is hosted.

Hi, Facing below error while executing the Expression rule - Expression evaluation error in rule '<Rule Name>' (called by rule '<Rule Name>') at function 'reduce' [line 10]invalid index: Cannot index property 'status' of type String into type list) (Data Outputs) The expression rule code is  cast( typeof(ri!cdt), reduce( a!update(data: _, index: _, value: _), ri!cdt, merge(ri!fields, ri!newValues) )) Please help what is missing. Thanks in advance

Hello Team, I have a requirement to rename the local file with dateandtimestamp on some condition.  Input file name - test.csv expected renamed filename - test.csv_16072025 I am using "Edit Document Properties" smart service and it is renaming the file name. so the output is like test_16072025.csv.  Unable to get the extension renamed. How to achieve this? can anyone suggest here?