Data Fabric

I have a record that when I the value gets updated to NULL the item gets ignore and it does not get updated on the Database

I'm encountering an issue when trying to access a cloud database URL from Appian. The full URL I'm using is: dev.abc.us-east-2.123.aws/.../index.php However, when I copy and paste this into a new browser tab, the URL gets truncated and only loads as: dev.abc.us-east-2.123.aws/.../index.php Interestingly, I’m not facing this issue with another table from the same schema—its URL works as expected. Has anyone experienced something similar? Could this be related to how Appian encodes or renders the link? Any suggestions on how to preserve the full query string when opening the link? Thanks in advance!

1. My requirement is that users can be able to download the reporting interface as pdf using a click of a button. 2. Also if there is any way to export my reporting data in excel (my reporting interface contains- counts of events, dropdowns and charts like- column chart, pie chart, bar chart, etc.)

 As you can see I am not able to see data type from the list I wanted to create a constant of type Data Store Entity.

In Process HQ i am not able to see the ADD PROCESS button under Process Insights tab as shown in the picture. Could anybody please help me with that? Thanks in advance. 

Hi everyone, I’m working on my first Appian build and ran into an issue I haven’t been able to resolve. My save logic seems to save correctly to ri!record, but I’m getting an error related to the record type relationships. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error: xxxx must be indexed by its corresponding record type fields or relationships I suspect the issue is tied to how my record type relationships are configured, but I haven’t been able to figure it out. Has anyone encountered similar issues with saving data to a record type and relationship errors? I’d really appreciate any guidance on reviewing or troubleshooting the save logic and relationships. Thanks in advance!

i have a store procedure where it has 13 different columns retrieved from 20 different tables i need to get user a link on single click to export data to Excel , and also if possible matched data should  be bold in the excel

HI all  I have a record for sum insured values let's say he below: id: Primary Key (QuoteID) riskType1SumInsured: Aggregate field of all RiskType1 sum insureds riskType2SumInsured: Aggregate field of all RiskType2 sum insureds riskType3SumInsured: Aggregate field of all RiskType3 sum insureds totalSumInsured: a!customFieldSum(riskType1SumInsured, riskType2SumInsured,riskType3SumInsured )  When all the risk type 1,2 and 3 sum insured values have a value (Not Null) the totalSumInsured works correctly, however as soon as one or many of the risk type 1,2 and 3 sum insured values are null, the totalSumInsured simply returns a null. I have tried wrapping the risk type 1,2 and 3 sum insured values in the a!customFieldSum(), with a!defaultValue() as well is a!isnullOrEmpty(), but no change in behaviour. Is there something i am missing?

Hi All, I am trying to quey the view which has 20000 rows. when i apply filter to one of the calculated column which has 0 rows present, queryentity still throws below error.  Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [ELMRISKREDUCTIONLANDINGPAGEVWDT16641], query: [queryentity expression], order by: [[Sort[eucInventoryId asc]]], filters:[(currentReductionStage in TypedValue[it=103,v={Process Re-engineering/Non GFT/ITeSS,}])]) We tried optimizing the view as well, but no luck. Any suggestion would be appreciated.

I am getting above error, I have a doubt for now I am using record data function to get the data and using it as a source for grid component.  i tried changing source to result to queryrecordtype  instead of recorddata also . so as this message suggest  Do I need to directly reference the recordtype in the data field of grid component?

I've been having headaches with dates in Appian and I think it has to do with the way appian handles timezones.  Unless I'm mistaken, appian is supposed to record dates in GMT then then later read them in whatever local time zone is appropriate. What I'm finding is that it records in the local time zone, then later reads it as though it were GMT and adjusts to the local time zone, resulting in incorrect dates.  The more frustrating thing about this is how I access/display the date affects what gets shown.  For example if I use a date picker, appian records the date as 4 hours earlier. Thus 8/8/2025 will be recorded in the db as 8/7/2025 8:00 pm EDT If I display the date in a text field, I'll get 8/7/2025 8:00 pm EDT, but if I put it through any kind of function such as text() to format what it looks like it'll come out as 8/8/2025.  What's worse is I imported a csv of a bunch of legacy data and the dates were all converted to date/time a

I have interface displaying record data in grid format. When the user clicks Export to PDF, the currently filtered results (or all records if no filter is applied) should be downloaded in PDF format.

