Data Fabric

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.

Sync records smart service is failing with error 'New data cannot be written while the record type is unavailable.'Note: I'm a admin for the particular record for which it is failing

I'm working in an environment that has a large number of folders (300k+) containing a variety of documents. The environment is getting on the full side so I would like to find which folders have large amounts of data. Is there some way to sort or search for folders based on data size so I don't have to open each one individually? 

Hi, Please help me how to know the exact solution for this error  my data is something like this {"{""siteId"":""AB0401"",""question"":[""Help me with the details of the aforementioned site id."",""How is the Employee responsible for the site id"",""What is the structure Type and Tower owner of the site Id"",""Help me with the maestro activity associated with the site Id"",""Help me with more activities"",""On Air Activities associated to AB0401 site Id"",""Help me CFS file details in AB0401"",""CFS details\n"",""Help me more details on **Activity:** UPGRADE (Add 800)"",""Help me with all the PDF file Type associated with site Id Ab0401 in the CFS Folder"",""\nHelp me with all the details associated with site Id Ab0401 in the CFS Folder""],""response"":[""The site with the ID 0DE1F589-BD93-40BD-9420-1E7EBE802A7E is the Canada Olympic Park site located at 8525 BOWFORT RD NW, CALGARY, AB, T3B2V2 in Alberta. \n\nHere are some key details about this site:\n\n- Site Name: Canada Olymp

We are migrating from deprecated 'executestoredprocedure()' to new a!executeStoredProcedureForQuery() function to call one stored procedure.  We have been receiving correct result with existing  executestoredprocedure() , however when we replaced with new function it's throwing below error, "Failed to process the stored procedure result due to encountering a duplicate column label: processParametersConfigId." Please let me know if anything needs to be changed in SQL script to use new function. Below is code to call SP, Below is actual Sql Query in SP, Thanks.

Facing the following issue when I tried Record Type Tutorial (Web Service) from the documentation Expression rule and integration for this tutorial are as follows Please provide suggestions to resolve this issue

I need to query the Appian database (MariaBD) from my KPIs application. What would be the best way to do it? Does Appian have any webservice available?

We are running a process based on given exact Date Time which is stored in UTC entered by the user in the UI with schedulers. Lets take example the scheduler planned to run at 11/10/2024 12:00 AM,  and its stored in DB as 11/10/2024 -4:00 UTC. When time zone change from EDT to EST its coming as 11/09/2024 11:00 PM which kicks the process 1 hour before which is not expected. I'm wondering so all the dates entered or captured in DB during EDT will be shown in Appian as  Actual time - 1 hour. Isn't this unusual?

Hi All, I have created a new custom record field for a record type - this new record field depends on a relationship with another table . So when I'm writing to the child table(relationship table) how long does it take the main table with the new custom record field to get updated? I'm asking this because first I write to the child table then I want to write to the main table using this new custom record field for a calculation. The issue I'm facing is that the main table record field is not getting updated quick enough before it writes - its considering as if the new custom record field is empty , I tried adding a sync node before writing to the main table but is still not working. Any recommendations here?

Hi teamI'd greatly appreciate some assistance with this issue please Table setup: Table 1 - CMC case type 1 (Onboarding Case) fields onboarding case id onboarding case parent id milestone id Table 1 - CMC case type 2 (Onboarding Subcase) fields onboarding subcase id milestone id Table 2 - Onboarding Case id case id = CMC onboarding case parent id  Table 3 - Onboarding Subcase id case Id = CMC onboarding case id Note: Each onboarding case can have multiple subcases. Each subcase represents a product to assess. The flow goes roughly like this: show list of products -----> select one product -------> update selected product milestone -------> start assessment process This part works fine but I need to find a way to update all the unselected rows so their milestone value can be changed.Any ideas? Blessings Stephen

Hi, I have a data like  { 'type!{urn:com:appian:types:CB}CB_Builder_Checklist_And_Items'( 'checklist': 'type!{urn:com:appian:types:CB}CB_Builder_Checklist'( 'id': 32, 'name': "Test", 'description': "Test", 'owner': "", 'use_group_additional_owners': false ), 'checklistItems': { 'type!{urn:com:appian:types:CB}CB_Builder_C_Item'( 'id': 47, 'name': "Test1", 'item_type_id': 6, 'isInterval': false, 'validate_answer': false, 'owner': "", 'use_group_additional_owners': false, 'choice_multiple': false, 'mandatory_comment_fail': false, 'description': "Test" ) } ), 'type!{urn:com:appian:types:CB}CB_Builder_Checklist_And_Items'( 'checklist': 'type!{urn:com:appian:types:CB}CB_Builder_Checklist'( 'id': 47, 'name': "Test", 'description': "Test", 'owner': "", 'use_group_additional_owners': false ), 'checklistItem

I have a scenario where i should enable the multiple selection in filter to this i have to use only include operator because the values stored in the tables as Labels & Values example(test;55). Currently i am using the below logic where it is working for 1 scenario and not working for expected scenario For example, 1. For the one Product id it is giving as the below result 2.If i pass one more product id on the Suspect Product filter along with the Primary Id in the 2nd filter it is giving the null result but actually it should return me the 3 set of records  Please suggest how to get the records by using Included operator with multiple values

Hi All, I have an interesting use case where the client wishes to open a 'Task' within a 'Case'. For Context, we have a design where our Case has a one-to-many relationship with Tasks. We have a 'Tasks' View on the Case record which has a selectable a!gridField where the end user can select a Task from the grid. This populates a Task screen below with data and record actions for the selected Task. The client would like to navigate to the Case record -> Tasks View via both the a!recordLink() and a!urlForRecord() with the Task already pre-selected in the UI. The client is not willing to have the link navigate to a Task Record as they find it confusing and do not want the User to leave the top level Case Record. Is there any workaround I can use or is linking to a Task Record directly the only option available? Many Thanks for your time, Zac

Is there any to find the size of the data that is returned by a query?? The default size limit is 1MB, but we want to understand how much rows we can pull from database without reaching this limit.

for a particular record type object getting following error message : Expression evaluation error [evaluation ID = HGT9M] : Could not find driver for MariaDB.since we are using mysql but getting error on MariaDB

Hi, I am using bigint for storing codes, account numbers(as they can go upto 15-20 digits) in SQL. I need to use them in Appian. Is there a way to map tis data?

can we make one user filter dependent on other. For example if we select category user filter then only corresponding sub category values should be shown in sub category user filter.

I'm getting the errorExpression evaluation error at function a!recordActionField [line xxx]: Cannot compare incompatible operands of type Null and type Boolean.I'm not sure why this is occurring.Code: a!gridColumn( value: a!defaultValue( value: ri!recordActions, default: a!recordActionField( actions: { a!recordActionItem( action: relatedAction1, identifier: fv!identifier ), a!recordActionItem( action: relatedAction2, identifier: fv!identifier ), a!recordActionItem( action: relatedAction3, identifier: fv!identifier ), a!recordActionItem( action: relatedAction4, identifier: fv!identifier

I'm looking to configure a filter in a!queryRecordType() that's similar to checking for null values on the outer side of a relationship that behaves like an outer join. For example, I have a data structure as described below. The table Invoices is managed by an Appian application and we have a synced record type based on that table. The table SAP Documents is updated by an external source and we have another synced record type based on that table. There is a many-to-one relationship configured in our record type from Invoices.SAP_DOCUMENT_ID to SAP Documents.SAP_DOCUMENT_ID. Invoices ID (PK) a bunch of other fields SAP_DOCUMENT_ID (FK) SAP Documents SAP_DOCUMENT_ID (PK) a bunch of other fields I need to query the Invoice records and return those where there is a value in Invoices.SAP_DOCUMENT_ID and where there is no corresponding row in SAP Documents - and I need to combine this with some other query filters, so this is not the only co

Hello Everyone, I am trying to insert a record which would be using the Write to Records or Write to Data Store Entity smart service to a table that has a trigger at the backend DB. The trigger is for checking for the existence of a particular value in another  table. If the ID being inserted exists in the another table, the insertion will proceed without any issues. If the ID does not exist in the another table, the trigger will prevent the insertion and typically raise an error. So in the second scenario if  the ID is not found, will the write to records execute normally or would it give an error because of the trigger?