Discussion Categories

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?

a!isUserMemberOfGroup( username: loggedInUser(), groups: cons!IP_GRP_RECRUITERS ) So this above code i gave it so that that particular field is visible to the specific user from the specific group only, but its not working when i gave it in a read only grid. This code did work in the normal interface and it only showed the particular field to the particular user of specific group only , but when i gave it in the read only interface, its not working. What anyone help me with what might be the issue.

Is there way in prompt builder to pass it a document to reference? example: Based on the policies in Document_XZY does the data being passed in in Json format appear to be against any of the documented policies?

While working with a!dateField, I observed that changes to the selected date are only registered if the user updates the day first, followed by the month, and then the year. For example, if the initial value is 1/1/1994 and I attempt to change only the year to 1995, the update does not take effect. To successfully apply the change, I must reselect the day.Did anyone else came across this issue earlier?

Hello Everyone, I have a read only grid component with  20 rows of data and  displays 5 rows for each page with id and product price. How can we add a logic to display the sum of the data  display on bottom of the page for read only grid for each page. a!map(id:1,price:1234), a!map(id:2,price:1243, a!map(id:3,price:1234), a!map(id:4,price:1243), a!map(id:5,price:1234), a!map(id:6,price:1243), a!map(id:7,price:1234), a!map(id:8,price:1243), a!map(id:9,price:1234), a!map(id:10,price:1243) In grid ,we need to display the values  for sum of 1st page  1-5 values, 2nd page  6-10 values ,3rd page 11-15 values.  Thanks Saidivya Minna,

We are updating an old application from CDT/DSE to Record Types.  In a certain process a parent record is written, then child records are generated with foreign key values for the parent and they are written.  This is all done with the existing CDTs and DSEs.  The data propagates to the new Record Types as desired. However, we have a business critical sync filter on the Child record type that is intended to prevent certain statuses on the parent record from allowing anyone to find related children.  This filter is not being applied by the data propagation feature.   Believing that perhaps it was a syncing issue, I tried using the Sync Records smart service in various combinations with both the Parent and Child records.  Syncing the Child records, then the Parent, then I tried the Parent first and then the Child.  Nothing worked. It is my belief, that the Sync Records smart service is not sourcing the Related record when applying the sync filter.

Hello, I have a use case where I need to create a process model scheduler to send notifications to users whenever a Network Milestone is updated. This process model is scheduled to run daily. I have designed the process model and used queryRecordType() to fetch the required data. However, I’m facing a challenge since queryRecordType() can retrieve only 5,000 records at a time, but my dataset exceeds this limit. Could you please suggest how I can handle this scenario in the process model to fetch all records? Thanks,

How to get end of business day date and time based on appian process calendar? Kindly help me with this, Thankyou

Hi everyone, We’re currently in the design phase of a large-scale Appian BPM implementation for a bank. Appian acts as the backend processor for multiple business domains — including Loan Origination, KYC, and more — with all front-end channels (like CRM) integrating via Kafka events. To give context, here’s a simplified version of the incoming JSON payload from CRM to our Appian BPM: Our Design Question We’re wondering whether our database design should mirror this JSON structure, or whether we should use a normalized model that separates document references into a central table. To scope the question further: We’re using a DMS (Document Management System), and every attachment UUID points to a file stored there. Documents can belong to any entity (Applicant, Collateral, Product Info, etc.), and multiple documents can be associated with each entity. Processes vary, and different document types may be required at various stages (requested from the C

. Getting error while executing . Pls advice where i am making mistake configuring

I have a read only grid interface whose source is record data (API backed record). Record holds 3 million data which is one time sync .  If I need to implement two custom picker fields for two columns (ex: Year & Name, max selection is 5 ) and grid should reload even with combination filter as well.  Please drop your suggestions to implement this without affecting the performance much.