Records

What could be the possible fix for the below issue? 8 calls, 1199 ms peak average, 0.0% of total

I am creating an Appian Application that has Data Model based on CDTs (SQL Server Tables and Views). For the Record List Page, I have created Record Type from the CDTs which is sourced from a SQL Server View. The main ID on the list page is hyperlinked to navigate user to the Record View Page of the record in the same Appian Application. However, I have a second column in the Record List Page, which contains the ID of a Record List View Item from another Application. I want this ID Hyperlinked as well, which navigates the user to Record View Page of another Appian Application through this Hyperlinked ID. On the backend, I have simply created a Database View in SQL Server which contains ID of of both record item i.e. the individual record in the new application and the existing record in the old application. But on the front-end, I am not able to discover a way through which I can hyperlink the ID in the second column which navigates user to the Record View of the other application.&nbs

hi all I was not able to figure out how the reduce function will work dynamically can someone explain

Someone knows if in Appian is any limitations in the user filters quantity I can create into a record, if it so which one is it?Is there also any in default filters or source filters?

Suppose I have an array with multiple values for key dates:'type!{urn:com:appian:types}Request'( 'id': "009642", 'status': "Cancelled", 'dates': "05/05/2024, 10/06/2024", ), 'type!{urn:com:appian:types}Request'('id': "009641",'status': "Cancelled", 'dates': "06/15/2024, 02/06/2024, 02/10/2024" ) I want the result to be such that the dates are individually added and appended having the same data. so the first array will become 'type!{urn:com:appian:types}Request'('id': "009642",'status': "Cancelled", 'dates': "05/05/2024",), 'type!{urn:com:appian:types}Request'('id': "009642",'status': "Cancelled", 'dates': "10/06/2024",),   Like this I want to do for all items in that data. Is it possible in appian?

Hi, after upgrading to Appian 23.4 try to launch Data Fabric Analytics results in this error (screenshot) and the OK button doesn't work. I am in the Data Fabric Report Creators group. Everything else on the platform works. It's a develop environment, on premise.  Any suggestions? Thanks

Hi all, I am using user filter for read only grid. But whenever I add or delete new record, user filters are refreshing automatically. I have to refresh page again to see updated filters. Please suggest how to implement auto-refresh on user filters. Thank you! 

Caching of data fabric happens in server or in memory ?

What is the Memory impact on cloud servers when we implement all our application(approx. 13) in data fabric i.e using all entities and record types ?

So, i want to update a related field of a record, that contains an array of records. Im trying to do it by using append, but no values are stored into the field.   Anyone knows if there is a way to achieve this? Doing it in the initialization of the object works, but i need to update it on demand. thank you very much!.

Description: rule!OE_QueryOneRecordTypeByForeignKey(recordType, fkField, value) Gets a record based on its foreign key field value recordType (RecordType): queried record type fkField (Record Field): foreign key field value (Number (Integer)): integer value searched a!localVariables( local!queryData: a!queryRecordType( recordType: ri!recordType, filters: { a!queryFilter( field: ri!fkField, operator: "=", value: ri!value, ), }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 1) ).data, if( a!isNotNullOrEmpty(local!queryData), local!queryData[1], null ) ) if it was OE_QueryRecordTypeByForeignKey, then you simply remove the [1] indexing

