Data Fabric

I created a simple RecordType and defined relation with User for createdBy and modifiedBy. I added recordlist to new Site. It was working few days back. Today I am getting the following error.  Nothing has changed in last few days. The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = HE53D] at function a!recordList: An error occurred while retrieving the data for "User". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000). Synced the recordtype few times through manual or data edits through data preview screen. Please help me with why this is happening today? 

Hi Expert, Can we use a POST integration API which actually queries data from a third party system to configure as a Sync Record Data Source, if yes  then how ?I have created an expression to get the data using the integration object which is working fine in the Expression rule while throwing error on using the same in Record Type. Thanks, Gaurav Singh

We have 3 records in our application say record A, record B and record C. Record A is having one to many relation with record B where record B is having one to many relation with record C. Record A is having generic details, record B is having section details which can be multiple and record C is having one editable grid having multiple entries which is present in the above section. We are facing issue while displaying and saving the value into the rule input since we are not able to use [fv!index] for record variables. We are using only one rule input of record type A. How to make sure to show the values properly and save them properly?? This is just a mock UI i created for explaining the issue. Add member will add one more row in developer details grid. Add Team will repeat the whole section again.

Hi Experts, I'm getting following error while deploying the record type object to higher environments : "Record type Test Expedited Order cannot be synced because its record fields do not match the fields in the source. (APNX-2-4195-003)" I'm using two sync enabled records "Test Expedited Order" and "Test Authorized Agency" with many to one relationship between these two records where mapping is as shown below.As of now I have to manually update the mapping of the record type post deployment so as to make it working. And after updating the mapping and saving it there is no difference in the version of record. In above image the highlighted once are the version created due to deployment where as the latest one and the version 2 are after manually updating the mapping. Is this a known issue with the records type or is there a way possible to get this fixed. ?

I am inserting excel data to data base using write to data store entity smart service  .  I need to inset two more fileds of data which is user inuput data which will be entered when uploading the excel  through the write to data store entity  .  I don't know how to acheive it. Can anyone help me?

f I initially leave some fields unmapped in a record type and later decide to map them, what happens to the data in Appian? What should be the best practice? Let's suppose for instance that the system will need some unselected fields soon, but not yet

I'm trying to save the filter with Or and 5 criteria. but it only let me save 4. do you know any workaround or what is the litmit of this a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(field: "year1", operator: "<", value: 2021),a!queryFilter(field: "year2", operator: "<", value: 2021), a!queryFilter(field: "year3", operator: "<", value: 2021), a!queryFilter(field: "year4", operator: "<", value: 2021), a!queryFilter(field: "year5", operator: "<", value: 2021) } )

Hi I have a table in my appian/Jdbc database and I am using write to Dse smart service to persist data into that table. Is there any log file in the system logs which tells me what data is written to what table and the timestamps ? Thanks

Hi Team, I have to show KPIs information in Dashboard based on a specific user logged in and for a specific status. For example, For user1 when he/she logged in, he wants to see how many active/completed cases showing as KPIs Dashboard. I don't want to handle that in the interface, because that will take a considerable amount of time and hit the performance. Instead, I want to store that info somewhere for example in custom record field; but again, I am not sure that also feasible. FYI: assignee info and status are part of the case table not in any related record. Any other suggestions? Regards, Ghanashyam

Hi Team, I have two CDTs with a one-to-one relationship, which I have already designed and stored. Now, I plan to create records from the database tables. However, I encountered an issue when trying to define the relationship in the records due to the existing CDT data model design. In my current setup, the child table's primary key is used as a foreign key in the parent table. My requirement is to fetch the parent table data along with the corresponding child table data. However, with this setup, I am unable to establish the one-to-one relationship in the records as intended, and I prefer not to make any changes to the existing CDTs. Could you suggest a solution or provide guidance on how to achieve the desired relationship in Appian records without altering the CDT design? Parent :TP_EmployeeDetails TP_EmployeeAddress

Hello, all I have been requested to use the record picker component and use the selected records in the picker  to filter out the records (by identifier) in a read only grid.  The record picker returns a list of variant and I need a list of integer in order to use the filter in the grid, otherwise it will return an incompatible type error. Is there any way this can be done ? the local!selectedApprovalID does return the values I am looking for, but I am getting an error :  " Cannot apply operator [IN] to field [approvalId] when comparing to value [TypedValue[it=197,v={TypedValue[it=1,v=12],TypedValue[it=1,v=23]}]]." There was an answered question in this forum to use the index() function, but that also returns the same error. Please help,   been stuck with this issue for some hours now. Thanks.

I have the requirement of adding Event history comments for a record. As the comments needs to be encrypted, we can encrypt the data once it's written in DB. While getting the data in record I am decrypting the comments in the Record List Configuration. I am getting the decrypted comment in the record List but in the interface of Event History I am getting the encrypted text (same as DB) even after syncing the record. As in image, I want to apply the same decryption rule as "details" parameter over "comment" parameter. Let me know if we can leverage any function or is there any work around for this.

Hi, I am facing issue record type syncing system failure, after updating record in process. The primary key i am using is BIGINT type.

how many related actions and record actions can be added in record, is there any limit?

