Records

Hi Team, I am using a record-based grid to display data. But unless search button is clicked, data does not get loaded to grid. Thanks, Kavya

Hi everyone, We are planning to connect Appian to an on-premises SQL Server environment. Due to security and network restrictions, Appian developers do not have direct access to the on-premises SQL Server. As a result, we are unable to directly inspect table structures or view data stored in the database during development. To support smoother development, investigation, and testing activities, we are exploring whether it is possible to view and reference on-premises SQL Server data from Appian. Specifically, we would like to understand the following: Is it possible to synchronize or replicate data from an on-premises SQL Server to the Appian Cloud Database? If so, is there a way to browse and inspect table data using a GUI similar to the Appian Cloud Database? Thank you in advance for your help. Hatsune

We have a database table where we store a reference to a Record Type (it could be the Record Type name, UUID, or a string like "()"). The requirement is to convert this stored value into an actual Record Type object at runtime so that it can be used in expressions or interfaces. For example: cast( 272, " 'recordType!{b12345-12345-12345-12345-c12345}ABC' " ) Is there any built-in function or best practice in Appian to achieve this dynamic casting?

I am trying to use a create new record action to insert a new record into my table and based on the grid I am showing to the user they only can see records associate to an related record. I would like to be able to pass in the primary key for that parent record into the record action so I can default that field to use that value and not allow the user to associate to a different parent on accident. It is possible that there is not data in the grid but I would still know the primary key of the parent record to pass in.

When creating or editing a record type, you can see the URL of the record list. How can I read this so that I can create a link button to the record list for the user? I don't want to see a single record, but the complete list. The solution is: a!urlForRecord( recordType: cons!SODA_PGN_RECORD_TYPE_PGN_REQUEST, targetLocation: â`˜TEMPOâ`™ ) I was just missing the function a!urlForRecord().

{ { '1': { loggedInStatus: "Succeeded", timestamp: { sessionDeletion: "", lastActivity: "", login: "2025-12-03 07:43:17" }, sessionId: "abcb9532-b5f5-4e2f-8946-8f08a17e307f", status: "Active" }, '2': { loggedInStatus: "Succeeded", timestamp: { sessionDeletion: "", lastActivity: "", login: "2025-12-03 08:27:31" }, sessionId: "08ad7f98-85f6-4fd5-a072-6278731cbfef", status: "Active" } } }Here in this example I want to access a field "sessionId". I tried to wrap this using a!flatten () but still it doesnt work. Any help here ? Thanks in advance.

Some of the queryRecordTypes are working slow for us in prod. I am trying to monitor the performance and it has something 'performanceView.breadcrumb.recordQuery' highlighted. What does that mean and what part of the query/record it points to? Any idea Also, Appian do recommend using queryRecordType to get the data from the related records too but when I have filters and logical expressions applied to them they are performing slow.

Hi, I need to transform an image to base64 to be able to send via the Send E-Mail object. Is there a plug-in? thanks 

 I have a user filter with multiple dropdown and the drop down contains duplicate names of amendment but their application type and Line of business is different so there are duplicate names . As this is multiple dropdown if we select one duplicate name another duplicate name is also getting selected thats fine , but when I deselect one its not deselecting both, aby idea how to handle this In the above picture I selected blood , but if I deselect one blood , its not getting deselecting unless I click on "cross" button in dropdowna!localVariables( local!i18nInterfaceData: rule!INZ_I18N_loadBundlesFromFolder( bundleFolder: cons!INZ_CONS_INTERFACE_COMPONENT_INTERNATIONALIZATION_FILES ), a!recordFilterList( name: rule!INZ_I18N_displayLabel( i18nData: local!i18nInterfaceData, bundleKey: cons!INZ_CONS_TXT_INTERFACE_COMPONENT_INTERNATIONALIZATION & ".amendment" ), options: a!localVariables( local!fieldValues: rule!UWG_QR_fetchAmendmentMas

I have multiple records in my application i needs to sync all records  at scheduled time which is the best way for sync. Thanks in advance for response

Hi everyone. I have added fields to an SQL Server table. I have refreshed the associated RecordType to add these new fields. Now when I create a new record I face this error (in the "Nombre" field for example): I suposse the recordType have not been refreshed properly but I don't know how to do it because I have sincronized many times. When I experience this problem I usually remove the recordtype and create it again but this workaround is not nice. Do you know how to do it properly without rermove it? Thanks in advance.

Which function do we use to remove a particular field from a record before persisting it? For example: recordType!sampleRecord1( id: null, column1: A, column2: B, column3: C, column4: D, column5: E, column6: F, column7: G, column8: H, relationA: recordType!relationA( id: null, column1: A1, column2: B2, column3: C3 )) I want to remove the id field from both sampleRecord1 and relationA before persisting them. Reason: The downstream database does not handle id: null well, but if the field is missing or field have a value, it works fine. The output I want to save should be: recordType!sampleRecord1( column1: A, column2: B, column3: C, column4: D, column5: E, column6: F, column7: G, column8: H, relationA: recordType!relationA( column1: A1, column2: B2, column3: C3 )) Which function do we use to achieve this? i want to handle it dynamically rather mapping individual fields and then persisting .

I need to implement a functionality where: SERICE TABLE STRUCTURE planId | scenarioId | iteration | serviceId (PK)| price For some service, there are fee details stored in a separate Fee table, which is structured like this: planId | scenarioId | serviceId (FK)| rowId | sequence | feeAmount The serviceId acts as a foreign key linking the fee details to the service.  service can have multiple fee detail rows (typically 4), and users can also add new fee rows. If a user makes changes to the fee details of a service for one plan/scenario combination, those changes should be applied to the same service in other plan/scenario combinations. We already have a similar functionality for services where changes to the price field can be applied across all combos  . Now, we need to do similar thing for fee details.  Fee details available for particular service . It can have multiple rows of fee details. users can add new rows of fee details. When a new fee row is added for on

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?