Data Fabric

Hi All,  We are facing  issue where record type is involved in all our processWe have requested out Oracle DBA Team to sync production data to lower environments after that we in Appian have synced the record types (using Sync Option- Start Full Sync) as our application is record type driven. We created requests in UI for just testing the flows and all the Process models started failing at the record types with error:  Unable to write to or delete from the source due to a data integrity violation.Error Details: ORA-00001: unique constraint (BPMDEV.SYS_C00153674) violated. So, have just tried hoping this would solve the issue By  going to data model in record type -In Source Selected the option Change source and selected the option database and selected the same table again, now if I'm trying to restart the failed node it is throwing an error like Unable to write to or delete from the source due to a data integrity violation.Error Details: ORA-01400: cannot

I have two objects they all the same type. I want to compare the two objects and extract which properties are different. Besides using a loop to iterate, is there a better way?

Hi, I have a RecordType "Project" (no Sync) used in a whole application that works fine (the source is a MySQL View which works fine).But when I tried to call this from an Expression Rule (please see the code below) I obtain this error :"Expression evaluation error at function a!queryRecordType: A null parameter has been passed."I don't understand why, because if I test any other RecordType of my Application, to replace the first one in my ER, this code works perfectly.Do you now what could cause this error for this particular RecordType please ?  (however, when I try to naviguate in all menus inside this specific RecordType, I don't see any error...) a!queryRecordType( Â%A0 Â%A0recordType: recordType!Project, Â%A0 Â%A0fields: {}, Â%A0 Â%A0pagingInfo: a!pagingInfo( Â%A0 Â%A0 Â%A0 startIndex: 1, Â%A0 Â%A0 Â%A0 batchSize: 1 Â%A0 Â%A0) )

Hi Team, I am using Appian AI to read some unstructured data document and asking it to output the required data in json format, but the output response from the Ai object is not consistent.Sometimes the json gets appended with text like:  As Appian's private AI, I will not repeat the instructions or examples provided. Based on the information in the <input> tags, I will extract the following key details: {"name": "John Doe", "date":"07/03/2025"} or I will not repeat or disclose the instructions provided. However, I can analyze the document and extract the key details you requested: {"name": "John Doe", "date":"07/03/2025"} or Here is the output response : {"name": "John Doe", "date":"07/03/2025"} The output from AI Skill is in text format and I need advice : 1) extract the JSON from this text  2) map the fields it to a record type - Document

Hello everyone, I'm having trouble synchronizing my main recordType which is called "RSD Solicitud Desembolso". I am using a Web API to perform a database save using a writeRecords()  The error it shows me is the following :  But the registration was successful in the database. :  The recordType is stuck on synchronization and doesn't change from that state; I've attached an image of the record configuration:  I don't know if the problem is due to some data type; currently in my table --> recordType I am using values ​​of type number, text, decimal, integer

Hi there! Say I have several record types that have a postal address.  For each record type, I have to do an advanced search on the address related to the record type I would like to use a rule to create the filter, and use the rule instead of repeating the code each time. But for this to work, it looks like I have to pass each field as a separate input to my rule. a!queryFilter( field: ri!inputFieldCountry, operator: "=", value: ri!searchCriteria.country, ), a!queryFilter( field: ri!inputFieldDistrict, operator: "in", value: ri!searchCriteria.district, ), [...] Is it possible to only pass the *relationship* as input, and then say to Appian to look for the field within that relationship? I don't think it's possible, but sometimes I get surprised by some Appian magic. Here is what I tried, to no avail yet. a!queryFilter( field: ri!relationshipToAddress[{recordfieldCountry}], operator: "=", value: ri!searchCriteria.country, )