While testing a connected system point to a Postgre DB we are getting Test Failed. Where is the log file to find the details of what is causing this

Hello,  I have a problem creating a query in Appian, which was previously created in SQL. Basically, we have 2 tables, the main one with the CASE numbers and the status, and another one where we record the historical movements of those cases: Main Table : CASE IDCase Status 1 Active 2 Active 3 Active 4 Close 5 Active Secondary Table: HistoryCase IDHISTORY IDCASE LogText CreatedDT 1 1 Created 11/23/2024 10:34 2 1 Updated 11/23/2024 10:34 3 1 Assigned 11/23/2024 10:34 4 1 Updated 11/23/2024 10:34 5 1 Closed 11/23/2024 10:34 6 2 Created 11/23/2024 10:34 7 2 Updated 11/23/2024 10:34 8 2 Assigned 11/23/2024 10:34 9 2 Updated 11/23/2024 10:34 10 2 Updated 11/23/2024 10:34 11 2 Updated 11/23/2024 10:34 12 2 Closed 11/23/2024 10:34 13 3 Created 11/23/2024 10:34 14 3 Updated 11/23/2024 10:34 15 3 Closed 11/23/2024 10:34 Our SQL query has subqueries, where we look for the last "Update" of each "CASE", so one we h

Hello, Record Type Excel Download is giving unusual value as 'TypedValue[it=3,v=Completed]', in place of 'Completed'. But, in the DB View, value is present as  How to fix this, as Export to Excel is a OOB feature and can't be coded. Can someone help with this.

Hello, Its my first time working on reports. I am trying to generate a task report type and i am choosing context as tasks by process. I want to get a list of tasks in the process instance. However, everytime i open the report, i cannot see the latest instance details. I need to add it manually to view the details. Can anyone please help me understand if i am missing out anything?Thanks in advance!

While adding or deleting records in the grid, the filter values are not refreshing automatically. Although the record syncs successfully, the issue persists specifically with the filters, requiring a manual page refresh to reflect the changes.Below filter code a!recordFilterList( name: "Name", options: a!forEach( items: index( rule!MWM_QRD_getExternalUserData( filters: a!queryFilter( field: 'recordType!{33ea4758-97d4-474a-82f2-274f130f5bee}MWM External User.fields.{7ff5fb03-52c4-49cf-ad2d-42f1379be38e}isActive', operator: "=", value: true() ), totalCount: false, ), "data", 'recordType!{33ea4758-97d4-474a-82f2-274f130f5bee}MWM External User.fields.{3ea25a9f-4b80-419f-bf3d-fedf3782448a}userId', {} ), expression: a!recordFilterListOption( id: fv!index, name: rule!MWM_RULE_UTILS_displayUser(user: fv!item), filter: a!queryFilter( field: 'recordType!{33e

Hi Appian community! [emoticon:b7bcfd5903f14440addb24344907da6e] I’m a recently certified Associate Developer, and I’ve been working on a scenario that I’d love your thoughts on. It involves translating SQL logic into Appian to make the most of a!queryRecordType. Here’s the use case: I have two tables: Main Table (CASE): Contains the case ID (IDCase) and its current Status. Secondary Table (HistoryCase): Logs all historical movements (LogText, CreatedDT) for each case. Goal: Find the last "Update" (LogText = 'Updated') for each case. Exclude cases with Status = 'Close'. Only include updates within a specific date range (e.g., 2024-11-01 to 2024-11-30). Order results by IDCase. Here’s the original SQL query I’m trying to translate:SELECT * FROM ( SELECT IDCase, CONVERT(Date, MAX(CreatedDT)) as 'CreatedDT' FROM ( SELECT A.IDCase, A.CreatedDT, A.LogText, A.IDHISTORY, B.Status FROM [dbo].[His

Do we have an option to refresh related actions appearing at the top of an record view without manually refreshing the browser? Kindly suggest. Thanks

Hello Folks, Am facing one issue where am using read only grid in that we are displaying the data using a!recordData. When am going to second pagination  in one of column am doing on operation like toggle on/off  immedetily read only grdig showing frist page instead of sendconf page where am did the operation. Can any one please suggest.

Hello everyone, I’m experiencing an issue after changing the structure of a record in our development environment. Since we don’t have direct access to the database where the records are stored, we had to send the scripts to the client’s database admin to execute and reflect the changes in test environment. Now, the fields are the same in both the DEV and TEST environments. However, at first, the record in TEST failed to synchronize, showing an error related to the record. After manually re-syncing, the synchronization succeeded. The specific error message is in the execution of a process model, in the Write Records node: Unable to insert to source because the sequence PARTICIPACIONES_SQ is not valid, does not exist, or is not accessible. The Write Records node is actually trying to save the "Relacion Socio" record, which has a one-to-many relationship with "Participaciones" (the record that also underwent structural changes and is now synchroniz

Hi everyone,i am unable to call the process variable name in the report,it's showing error in the report if i call the process variablecan any one help me with it ,i have attached the image below,

Hi, I created Record type but, I need to create record fields manually so for that Create From Scratch option should be enabled but I don't see such option here so could you please help me to resolve this query? FYI