Hello Appian Community, I am currently working with Process HQ reports, and when exporting the data, the files are automatically downloaded in CSV format. I have two questions regarding this export: Some fields that are numeric are being exported as text format. Is there a way to ensure they are downloaded directly as numeric values instead of text? In some cases, exported numbers include a strange prefix character (for example: $~118.331.052.083.617,56). Is there a recommended configuration or workaround to prevent these characters from appearing? Any guidance or best practices would be greatly appreciated. Thank you in advance for your support. Regards, Monica Vela,

We are seeing a strange issue in which write to record is not working properly. If we check the process variable value, it is successfully updated, but when we look at the database, the latest data is not being updated, no expression error is generated, and this is an intermittent issue. As per this thread we updated to latest version https://community.appian.com/discussions/f/data/39426/data-fabric---write-to-child-records-via-relationship, still we see same issue. Anyone knows the reason?

Record Type details not showing after  click on View Record List

Hi FolksJust sharing the experience!When writing to child record via write record, there was no error on process model, but it was still not writing to DB. Then we realized the issue was because of two reason which we did not pay attention 1. We need to make sure the record object is updated o latest version means below pop should not be visible 2. On the model switch to latest version of smart service.

Can we pass a list of numbers to input parameter of SP? Is it possible. a!storedProcedureInput( name: "group_ids", value:local!groupids (It is a list of number) ), It's not working as input parameter is defined as INT on DB side but we are passing list of integers.

Hello, I am attempting to convert this into Appian values, but I am having trouble.  What would be the best way to convert this? Here is the raw response from an API: {"response":"{\"requestId\":\"123456\",\"status\":0,\"description\":\"Success.\",\"response\":{\"transactionId\":\"12241094986\",\"payfoneAlias\":\"432432424\",\"phoneNumber\":\"324324324234\",\"lineType\":\"Mobile\",\"carrier\":\"T-Mobile USA\",\"countryCode\":\"US\",\"statusIndex\":\"51\",\"isBaselined\":true,\"score\":1000,\"phoneNumberVelocity\":0,\"portVelocity\":0,\"payfoneTenure\":{\"minimumDate\":\"2024-08-05T23:59:59.000Z\"},\"phoneNumberTenure\":{\"minimumDate\":\"2024-08-05T23:59:59.000Z\"}}}&quo

Hi everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I have scenario where my data is stored in Map/Dictionary. Now this has to be stored in record.Each field to be mapped with the respective record field.Considering the volume, Is there a way to use the Field Id to map the value.Example: a!localvariables( local!list:{{columnName:"Name",recordFieldId"4567898765"}, {columnName:"Desc",recordFieldId"4567856894"},/* Now the data to be mapped */a!foreach(locaL!list,index(record,fv!item.recordFieldId,null)) )

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   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)   at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)   at java.desktop/sun.font.FontManagerFactory$1.run(FontManagerFactory.java:85)   ... 233 more Caused by: java.lang.RuntimeException: Fontconfig head is null, c

Hi! Is it possible to prevent removal of Record Events related to removed record? I want to have an event "XX record removed" but it seems impossible as it removes all events related to given record. Thanks, Damian

We have some fields with extra long text type in our records. Seems only 3 fields are allowed with extra long text data type and we had 4 fields. We assume this warning is coming because of the recent upgrade. Its showing warning that only 3 fields can have extra long text and its not allowing us to add any column. And we are unable to change datatype from extra long to text from record side. I changed the column from text to varchar in db side but still getting this error. Please let us know how to resolve this issue.

Hello, I'm facing a challenging issue when reading dates from Excel files using readexcelsheetpaging(). The problem occurs when Excel cells contain dates in custom format that appear as values like "2026-07-17". The Problem: When Appian reads these date values, it interprets 2026-07-17 as a mathematical expression (2026 - 07 - 17 = 2002) instead of treating it as a date string. This happens before I can apply todate() or text() functions. Context: Excel cells contain dates with custom formatting (cannot be changed on Excel side) Dates appear as format like "2026-07-17" when read by Appian Need to convert these to proper Appian date values Current Code: a!localVariables( local!document: ri!document, local!sheetNumber: ri!sheetNumber, local!startIndex: ri!startIndex, local!tempResult: readexcelsheetpaging( excelDocument: local!document, sheetNumber: local!sheetNumber, pagingInfo: a!pagingInfo( startIndex: local!startIndex,

Are there any disadvantages of Recordtype over CDT

O/P - 1 O/P - 2 O/P - 3 When I directly query the comments table with a filter to fetch comments where the audit is null, it returns the expected results(O/P - 1). However, when I apply the same filter in a related record query from the main test table, it does not return any comments(O/P - 2). Interestingly, if I remove the audit filter, the related record query returns the correct data(O/P - 3). Any idea what could be causing this issue?