Records

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.

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, 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.

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