Data Fabric

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? 

for example my array size is 3400 in the first write - 1 to 10002nd time write 1001 to 20003rd time write 2001 to 30004th time write 3001 to 3400 How we can achieve this one  can anyone help me out  TIA

We have a process where data from a third party system is imported daily into Appian based on a scheduled time of process model. Currently we are using the sync record web service to manage this data transfer. However , we are not using any data base in Appian. we're concerned about the 4 million record limit of this web service sync record. What happens when the record count reaches to the 4 million limit? is there an optimal approach to manage this process in Appian to avoid reaching this limit or any best practices for managing large volume of data with Appian record sync .

We have created entity backed record using database table. That time length of column was 50 character later we update to 100 but source field is not taking 100 it still shows 50.Anyone knows how to update column length?

Good day experts!  I am attempting to merge two maps and have gone thru many examples from the forum but can't seem to get those solutions to work for my use case. I have two maps that have different key value pairs that I want to merge into one map.  The example in my code shows that the maps are related by participantId.  I was able to get the key and value for one of the keys in the queueMap to update into the participantMap.  However I am struggling with getting all of the keys and values in queueMap to update into the related particpantMap. Here is my successful attempt at just getting the first key value from queueMap to update into participantMap: a!localVariables( local!participantMap: { a!map( participantId: 3402, blockId: 881, policyNumber: "VF80U16350", policyEffectiveDate: fn!date(2023, 9, 25), dateOfBith: null, firstName: "Bill", lastName: " Johnson", middleInitial: "W", ssn: "123456789",

Hi,  Can some one let me know what needs to be done for the below error? System tried to sync on nightly basis and failed and didn't provide any details on the same. Tried to look into the sync history but it didn't provide any details. Note: There was not change in the data in the past day.

I have a grid based on record, this record has defined user filters.  The client asks me that when he selects a filter and clicks on the details of a case and then returns to the main screen, the filter selection is not checked. Is there a way to reset the filters of marked users without manual action by a user?