Data Fabric

Hi Team, I need contained both records data into single record and display to the read-only grid in Interface  

I have two tables with n number of columns out of which mobile number, plan, and amount are common in both tables, we are getting data into tables from two different locations, now i would like to show plan and amount from two tables for which mobile number is same and to be shown in same grid, Can we do this simply without using complex logics and local variables

First, in the project that I am working currently we do not use the record sync, I have a case when I perform an action even though I am using the refreshVariable function and also activity chaining in process models, the interface is not refreshed without refreshing it manually. What can be the problem?

can we have dynamic label for columns in appian record type. For Ex. For current year, it should display 2023, for next year it should display 2024 and so on. Is it possible to have this implementation done?

I have a readonly grid backended with recordtype with 3 user filters, Initially all the data is showing and filters are applying when we select user filters, that is fine but my requirment is no data should be shjown in the grid untill we select atleast one user filter,  Can we achieve this? If yes how can we do that

Hi teamWe have moved an existing application to a new schema, and we are also getting rid of the old CDTs in order to use Record Types instead.I need to know how to apply the 'type' function where the new schema name is SierraUniformMike and the recordtype name will be SUM Onboarding Case 'type!{urn:com:appian:types:PRE}PRE_OnboardingCase'( id: null, case: rule!DCM_newCase( reference: joinarray( { "PRE", text( rule!APP_default(value: now(), default: today()), "yymmdd" ), rule!APP_generateUUIDSegment(6) }, "/" ), parentID: null, priority: null, milestone: rule!PRE_getCaseMilestoneByUUID( milestoneUUID: cons!PRE_UUID_ONBOARDING_CASE_MILESTONE_OPEN ), assignment: null, type: rule!DCM_getCaseTypeByUUID( uuid: cons!PRE_UUID_CASE_TYPE_ONBOARDING_CASE ), createdOn: now(), createdBy: loggedInUser() ), createdOn: now(), createdBy: loggedInUser() )OK, I

I am using PostgreSQL database for my application. This database is hosted on the AWS cloud server. I want to move it to the Appian Cloud server. How can I achieve this?

I am trying to cast record fields, and I am having that one field that is referenced in another record and when using the casting rule i am including this field. now when i write into the record using write record node: The input "Records" cannot insert or update a record which is referring to different referenced records via mbappid at the same time. To create a reference to a related record, include either a relationship reference or the required common field value for "mbappid". Location of conflicting changes: record(id: 123570) my approach was: a!forEach( items: pv!familyMembersDetails, expression: rule!CR_recordType( record: fv!item, status: "DEACTIVATE", mbAppId: fv!item['recordType!{record}record.relationships.{record}relrecord.fields.{}mbAppId'] ) ) but it still returns the error 

Is anyone aware of any frameworks or apps available for user-managed reference data? This is, a component for users to add/edit/remove lookup data, add/remove relationships, etc. 

Hi all, I am loading thousands of rows in a sync-enabled record through Import Excel into database plugin. How to deal with errors from process execution when trying to import date/time Excel columns with no current date (or Null). Is it any alternative rather than inserting a default date/time value?  Thank you for any suggestion, 

Please provide possible fix regarding below issues. 1.) 1 error occurred in Report: NGP_RPT_PliDecisionSummaryGrid 100% of errors due to: Expression evaluation error : Rule 'ngp_tab_plidecisionsummarygrid' has 2 parameters, but instead passed 0 parameters. 2.) 7 calls, 12037 ms peak average, 0.7% of total, 0.1% prepare, 96.4% execute, 3.5% transform, depth: 0, breadth: 12 3.) 5680 ms peak average - NGP_PAR_Send_Notifications (0002e36e-a0f5-8000-a2f0-010000010000) -> GOA Request Cancelled

I have a parent record case details which is having a one to many relationship with another record task details. When the data of caseDetails is loaded on first load of interface in rule input or local variable either using query record or process model, then I'm using count() or length() function to count no. of items in related record "task details" which is populating in relationship of caseDetails in same rule input or local variable. Count or length both are returning count as 1 only. But, if I make any changes in loaded tasks list and it's updated on any user action then count is showing correct count of items in that relationship.

Hi I have created a functionality in Appian to show complaint details in a grid where i have Complaint logged date. Additionally, I've set up a report tab where the same information can be exported. However, I encountered an issue with date discrepancies after changing Appian locale time zone Central America to New Zealand. The complaint logged dates in the grid and report are different now. How can I resolve this?.

I Have a Requirement like, I have a Process Variable called 'DETAILS' which is of 'RECORD TYPE'.post submitting a particular form the data will be writes to Records. Then I have to use a Script task in order to change the PV 'DETAILS' Type from Record to CDT and use the PV as a CDT type value for upcoming nodes 

I have a record lets say A thats a child of record Parent. I will create multiple reports for Parent from child record. Record list action should fetch the parent id from the child record where i am going to configure the record action field and that value should be passed as process model parameter

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?

Are there ways of using of process mining and RPA together or taking benefits of Process mining with Appian App Designer?Or Process Mining is altogether a separate tool with no possibility of connecting it with RPA or Designer?

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 ?