Data Fabric

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

Record sync is failing due to this error : Unmapped record fields. 1 record field is not mapped to a source field. Update that field before saving the record type. I checked the correspoding table all the fields are in record type are properly mapped in data model but still the error is not resolved, is there anyway to fix this issue Thanks in advance

I have a scenario where I need to extract the read-only grid data into excel. For example, I have a read-only grid with 5 columns. For the grid data, I have applied the "multiple drop down" field for the 3 columns and I'm filtering the data. Say, I have 1000 data in my read-only grid, out of which I have now filtered only 500 row data. Now my grid displays 500 data. How to extract these 500 row data alone into excel. I don't use record type, (so ruling out the default export to excel option available in record type). I want the dynamically filtered 500 rows into an excel. Please suggest how I can achieve this? Thanks in advance!

Hi Everybody, Has anyone had success implementing data synced record types on database tables that use GUID unique identifier as database fields? In one of our example tables the primary key uses unique identifier. I can configure the data synced record type and perform full sync with the record. But when I use the Write Record smart service I get the following error. Unable to write to the source due to system error.Error Details: The generated key type is not supported. Unable to cast [null] to [java.lang.Number]. Workarounds involve using the Query Database smart service to execute SQL Statement for inserting then running the Sync Records service. But I feel like we are losing value having to resort to Query Database smart service. Asking the community if there were any success stories using unique identifier data type with their data sync record types. Thanks In Advance

I want to use record type User FIlter. However when I use the filter has around 50 options for the labels and options even if the actual grid only 2 or 3 options. Is there anyway to to limit the option of Label and Values according to Record Value. a!recordFilterList( name: "Assignee", allowMultipleSelections: true, options: a!localVariables( local!assignees:a!queryRecordType( recordType: 'recordType!{4390cf3b-8f80-4bfd-adfa-b06cb2562f7d}Job Corps Response', fields: { a!aggregationFields( groupings: a!grouping( field: 'recordType!{4390cf3b-8f80-4bfd-adfa-b06cb2562f7d}Job Corps Response.fields.{assignee}assignee', alias: "assignee" ) ) }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!assigneesList:property(local!assignees,"assignee",null), a!forEach( items: local!assigneesList, expression: a!recordFilterListOption( id: fv!index, name: fv!item, filter: a!queryFilter( field: 'recordType!{4390cf3b-8f80-4bfd-adfa-b06c

so as you can see in the grid below. There is only two items on the entire grid.  But look at the options for the GRID Filter. There are over 50   The reason that there is more than 50 items is because is getting the entire set of Assignees on the entire Record. However this an specific item from the record, where there is only 2 items on this record, There is no need to display all those other options on the Record Type User Filter. Is there a way to do this? Or am I obligated to create a Costume Filter?

While Im using the grid field to display the record data and applying filters to it, I couldnt get any data. The grid is displayed as empty. Please find the screen shot of my code. I have used 2 queryFilters inside the filters section of gridField. Can we use two filters? I have the scenario to dropdown and dynamically filter more than 2 columns from the record. Also I get the warnings from line 99 for rest of the gridField parameters.