Hi teamHere is my scenario:I am busy changing my application to get rid of CDTs and use Record Types instead. As I understand it this means I have to change any query using queryEntity to queryRecordType.Here is an example of an existing expression:{ a!entityData( entity: cons!SAM_DSE_SOFTWARE_STATUS, data: reject( fn!isnull, a!forEach( items: { { uuid: cons!SAM_UUID_SOFTWARE_STATUS_APPROVE, name: "Approve", order: 1 }, { uuid: cons!SAM_UUID_SOFTWARE_STATUS_BACKLIST, name: "Backlist", order: 2 }, { uuid: cons!SAM_UUID_SOFTWARE_STATUS_REJECT, name: "Reject", order: 3 }, }, expression: a!localVariables( local!status: rule!SAM_getSoftwareStatusByUUID(uuid: fv!item.uuid), if( isnull(local!status), 'type!{urn:com:appian:types:

Hellooo! Does anyone know what might be causing this issue? We're currently facing this predicament in the entirety of our environment.  Is there anything we can do in Appian to address this? Help would be gladly appreciated.

Hello, I have two record types that are related to each other, but when I am trying to retrieve with relationship.relatedRecord.field, it displays only null, what can be the problem? How can I fix it?

Can someone guide me how to disable data sync option in record type with proper images guidance ?

Hello Community, I am using Related Record action to update a case, using Rv!identifier as context to pass the case ID which needs to be updated. And passing the identifier through rule input in the interface using  a!recordActionItem, but it is not taking the correct input(case Id) in this scenario. Any idea why this is happening.

Hi, If a relation does not meet the conditions for getting data, should the output return empty? Example.. The database query returns empty The queryRecordType returns a value This is correct?How can I get an empty value, like in a database? This is a modification of lesson 4 exercise 2, in the associate course certificate. (If I don´t write the "fields: AA Vehicle.maintenance.cost", the output is the same, removing maintenance list) Thanks for the help

Instance of the Process variable(record type) is having two different values but when I configured the event history for that record where the values are storing duplicates. Kindly suggest. Providing below screenshot. Process variable values DB Values Write to Record Event Configuration

Hello everyone, I'm encountering an issue with record type. I have a table in my database responsible for storing HTML template code for each user. When retrieving the data through records, I'm not receiving the full length of the HTML code; it's breaking. The column in the database has a VARCHAR data type with a limit of approximately 65,000 characters, while the length of the HTML code string is only 4000 characters. In DB we have full length code.Can anyone provide assistance or suggest a workaround for this problem?

I am having requirement to show up only the respective record data from the grid in the Site. I have used a!urlForSite(sitePage: givensiteofMyapp) to navigate to the site but to retrieve the exact record from the grid how I need to fetch those details. Kindly provide any suggestion

Hi All, I have a requirement when we display the record.I have configured one user filter named "status" which consists of 5 values. I want that whenever the user lands on the page.. one of the five option from the filter is NOT applied. the value in the Default option should not be applied. {Basically all the other 4 apart from the default value should be in the filters when page gets load} Kindly suggest what can be done as datatype of default option is text and not array!

Hi everyone,  I'm facing a strange behavior when using a!queryRecordType() to query to related record types.  I'm having 3 record types with relationships as below: I'm doing the below query to get all the teams that Shaun is a member of (team A and B).  a!localVariables( local!dataset: a!refreshVariable( value: a!queryRecordType( recordType: 'recordType!Team', filters: a!queryLogicalExpression( operator: a!defaultValue(ri!filterOperator,"AND"), logicalExpressions: ri!logicalExpression, filters: { if( a!isNullOrEmpty(ri!id), null, a!queryFilter( field: 'recordType!Team.fields.id', operator: "IN", value: ri!id ), if( a!isNullOrEmpty(ri!name), null, a!queryFilter( field: 'recordType!Team.fields.name', operator: "IN", value: ri!na

Hello Everyone, We have a database view with 45 columns and it taken 4sec of time(40k records) to execute from database view. Also DT created for this view in appian,  now we mapped this DB view to Record and it was thrown below error:  Expression evaluation error [evaluation ID = fead6:13bce] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit. (APNX-1-4198-000) It's looks like a wired behavior of Record because as per the community it will support 40L records. Could someone help me out to fix the issue.  DS also verified and published without error. FYI, We can't see the data in record after we mapped to DB view and it shown the error message as mentioned above. stdout log here: Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evalu

Hello every one Is it possible to set a process model on a record type summary? I know it can be done with an interface, but I would like to verify if it is possible with a process model. Like in the photo below (i tried it and failed) Thanks

Hi Everyone I have created Process reports using records but i couldn't able to see data in reports & interface as well. I have read  in documentation that it wouldn't show in reports but it will in interface unfortunately i am not able to see in both. Can anyone provide solution to me on this. Thanks in Advance.