Records

Hi All, I am using record type and using record type fetching data in UI and Data source is type using View  and Date Time field is type datetime(6) Example UI: I am facing problem in Data time field when I export and downloads the excel , the date time field in excel file is not showing the time zone similar to the UI. I want to show the datetime field to appear in excel similar as UI . Thanks 

If I have 1000 records that I want to add to the database in smaller chunks, how should I design a process to accomplish this? I have a few potential solutions, but I'm unsure about their performance implications: Implementing a loop: In each iteration, I would send data in manageable chunks. Utilizing an XLSX file: I could create an XLSX file and then use the Excel to Database smart service to transfer the data. Using a stored procedure. However, I need clarification on the most suitable approach in terms of performance before implementing this functionality.

Hello Community, I am using record grid as landing page on site along with record action of create Record. After successfully creating record through the action it is going back to the Grid but is it taking sometime to refresh and show the updated grid. I have updated the refresh interval to 30 seconds which is the least in the options. Is there any solution to automatically refresh the grid after record action or set the refresh interval to least time(5 to 10 sec).

Hello,We have a requirement in our running project that we need to migrate our database(MariaDB on-premise) to MySQL on-premise DB.Currently in our applications we are using CDTs and records and my concerns are- In Appian system, what are the changes we need to do? Is there any impact on existing filters, summary views, and etc. if we change the source of the records? Any impact on existing DSE object? Can you please suggest the impact on any other artifacts in Appian? Thanks!

Hi everyone,we have a database of 3/4 tables, which we have connected via record type relationships. There is an interface as a user input task of a process. It shows a list of elements of the primary table, it has 9 columns, some columns are field of the record type, some columns show the details of the related record types. After scrolling through the first 50 pages (therefore arriving at 500 items) the Memory Circuit Breaker error appears on the screen. Am I doing something wrong? Is it possible that record type paging doesn't manage memory allocation? Thanks, Dalila

Is there a way I can use one record action in two different places with different display names?