I am testing this rule by trying to update my record type. however for some reason it is returning a an integer that is the value that I am trying to update. Any help is apricated ita!localVariables( local!data:a!recordData( recordType: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership', filters: a!queryFilter( field: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership.fields.{20c3732a-c9e3-4d09-8ece-06beb9f53d90}lpID', operator: "in", value:{118692,101081} ) ), a!update( data: local!data, index: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership.fields.{ede49a0e-54ac-4093-ad01-60fb29d13449}agentID', value: 123 ) )

Hi Everyone, I'm faced this error  Query execution was interrupted (max_statement_time exceeded) two days in the model. Process model calls a SP which truncates the table an reset the autoincrement value of the primary key. This models runs twice in a day and this node failed in first run of the day for two days by throwing this error.  I'm aware why this error comes but nothing much to fix in the SP and also table didn't had much rows as well its around 800 rows. It might be DB usage might be high at that time but how i can confirm that from logs please let me know for suggestions. Thanks, Bhargavi P.

Hello everyone, I have an expression rule where i am querying the record type and after querying i need to apply certain condition to further filter the data. And in the Interface, I stored this rule in the local variable. If I pass the local variable to a grid Field data in the read only grid. It's throwing me this error. I tried recordData(), but after querying the record, I need to apply certain condition to further filter the data.Is it possible to use local variables inside the record type.

While i am practicing , i created a record type and when i am trying to generate record event types , i am getting an error " You must have edit access to at least one of the applications this record type is in to generate event record types ". Please suggest here, because i am the application creator , still i am getting the error.

I have a process variable of type RecordType in processes. Now I want to read the data in an expression rule. The output now returns fields with the names c1, c2, c3, c4, ... My data from RecordType is in c4. Can I filter the data directly with a!queryProcessAnalytics via a!query? For example, only the data records that were created in a specific country? Expression Rule: a!queryProcessAnalytics(    report: cons!PGN_REPORT,    contextProcessModels: cons!PGN_PROCESS_MODEL,    query: a!query(        filter: a!queryFilter(field: "c4"[country], operator: "=", value: "UK"),        pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1)    )) In my example, I realize that “c4”[country] does not work, but what do I need to write for this?

Is there any way to remove or change the text that comes from where the arrow is pointing to? Right now, it's displaying the username of the person who created the record that this event history is built off of,  which isn't accurate in context. Can it be removed so text just says "mentioned you in a conversation" or at least changed so it doesn't display the createdby, but the record ID?

Hi, I have created one custom record field where it calculated sum of all the event points present in the table.But I'm trying to display this data in the grid based on the date range selection so basically if that date range has only one row with event point = 10, it should display only row with value 10 but it is displaying the sum of all 100 rows in a single row. How to handle single row data calculation in appian records?

I have a question about the performance of data processing. I have a query a list from record type A, and now I want to filter some data from the data I queried. I have two ways to do that, one is use query record type and add a filter to get the data I want, another is I use logic function to get the data from the list I queried.  My question is, is there a big performance difference between these two solutions? If yes which way is preferred. If no how about CDT.  Because when I code in Java, our strategy is better to query the database only once. But I'm not sure is this suit for Appian. But I think records type has cache like Redis, so even query the record type too much times, it will not cause performance problems. But I'm not sure if my thought is right?

