Records

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

The dropdown field is malfunctioning, displaying all available values as a single combined option instead of presenting them as separate selectable options. Any idea what might cause this behavior.  This is the expression that I am using:  a!queryRecordType_24r4( recordType: 'recordType!{2c57b299-d666-427e-ba44-342541c31f8f}AMS Workflow Type', pagingInfo: a!pagingInfo(1, 5000)).data['recordType!{2c57b299-d666-427e-ba44-342541c31f8f}AMS Workflow Type.fields.{81363ed4-9bc0-44f3-b5ef-e723de125744}description']when i test it separately as an expression it gives me a list and not a single unit

In appian developer course, they mentioned CDT is used for Record type with no sync But in the next Leason , they mentioned CDT will be created automatically once the Action is created for record type with Datasync enabled. where we use CDT ? for non synced record type or synced record type

I have an interface that displays an interface with a form if a local variable is true, else it shows an interface with a grid. The desired behavior is once the user creates an item using the form, the grid will automatically update to display the new item in the grid. It does not do this. The user has to click the grid refresh button to see the new item. The form saves the item using writeToDataStoreEntity in the saveInto of the submit button. On success, it changes the value of the boolean which causes the grid to appear to the user. The grid is a record-backed grid. Changing the grid to use a DSE or changing the form to use a record are not allowed. A process model is also not allowed. Placing the recordData in a local variable and using refreshAfterVarChange does not update the recordData. Using the refreshOnVarChange parameter in the grid does not refresh the data. Placing the grid interface in a local variable with refreshOnVarChange also does not cause the recordData to update.

Hi Team, Just want to know. How to find time complexity and space complexity for Appian in-built functions since its not available in each Appian documentations. Is it possible to find which kind of algorithm used for creating there in-built functions for all the cases like best-case and worst-case sceneries.  Thanks and Regards, Vigneshkumar Radhakrishnan

Hi Experts,I m using read only grid in my interface, where i used expression as data source . If I search the column data correct results are not showing up. Lets say if have fields with status " NOT started" i can see 3 rows of data in grid, but if i search for "Not Started " and hit enter. only one result is showing up in grid. How to solve this Thanks

I am trying to open record summary for requests but whatever record I open I'm getting record doesn't exist. I attached my code I can understand something is wrong but couldn't get what I was missing.  The ri! Request relation is of type request relation. Anyone can help? a!sectionLayout( contents: a!forEach( items: ri!RequestRelation, expression: a!cardLayout( contents: { a!linkField( links: a!recordLink( label: "link", recordType: a!match( value: index( a!queryRecordByIdentifier( recordType: 'recordType! Request', identifier: tointeger(fv!item[requestRelation.field.AppId]) ), 'recordType! Request.fields.applicationId', {} ), equals: 212, then: 'recordType!ABC', equals: 213, then: 'recordType

Hi Team,  I am using custom record field for date difference function (a!customFieldDateDiff), however the problem is that this function rounds off the date to floor. eg 10.99 Days will be 10 Days. do we have any other function which will do the job correctly ?  Thanks in Advance 

Hi All, I am using Oracle DB and in Appian want to create CDT for few tables. I am able to create CDT for few but for few I am not. Below is the statistics I noted.   Total no of columns in DB Total no of rows in DB CDT? Table1 68 9977 Created Table2 51 106881 Failed Table3 45 14 Failed Table4 42 26191 Created Table5 41 14 Failed Table6 36 60354 Failed Table7 32 100878 Failed Table8 32 328 Created Table9 31 2559 Failed Table10 29 39602 Created Table11 29 21581 Created Table12 29 268 created Table13 28 13565 Failed Table14 28 42 Failed Table15 27 83742 Created Table16 27 16792 Created Table17 27 944 Failed Table18 27 497 Failed Table19 26 59 Failed Table20 25 3480 Failed Table21 23 5982 Created Table22 22 195 Created Table23 21 1236 Created Table24 21 1126 Failed Table25 21 339 Created Table26 20 1688 Created Table27 20 501 Created Table28 19 88502 Failed Table29 19 1286 Created Table30 18 1073 Created Table31 18 17

Facing the following error when creating a new record where record sync is enabled. No recent changes in the code or in the record. The record is marked as synced but its data has not yet been synced. More than 50% of the hard disk space is available in the server. Doesn't seem to be a disk space issue. 

Hi, we have migrated Appian to a new infrastructure, so we are trying to align the two environments but the deploy returns errors on some recordTypes.It seems that Appian doesn't see some recordTypes even though they are there. If you click View Record List the message is:The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = XYSYS] at function a!recordList: Record Type {urn:com:appian:recordtype:datatype}4ce79cd7-05b5-40a0-923d-e15cc988b782 does not exist (APNX-1-4198-000). But if I search for the UUID I find it.And the record syncs with the db without error. Has this ever happened to you? Thanks