Records

Hello Community, I am using Related Record action to update a case, using Rv!identifier as context to pass the case ID which needs to be updated. And passing the identifier through rule input in the interface using  a!recordActionItem, but it is not taking the correct input(case Id) in this scenario. Any idea why this is happening.

Hi, If a relation does not meet the conditions for getting data, should the output return empty? Example.. The database query returns empty The queryRecordType returns a value This is correct?How can I get an empty value, like in a database? This is a modification of lesson 4 exercise 2, in the associate course certificate. (If I don´t write the "fields: AA Vehicle.maintenance.cost", the output is the same, removing maintenance list) Thanks for the help

Instance of the Process variable(record type) is having two different values but when I configured the event history for that record where the values are storing duplicates. Kindly suggest. Providing below screenshot. Process variable values DB Values Write to Record Event Configuration

Hello everyone, I'm encountering an issue with record type. I have a table in my database responsible for storing HTML template code for each user. When retrieving the data through records, I'm not receiving the full length of the HTML code; it's breaking. The column in the database has a VARCHAR data type with a limit of approximately 65,000 characters, while the length of the HTML code string is only 4000 characters. In DB we have full length code.Can anyone provide assistance or suggest a workaround for this problem?

I am having requirement to show up only the respective record data from the grid in the Site. I have used a!urlForSite(sitePage: givensiteofMyapp) to navigate to the site but to retrieve the exact record from the grid how I need to fetch those details. Kindly provide any suggestion

Hi All, I have a requirement when we display the record.I have configured one user filter named "status" which consists of 5 values. I want that whenever the user lands on the page.. one of the five option from the filter is NOT applied. the value in the Default option should not be applied. {Basically all the other 4 apart from the default value should be in the filters when page gets load} Kindly suggest what can be done as datatype of default option is text and not array!

Hi everyone,  I'm facing a strange behavior when using a!queryRecordType() to query to related record types.  I'm having 3 record types with relationships as below: I'm doing the below query to get all the teams that Shaun is a member of (team A and B).  a!localVariables( local!dataset: a!refreshVariable( value: a!queryRecordType( recordType: 'recordType!Team', filters: a!queryLogicalExpression( operator: a!defaultValue(ri!filterOperator,"AND"), logicalExpressions: ri!logicalExpression, filters: { if( a!isNullOrEmpty(ri!id), null, a!queryFilter( field: 'recordType!Team.fields.id', operator: "IN", value: ri!id ), if( a!isNullOrEmpty(ri!name), null, a!queryFilter( field: 'recordType!Team.fields.name', operator: "IN", value: ri!na

Hello Everyone, We have a database view with 45 columns and it taken 4sec of time(40k records) to execute from database view. Also DT created for this view in appian,  now we mapped this DB view to Record and it was thrown below error:  Expression evaluation error [evaluation ID = fead6:13bce] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit. (APNX-1-4198-000) It's looks like a wired behavior of Record because as per the community it will support 40L records. Could someone help me out to fix the issue.  DS also verified and published without error. FYI, We can't see the data in record after we mapped to DB view and it shown the error message as mentioned above. stdout log here: Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evalu

Hello every one Is it possible to set a process model on a record type summary? I know it can be done with an interface, but I would like to verify if it is possible with a process model. Like in the photo below (i tried it and failed) Thanks

Hi Everyone I have created Process reports using records but i couldn't able to see data in reports & interface as well. I have read  in documentation that it wouldn't show in reports but it will in interface unfortunately i am not able to see in both. Can anyone provide solution to me on this. Thanks in Advance.

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.