Records

Hi  In Record related action context i have passed like this  to get request id details from query  rule!Cust_QE_getRequest( requestId:rf!requestId, returnCastedData: true) when i am trying to access related action getting error like below could you please suggest on this An error occurred while applying the context for the MHK Data Case related action [identifier=1,356]. Details: Could not cast from Check_testRequest?list to Dictionary. Details: CastInvalid

Hi all, I'm currently looking into using Appian records for the first time, and had a question (I've tried looking through the forums and documentation). When you configure a record list action to call a process model, is it possible to provide multiple parameters to the process model from the interface where the record action is being called? For example, I have a grid that's displaying record data. I'm trying to configure a record action, which calls a process model, which requires multiple process parameters to be passed in to it. When looking at recordActions, I see it takes in a list of a!recordActionItem(), but these only seem to consist of an action and an identifier. I know there's the option to provide static values to the process via the context field of the related actions in the record type, but if I have a local variable (for example) in my interface, can I pass it to the process model being called in the record action?  I hope

I just export data via Export to excel functionality of record type. Is it possible to add time zone stamp on "Exported On" field ??

I have a very basic question:What is difference between passing an input data vs output data in a script task? Or perhaps an example or a scenario where both can be used? Thanks in advance [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hello everyone, I have 3 record types. "Orders", "Products" and "Order Product Variations" (relationship).Orders (id, createdOn)Products(id, categoryId)  *category must be equal to 5Order Product Variations (id, productId, quantity, createdOn) I want to create an interface that shows which products are ordered for each day. The orders products that are included for each day are from the previous date at 09:30:01 to current day at 09:30:00 I want to have a counter for each product (including the quantity) I want to ask what is the best way to proceed with this. This interface will be used by the Canteen Manager to prepare lunch orders for employees. At a later stage I will try to show which employees ordered each food. Case scenarios: ##########Case No1################### Today: 23 Feb 2024 08:00 AM 1st list el:--------------------------------------------Orders for 23/02/2024 Food A                 qty: 7

Hello, I am trying to make use of the new function: a!urlForSite() It seems like a great use case for a!urlForSite() is to pass data to a site page that shows a record list, so that the user can be directed a filtered set of data. As far as I can tell, this can only be done using custom components to create filters, and cannot be used to pass data directly to ootb user filters. I usually try to avoid using custom components as filters because these cannot be saved as user filters and they don't appear in-line with the search field. Am I missing something? Or is passing data to user filters still not supported?  Thanks!

Hi Team, We have multiple sections in the form and user will be updating them in between of time. (Interval of 5, 10, 15 minutes or an hour) User want data to be saved as soon as they enter or select on the form and no save button. I am thinking of off focus save like when user enters data and come out it should be saved in the record/db. Challange is what if they change the data. Can you suggest any other way to handle the requirement considering performance point and no data loss.

Hi, I am trying to write data into DB using record type which is multiple. Process variable had data correctly but when it is writing into db the data is writing as  null though source fields and record fields data type is same and structure is same. Can someone help me on this?

Hi All, We have  recordtype actions configured as dialogs for create and update of record. In the popup UI, the dropdown component not showing the drop-down values on the press of enter key when 508 tool ANDI is enabled. and the buttons (close or create) is not triggering in the case of the dialog format UI. Could anyone suggest what can be the approach to resolve the 508 issues? appreciate the suggestions. Thanks in advance for same. Raj

I have 2 rule inputs one is prevData and another is UpdatedData . I want a rule expression that will compare the two rule inputs and return the different fields and values from prevData rule input . And the I need to add the fields and values to another rule input which will be a input for write record smart service . Can anyone help me with proper steps ,please !

Interface Definition: Expression evaluation error at function a!gridField [line 212]: Invalid field identifier: "#"urn:appian:record-field:v1:f93971d1-a676-475d-bcde-b5eb7ffea268/66d74798-e23e-48d6-8801-b307250c1052"" I am getting data from external system and mapping it into Appian. I am mapping it to appian record since will be storing it using write to record. I wanted to do sorting on all the columns using code below but getting this error when trying to sort:

Hi, Unable to sync the data in records below is the error and also screenshot. Unable to sync due to an error in the Record Data Source during batch number 2 Record Type Sync Alerts Record Type SG PersonDetails Source Type Web Service 1 item available Alert Caused By Unable to sync due to an error in the Record Data Source during batch number 2 The Record Data Source did not apply the batch number correctly. The first two responses returned the same data.

I have a record type named Patient and in that there are columns like Name ,Age and Gender. I need to store the value in Gender as M and F. There is another recordtype named reference and there I have 2 columns such as gender code and gender name .There are 2 records ,one is gender code M for gender name Male and second is gender code F for the gender name female .When I am displaying the record list I need to show the gender values as Male and Female instead of M and F by mapping to the recordtype reference . Please tell me how to configure this .

I have a table with 1:M relationship, as stated in 23.3 I can update with just one write records smart service, how to pass related data there

Hi, everyone! So we have a database table that has 100+ columns. But in Appian, record types have a limit of 100 when it comes to number of record fields. Is creating a 2nd record type sourcing from the same table an appropriate solution for this? If not, what would be the ideal way of doing this? Would gladly appreciate your help. 

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?