Data Fabric

when user with basic permission they click on  Record action they got  above error ,If same scenario try by myself with administrator permission  it's work fine for me , Basic user have appropriate security permission for Record access and actions   Note: If we think it is related to access issue either we get 401 or 403 issues but it get's different one 

I have a column in database view of type decimal (20,2) and it can take both negative and positive number. Now on downloading excel doc via out-of-the box feature (Export Data Store Entity to Excel), all the number are being quoted inside single quotes but not the positive ones. Any way to get rid of this?

Hi Everyone,  I have issue that I am syncing the records with sync record smart service within a process model in batch after the excel upload ;the excel have around 67k+ entries I am inserting the data using strore proc after some data manipulation ;  after the sync completed when I check in the data preview section for updated records they are available there but when I try to query the records I m  not getting those newly added rows. So I did manual sync then I was able to query it. What could be the reason can anyone help?

How do i add a new manual action in the summary view with an auto generated interface. Is that possible ?

Hi, After migrating to 25.1 version, we are unable to download excel from any of the records. The file will be attempting to be downloaded and fails after timeout. Below is the log we found in tomcat file, Caused by java.lang.reflect.InvocationTargetException Caused by java.lang.RuntimeException: Fontconfig head is null, check your fonts or fonts configuration

Hi Champ, I want to call an related action from an image component using the link parameter. Is there a way to do that? Regards, Ghanashyam

I have update and delete options in my related actions tab , but i want to remove the related actions tab and add the update and delete options in the summary view (Job Details) tab itself. Can anyone guide me how its done.

Hi all... i have a database-table (postgresql) with 3 columns: id (integer), year (integer) and cost_pre_hour (numeric(10,2)). I would like to use this table as a source for a dropdown.As choicelabels I want a contaminated string in the format: ‘Price for year ’ + [year] + ‘ (’ + [cost_per_hour] + ‘)’[cost_per_hour] preferably formatted with 2 decimal places. I just can't get it to work. what i tried:in the record-type another calculated field:a!customFieldConcat( { "Price for  ",recordType!<recordType>.fields.year," (",?????????" euro/hour)"})for ????????? i set:text(recordType!<recordType>.fields.cost_per_hour,"#.##0,00")orcast(typeof(1.0),recordType!<recordType>.fields.cost_per_hour)or other internal-cast-functions or/and combinations.I got the error Could not cast from Record Field to .... CastInvalid or something like thatWhen i try:tostring(recordType!<recordType>.fie

Hello, We are running a query on Synced Record data using a!queryRecordType where we need to filter based on a list of Text. This is the query filter we are using: a!queryFilter( field: 'recordType!recordName.fields.email', operator: "in", value: ri!email ) The record field is type Text and contains users' emails, which vary in how they are capitalized. The rule input ri!email is a list of Text String. When we pass in only a few items to that rule input we are able to return the expected results and we do see the records being returned with the email field matched in a case-insensitive manner. However, in our implementation we need to search on a large number of emails where the capitalization is not consistent across data sources. When we pass in 173 items to the ri!email rule input, we do not see the results being returned as expected with the email field matched in a case-insensitive manner. Then, if we update that 173-item list to make t

I want to have a custom record field, get data from related record field with out any aggregation it is a text field(like  we have group_concat and group by in SQL). I want to have this field as I want to apply sorting in read only grid on this column

My situation is as follows:I have a Vehicle record, an Employee record and a Driver mapping record between them. A vehicle can be reserved by a driver at a time, but in it's history there can be many previous drivers. I want to make a custom record field that shows the current driver assigned to a given vehicle so that i can use it throughout my application. However I am not sure how to do this with the aggregated custom fields. Since aggregations basically do not care for the specific thing i want (I want to show the employee name of the driver that has the latest start date on the mapping table).Is there anything i can do for this? Or do i just have to rely on relationships and generally querying relatedRecordData appropriately to satisfy this situation? 

Hi, I have readable grid in which i am using arrow icon, so if I click on that arrow so that row should go up and upper row should come down. I can get all data items from current row, but how I will get data from previous row, So I can apply swapping conditiin

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