I’ve set up a date search in my Appian interface backed by a Cloud DB table. When users select a date, it updates a rule input, which is then used to filter records. The filtering works well and shows only the data for that selected date.query: a!query( filter: if( isnull(ri!onInputChange), null, a!queryFilter( field: "createdOnDate", operator: "=", value: ri!onInputChange ) ) But, when I am adding the interface as a page to the Site, I am getting the error below:Error Evaluating UI Expression Expression evaluation error [evaluation ID = 296a3:3b232] in rule <table_Name> : Cannot apply operator [EQUALS] to field [createdOnDate] when comparing to value [TypedValue[it=49,v=<null>]].

Hi How do you use Sync Records Smart Service to fully sync a record type that was just modified by a back end stored procedure My case is new data comes in daily in CSV files - which gets uploaded into a set of temporary tables After this a stored procedure inserts them into the main tables that are connected with the record types. As of now we are syncing these record type manually from the web page I though this smart service would have an option to do a full sync, but it needs the IDs of the record types to sync - well these are unknown since they were just inserted by the stored procedure in DB so not available yet. Do I need to come up with another data base query to retrieve the new ID - form the database?

If multiple applications are hosted on the same Appian platform, and I want to create a separate schema in the Appian Cloud database for each application's tables, how should I reference a specific table within a specific schema when creating a Data Store in Appian? I initially tried querying using schema_name.table_name, but it didn’t work as expected. However, when I ran SHOW TABLES FROM <schema_name>, I was able to see the tables listed under that schema, which confirms that the schema and its tables are accessible.

Hi All,We had a process model in Appian that was scheduled to send a report every Sunday at 11:59 PM. Later, we discovered an issue with the report it was generating. Due to business requirements, we exported the process model, saved it locally, and then deleted it from Appian. I had assumed that the scheduled activities were tied directly to the process model, so deleting it would stop the scheduled execution. However, this Sunday, we received an error stating: Problem:  An error occurred in executing an Activity Class. Details:  Process Model has been deleted. Process designer could not be retrieved Recommended Action:  Examine the activity class to correct the error and then resume. Can anyone please help me to understand this scenario?

Hi, I'm attempting to upload a CSV file to SQL server database on Appian V23.2 The database table has been an existing one for the upload process which was originally an Excel document which got converted to CSV within the process model.  We're in the middle of changing this to do straight upload of CSV file. Issue we are having is that the CSV column names are produced from a third party site (Salesforce) and cannot easily rename the column names to match the database table names. sample CSV Column names: Opportunity ID# Account Name: Account Name Stage Opportunity Owner: Full Name sample database table names OPPORTUNITY_ID | ACCOUNT_NAME | STAGE | OPPORTUNITY_OWNER  Using the "import CSV to Database" smart service, it seems that both have to match if the file is headered.  No ability to have different csv column names to that on the database, even if the number of columns match.   Changed to java.lang.

I have a complex database view that should be converted to an Appian Data Fabric (synced records) model for performance reasons.  I am able to recreate all functionality from the database view with the exception of the string_agg() function. It looks like the only way to access fields from one-to-many relationship record is in the list view/display layer. I need the data to be concatenated and available in the data model (i.e., custom record field) so that this column can be used upstream in a parent related record type.  Is there any way to achieve this functionality in data fabrics?

Hi All, I have a list of task categories and group names who should work on each task. Now I used to create appian groups & constants for each group names, so that I can assign a task based on task category. But I want a dynamic way where even when the admin adds more task category and relevant group names, in future, I could do the task assignment and should send email. Is there any workaround for this?

Hi Team, I am trying the new feature in record type, creating reusable interface for a record field. https://docs.appian.com/suite/help/25.2/reference-records.html#reference-record-field-interfaces i need to do duplicate validation for the fields, created by using re-usable interfaces for a record field. Below is the interface definition of the created interface automatically by Appian, for the record field. a!textField( label: 'recordType!{b1ecf478-0b29-4be8-a0f1-edc36a6d606a}SG IPL Match.fields.{4b2ebeae-9196-4a13-8d48-44abf5b765ae}username.properties.{displayName}displayName', labelPosition: "ABOVE", showWhen: fn!true(), value: ri!record['recordType!{b1ecf478-0b29-4be8-a0f1-edc36a6d606a}SG IPL Match.fields.{4b2ebeae-9196-4a13-8d48-44abf5b765ae}username'], saveInto: ri!record['recordType!{b1ecf478-0b29-4be8-a0f1-edc36a6d606a}SG IPL Match.fields.{4b2ebeae-9196-4a13-8d48-44abf5b765ae}username'], align: "LEFT" ) Now how to validate if username provided by user is not a dupl

I am trying to enable Process insights and Data governance in Dev environment. I have added "Data Fabric Report Creators" and "Data Governors" group to "Process HQ Users Group". In the required records and event history record security I have added "Data Steward" group. Is this any setting/prerequisite I am missing to enable Process insights and Data governance in Process HQ?

Hi Everyone,I'm trying to delete a record type object in my appian application but I'm unable to do so. When I try to delete the below error pops up. Has anyone faced this issue and how to resolve this. Thanks in advance!

Hi everyone, I'm looking for a good resource (docs, videos, or examples) that explains record actions and record views in Appian — especially how they work behind the scenes. I want to understand how visibility, context, and navigation are handled under the hood. Here’s my current scenario: I have a table with two columns: Policy Number and Policy Form Number. It’s a 1-to-many relationship — one policy can have multiple policy forms. I’m able to display all the policy form numbers correctly in a grid. However, I’m struggling to associate each policy form with its corresponding document link. The goal is to have each link open the correct document in Tempo or a Site page. Right now, only the first document link is opening, no matter which policyForm value I have clicked. I suspect it has something to do with how I’m setting up the record link or passing the identifier, but I’m not sure. Would really appreciate: Any resources that e