Hi all, grid field is showing the error when I am query entity to view the data in the interface, the CDT are of the ARRAY type. when I am removing the filter I am getting this error if I keep the filter I am getting another error. can you please help me with this error.  a!localVariables( local!VerificationDecision, local!listingetails:a!queryEntity( entity: cons!SHA_LISTING_DS, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field:"propertyTypeIdFk", alias:"propertyTypeIdFk" ), a!queryColumn( field:"propertyName", alias:"propertyName" ), a!queryColumn( field:"propertyAddress", alias:"propertyAddress" ), a!queryColumn( field:"propertyDescription", alias:"propertyDescription" ), a!queryColumn( field:"floorPlanName", alias:"floorPlanName" ), a!queryColumn( field:"neighborhood", alias:"neighborhood" ), a!queryColumn( field:"price",

Hi Team, Last night, The record sync got failed but now it synced. -Reason:  The system has failed this sync because it exceeded the 4 hour time limit Is there a way to check why it took 4hours to execute?

I exported my all records from my record type but in excel sheet it is not showing correct date and time for dateTime field , and also there is no timezone in excel sheel, below is the screenshot for the problem, expected time (10/03/2023 PDT)

Hi Team, Sometimes, the data was not available on UI and it is available on DB. What could be the scenarios, would this be a performance issue?

Is there an option to delete an unused action? I was following the tutorial and adding a new action on Record Type. I realized, that I chose the wrong option, and created the action without auto-generated Process Model and Interface.I didn't know how to remove the action, so I thought, that maybe if I remove the empty Process Model and Interface associatedwith the action, it would dissapear. Doing that however only made things worse, as now I couldn't create a new action, due toan error on the existing one (Process Model not found), so I had to put it back in. Now I have two actions, one of which is not needed. How do I delete it?

I have a read only grid  contains 1 column with clickable link, when I will click on the link field then it will suppose to open a grid consist of related data below that row.   How I can achieve it ?

I was doing some User Filters for some not synced Record Types that sources from web requests And noticed that when there are two possible labels with the same text inside a a!recordFilterChoices it raises an error saying that the labels are duplicated even when its selection values are different. But, this behavior is not present on a!multipleDropdownField, it works just fine as shown below: Is it possible to replicate this behavior to a!recordFilterChoices as the label is something that the user can freely change and that change can lead to a more fragile and prone to error system ? Thanks in advance, Best regards [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi,I've already used the updatedictionary and update functions with CDT, but how it works with RecordType? Could you show me the correct syntax please ?/* works fine with CDT */ local!dataVehicles: a!queryEntity(...), local!vehicles: a!forEach( items: local!dataVehicles, expression: a!update( data: fv!item, index: { "id", "model" }, value: { 1, fv!item.model } ) ) /* does not work */ local!dataVeh: a!queryRecordType( recordType: 'recordType!Vehicles', fields: { 'Vehicles.fields.id', 'Vehicles.fields.model' }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!vehicles: a!forEach( items: local!dataVeh, expression: a!update( data: fv!item['recordType!Vehicle'], index: { 'recordType!Vehicle.fields.id', 'recordType!Vehicle.fields.model' }, value: { 1, fv!item.model } ) )

It is very difficult to figure out what should be the inputs of the mentioned fields on this page.Can someone please explain what input should be given in each of these fields and especially on the "Connection String"?P.S: Don't give links to documentations.Your help will be highly appreciated.Thanks

Hi Team, I have a record type for orders and it is pointing to orders table from maria DB. The data in the record type is not matching with the data in the DB, what could be the scenarios?

I created a grid with recordtype, I have 10 fields in my recordType but on grid am showing only five fields, when i click export to excel button it exports on five fields data, but i want all of the field should be exported.

Used a!RecordFilterList in a record type. It is working fine but a default dropdown option "any" is coming, want to remove it is there any way?

Hi EveryOne, when I'm Publish the Data Store Entity I am getting the following error: can you please help with this. Thanks...

I created a record type before in my application and right now I don't need anymore. I tried to delete from application but I got it this error. What is the problem?

Every where we can use the record over the cdt. what is use of cdt over record? where can  we use cdt instead of Record? 

I'm working with data via API that uses composite keys and need to store the data in Record type. However, I understand that composite keys are not supported in record types. Could anyone suggest a way to handle this situation or provide any workarounds?

I wasn't able to delete the last question previously, as it was not required anymore. Then I just turned it into to this new question, and I want to know if is that possible to delete a question in "Discuss" forum, or why it is not. Thanks in advance

Hi All, In the database the createdBy field holds "userid@test.com" which is the userid of the user. When i create a recordist using the respective table and have the OOTB search on createdBy field to get the record on  using  "John" or "Smith"  as the search value , it doesnt return any record. But if search on email return the data. ( Note: John and Smith is the first and last name of the user). The custom grid in front end holds the Display field using user function. But as the recordlist is created on userid , search on First or Last name is not returning any record. Multiple options tried: 1) Created a custom field , but user function cannot be called in custom field                                     2) Changed the data type field from text to User type  in the mapped fields of RecordType and called in recordlist . Still

Data I got from CDTdata=[date_month:1,templateId_count:3,templateName:Accident / Near Miss]; [date_month:1,templateId_count:22,templateName:DFTC Lousado]; [date_month:1,templateId_count:12,templateName:Duplicated items process]; [date_month:1,templateId_count:3,templateName:ESP Summary Report]; [date_month:1,templateId_count:2,templateName:Every Month]; \ Need to be transformed like data= [date_month:1,"Accident / Near Miss":3,]; [date_month:1,"DFTC Lousado":22]; [date_month:1,"Duplicated items process":12]; [date_month:1,"ESP Summary Report":3]; [date_month:1,"Every Month":2]; or  data= [date_month:1,"Accident / Near Miss":3,"DFTC Lousado":22,"Duplicated items process":12, "ESP Summary Report":3, ,"Every Month":2] To use it in a stack chart plot date_month on the 'x' axis. How to achieve this?