Data Fabric

So, i want to update a related field of a record, that contains an array of records. Im trying to do it by using append, but no values are stored into the field.   Anyone knows if there is a way to achieve this? Doing it in the initialization of the object works, but i need to update it on demand. thank you very much!.

Description: rule!OE_QueryOneRecordTypeByForeignKey(recordType, fkField, value) Gets a record based on its foreign key field value recordType (RecordType): queried record type fkField (Record Field): foreign key field value (Number (Integer)): integer value searched a!localVariables( local!queryData: a!queryRecordType( recordType: ri!recordType, filters: { a!queryFilter( field: ri!fkField, operator: "=", value: ri!value, ), }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 1) ).data, if( a!isNotNullOrEmpty(local!queryData), local!queryData[1], null ) ) if it was OE_QueryRecordTypeByForeignKey, then you simply remove the [1] indexing

Hi teamHere is my scenario:I am busy changing my application to get rid of CDTs and use Record Types instead. As I understand it this means I have to change any query using queryEntity to queryRecordType.Here is an example of an existing expression:{ a!entityData( entity: cons!SAM_DSE_SOFTWARE_STATUS, data: reject( fn!isnull, a!forEach( items: { { uuid: cons!SAM_UUID_SOFTWARE_STATUS_APPROVE, name: "Approve", order: 1 }, { uuid: cons!SAM_UUID_SOFTWARE_STATUS_BACKLIST, name: "Backlist", order: 2 }, { uuid: cons!SAM_UUID_SOFTWARE_STATUS_REJECT, name: "Reject", order: 3 }, }, expression: a!localVariables( local!status: rule!SAM_getSoftwareStatusByUUID(uuid: fv!item.uuid), if( isnull(local!status), 'type!{urn:com:appian:types:

Hellooo! Does anyone know what might be causing this issue? We're currently facing this predicament in the entirety of our environment.  Is there anything we can do in Appian to address this? Help would be gladly appreciated.

Hello, I have two record types that are related to each other, but when I am trying to retrieve with relationship.relatedRecord.field, it displays only null, what can be the problem? How can I fix it?

Can someone guide me how to disable data sync option in record type with proper images guidance ?

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

Where is option of Prep Mining In Process mining?According to Process Mining Training it says "When you log in to Mining Prep, you'll see two main tabs: Transformation Projects and Data Management."I'm unable to find any option like Mining Prep

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?

Hi,  I was extracting the list of all process models using send email node in PROD using system logs. hc-process-nodes and hc-process-models files displays the process models and nodes but the list is not comprehensive. hc-process-models excel file does not contain all the process models. 1. How can I get list of all process models in PROD environment. 2. How can I get list of all process models using "send email" node in process models. 3. How can I get list of all process models using "receive message event".

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 Folks, Is there any other approach we can use for displaying active tasks on UI except the active task report and storing in DB and fetching it.

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

How do I edit these labels when getting data from a Record Type?I see in docs, that you can edit the labels when using a!chartSeries, but in my case I'm not using that. My code for barChartField looks like this: