Records

I am storing the values to sql in gmt format ,when I fetch  The data back and show it in grid Iam changing to clients timezone but it stores in db as gmt while querying and showing in grid making difference in the time I checked separately but the issue is in sql we need to conver to local timezone and use it.Is there any way,please suggest I'm using view to fetch data and show in front-end

I noticed that if I use sql to update data, the data in record type need to sync manually.  I want to know is there any way that the record type can sync automatically once I update data in db. In sync options tab I only saw Schedule full syncs, but It can't suit my require.

Hi Appian Community, We recently ran a Health Check on our application and encountered a performance finding related to a Record Type. The specific issue is with the "Data Query and Default Filter" step, which is taking 4322 ms to execute. Context: We have a Record Type (recordType!ABC) that pulls data from a database view containing all case types. A default filter is applied using the "Expression" option. The expression used is:             a!queryFilter(   field: 'recordType!ABC.fields.transactionId',   operator: "=",   value: 46 ) Note: The transactionId field is indexed in the main underlying table Any insights or recommendations would be greatly appreciated!

Is there any way to recover deleted documents in Appian Environment. We had the docids for the deleted objects, Is it possible to recover them? 

Hi, I have a field 'allocatedTo' in the database table with longtext type, which is translates to Extra Long Text type in Appian Record. While trying to edit a relationship with another record having 'username' field as Text type, 'allocatedTo' does not show up in the dropdown. Strangely, it worked fine first time, now shows error in the relationship. What could be the issue ? Thanks.

Can anyone help me with what the error is about. It showed up when i clicked summary view.

My input will be emailaddress in eachline  on the UI"values": [ { "id": "d7971ace-7ca5-ec11-8132-0050569773df", "emailAddress": "testing.test@test.com" }, { "id": "50363345-b494-ec11-8131-0050569773df", "emailAddress": "test2.test@test.com" }]This will be the response of my integration. when the response is 200 then I want to store the entered emailaddresses in new table as seperate rows and the IDs from response should get mapped to those emailaddress in DB .How can I achieve it 

My input will be emailaddress in eachline  "values": [ { "id": "d7971ace-7ca5-ec11-8132-0050569773df", "emailAddress": "testing.test@test.com" }, { "id": "50363345-b494-ec11-8131-0050569773df", "emailAddress": "test2.test@test.com" }This will be the response of my integration. I want to store the entered emailaddresses in new table as seperate rows and the IDs from response should get mapped to those emailaddress in DB .How can I achieve it 

Hi, I'm facing the issue while executing a process. When I ran a process it'll insert data into database. The process is working in DEV & I deployed the code in test and tried to run the process but the record sync is failing. I can see the data is inserted into table but node is failed. Also, I tried to sync manually, it's still failing.  I found the below from logs, but not much help. If anyone have idea on how to resolve this error.  2025-06-03 09:53:23,215 [Appian Timer - 1] WARN com.appiancorp.common.ObjectSynchronizer - 1 services were missing users. 2025-06-03 09:53:41,677 [RecordSyncScheduler_Worker-2] INFO com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: 43_663b0ec2-ac3e-43a8-9ea1-b226c63274cc] fired for job [group: record_load_group, name: 43] 2025-06-03 09:53:41,893 [RecordSyncScheduler_Worker-2] ERROR com.appiancorp.record.service.BulkLoadServiceImpl - Unrecoverable error in record data sync com

I gave an field as an primary key by mistake and now i want to give the primary key field to another field. Can anyone help me with that, iam new to appian.

Hi everyone, We are using a Record's Summary View to display the details of a player. Inside this view, we have implemented multiple tabs (e.g., Match1, Match2, Match3, etc.). We would like to update the browser URL with a parameter to reflect the currently active tab. Use Case: User click on Players tab from the main navigation. The Players tab displays a read-only grid listing all available players. From this grid, a user can click on a player using an a!recordLink, which opens the player's Summary View (Record Summary View). In the Summary View, the player’s details are organized into tabs. We want the URL to update based on the active tab, so that if the user reloads the page or shares the link, the correct tab is shown directly. Is it possible to pass or read custom URL parameters in the Record's Summary View to manage tab state? Any guidance would be appreciated! Thanks & Regards,

Hi ,  I am using a default Export functionality of Record in an Interface , But I am facing an issue that while exporting some data is not available . I am having a relationship in my record and some other customs fields .  Please let me know why this is happening.  Thanks in Advance

Whenever we click “Generate Record Actions” on a Record Type an error is displayed to user like below, this issue seems to have a higher changes of occurring for record types that contains data/rows in database. and tomcat-stdOut.log spits out  2025-05-26 19:14:35,956 [http-nio-8080-exec-22063] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element 2025-05-26 19:14:36,037 [http-nio-8080-exec-22063] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element 2025-05-26 19:14:36,225 [http-nio-8080-exec-22063] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/type

I am able to add a new value to a  time field successfully. But when I am trying to update the same row, the update is happening in the backend, but not reflected in the UI.

Hi Community, I’m working on a requirement where I need to create dynamic columns in read-only grid in Appian and would appreciate some guidance. Problem Statement: I have a database table with the following columns: ActivityName ForecastDate (Date field) ForecastAmount (Decimal) Requirement: I want to display a grid where: Each row represents an ActivityName. Columns dynamically represent Month-Year values (like Jan-2025, Feb-2025, etc.), based on the date range selected from interface. Each cell should show the corresponding ForecastAmount for that activity and month, if available. So the table should “pivot” the data such that ForecastDate drives the column structure dynamically. Note: Any Date range between 2020 to 2030 can be selected and searched. Questions: What’s the best approach to dynamically generate these month-year columns in an Appian interface? Should I preprocess the data in an expression rule or CDT before pas

Hi Team, We have configured the required access and security for a recordtype to be displayed in the process HQ, but for some reasons it is not getting displayed, the left-pane is empty as in the screen shot below. Requesting assistance on this. Thanks. we are not able to see the Process HQ enabled although we have added ourselves to the Process HQ, Data Governors and Report Creators group.  Enabled the record type, to be visible in the Process HQ workspace. But still not able to see. This is a self-managed appian env, the version is 25.1. Please advise if we are missing anything to be configured or setup.

We have a requirement to pull Service backed records which needs some query parameter to it only pulls Records based on user selection.  I was not able to find a way to pass parameter to the recordtype , is there a way to do that  ? rule!myIntegrationPointingToServiceBackRecords ( input1: ri!input, batchnumber: ri!batchnumber )

Hi! I was wondering if it’s possible to add a “Select All” option to User Filters in a Record Type. I tried but couldn’t find a way. The business needs to be able to select all options and then deselect a few, rather than having to select each one individually, which is time-consuming when there are many options. I know it’s possible to do this in a custom interface, but I’m curious if it can be done from the record side. Thanks!

Hello,  I'm currently looking for a way to pull data from the Appian Database into Microsoft Power BI. Our goal is to use Power BI to create reports based on the data we have in Appian. It would be very helpful if there is a way to connect the Appian database to Power BI directly, so we can start building reports in Power BI, where most of our users are comfortable creating content. Ideally, we would like to avoid using plugins, but if necessary, we are open to that possibility. Thank you so much for your help!

When i am trying to access the Tempo record i am getting below error can anyone suggest us how to resolve this issue 

HII'm working with the following table structures and need to display approval tasks to users based on the current milestone of each request. A task should be shown if the user is either directly assigned or belongs to the assigned group. Each row in Request table has multiple rows in approval table. Is there a way to achieve this using records (not a database view) given the structure below?  CREATE TABLE `table_request` ( `col_id` INT NOT NULL AUTO_INCREMENT, `col_loan_key` VARCHAR(32) DEFAULT NULL, `col_loan_1` VARCHAR(32) DEFAULT NULL, `col_loan_2` VARCHAR(255) NOT NULL, `col_manager` VARCHAR(100) DEFAULT NULL, `col_sponsor` VARCHAR(255) DEFAULT NULL, `col_milestone` INT DEFAULT NULL, `col_status` INT DEFAULT NULL, `col_submit_date` DATETIME DEFAULT NULL, `col_created_date` DATETIME NOT NULL, `col_created_by` VARCHAR(255) NOT NULL, `col_updated_date` DATETIME NOT NULL, `col_updated_by` VARCHAR(255) NOT NULL, `col_is_active` TINYINT(1) NOT N

I am having one form ie. customer form, I need to hide the 2 fields like dob and email id from basic user automatically , like we can keep showwhen condition in the form itself but it is manual process , need to do automatically .. is there any way to do this? in appian

I have a table with 100,000 records. In the development environment, I used queryEntity to retrieve the data without issues. However, in the production environment, the dataset is much larger, and performance has become a concern. I tried optimizing the query with selections and filters, but the large volume still causes problems. I considered using a stored procedure to handle the data retrieval with specific conditions. The downside is that any future changes to the database schema would require updating the stored procedure, leading to additional maintenance work. To address this, I implemented a paging strategy in Appian. I retrieve the first 100 records using pagingInfo and then loop through subsequent pages to fetch the rest of the data incrementally. This approach helps manage large datasets more efficiently within Appian. is there any approaches other than these , can you guys help me with this?

I have a workflow consisting of three forms: Customer Details, Address, and Health Care Details. Customer Details Form: After filling out this form, I save the information to the customer table via an API call. If this operation is successful, I proceed to the next form. If it fails, I delete the customer entry from the table. Address Form: Upon successful submission of the customer details, I fill out and submit the address form. Health Care Details Form: After successfully submitting the address form, I proceed to the health care details form. However, if an error occurs while saving the health care details to the table (for instance, a failure in the write operation), and no entry is created in the health care details table (which uses the customer ID as a foreign key), I need to delete the previously saved entries in both the customer and address tables to maintain data consistency. The challenge is that if a node fails during this process, Appian halts further execution, m

Hi All, I am encountering the error mentioned in the subject whenever I try to open the summary of one of the requests. In the record view, we have configured the following expression: rule!summary_interface(record: rule!qry_record()). Note: When I switched from rule!qry_record to rv!record, the error disappeared. Initially, we suspected that the issue was caused by a large dataset. To address this, we reduced the query size to ensure it evaluates within 50ms. However, the error persists. To investigate further, I opened the summary interface object and tested it by passing the query rule directly. When I clicked "Test Object," it loaded without any errors. However, when I opened an unnamed interface and invoked the interface using the expression: rule!summary_interface(record: rule!qry_record()), the same error occurred.Also in error message , its specifically mentioned about one child interface which just shows grid data around 20 items. If i remove this interface from summ