Data Fabric

Hi! Does anyone know how can I fixed the next situation? I want to get the date of a datetime using the function todate() but if the datetime is after 9PM (Chile Time), the result for the function is not the real date but the next day and this should only happens when the time is past 12 AM.

I have two user filters in record, is to possible to hide and show second user filter based on value selected in 1st user filter. For example in the below image I have two filters named 1) FEEDBACK and 2) APPOINTMENT DATE,  FEEDBACK filter had 2 values Good and Neutral, Is it possible to display the Second filter(APPOINTMENT DATE) only when we choose Good in the FEEDBACK filter?

Hello Everyone, I am working with record type. There is a requirement to prepare record type using rule input. This is the logic I am using: a!forEach( items: ri!reminderInfo, expression:fv!item['recordType!{e5a6a458-a1b1-4679-91c9-944cecdfdac6}AMS_DG Appointment Reminder.fields.{5515212e-0535-40f5-aa3e-1d92c83c23ca}appointmentId': index(ri!appointmentInfo,'recordType!{5746f330-8c31-4ea7-9807-cbbd2fd557eb}AMS_DG Appointment.fields.{274539be-ac91-4f4c-95ed-69bd50175dae}appointmentId',null), 'recordType!{e5a6a458-a1b1-4679-91c9-944cecdfdac6}AMS_DG Appointment Reminder.fields.{e7f92751-d0c8-4ce6-a252-2bd4b3bee143}createdBy': index(ri!appointmentInfo,'recordType!{5746f330-8c31-4ea7-9807-cbbd2fd557eb}AMS_DG Appointment.fields.{9cc0bbe6-dc99-4b3c-bf8b-e70e36fbbbb0}createdBy',null), 'recordType!{e5a6a458-a1b1-4679-91c9-944cecdfdac6}AMS_DG Appointment Reminder.fields.{82394d77-2331-4196-9d8e-3aaaf57888a3}createdOn': index(ri!appointmentInfo,'recordType!{5746f330-8c31-4ea7-9807-cbbd2fd5

Hello everyone, I have a main process model that contains an input form. I would like to allow users in allowed group to access this input form from my task list interface. I have configured a Task report based on my main process and use the task Id for the process task link in the task list. However when I click on the task from My task list, it is showing "The task may have been deleted or completed by another assignee". What will be the possible solution for this error?' By far I have checked these areas:  - Input form's assignment tab is assigning to a group that contains my account.  - Process is chained probably. - The task ID that I clicked to open is still active (is at the input form node). Could anyone help? Thank you!

Hi everyone,  I have seen 2 posts with same error but didn't find any solution that works for my case.  I have created a view, and a record type with data source is an expression rule that query data from the view. The rule will return me below data subset. When I check the record list, I can see data being presented without any error.   However, when I create a gridField based on my record type's data, I got this error. I checked and can verify that my data don't contain any duplicated row. Is there any other reason that I should look at? Thank you,

Hi  I am trying to write data to a table using write to datastore entity . In production environment, some of the instance is not working as expected. Nodes are getting executed successfully but not writing in db. If i restart the particular node it works. Anyone faced this issue? What could be the issue? Please help. Thanks in advance 

I have a one-to-one relationship between the Loan and UCC Information entities, and I'm trying to add the same relationship from the Loan record, but it doesn't recognize the FK (Only displays entity's PK) from the 'UCC Information' entity for some reason. Any kind of pointer will be  valuable!                                                           Loan Record Relationship Snippet                                                                                       ER Snippet 

Hi All, Currently the Appian OOTB record feature doesn't provide the progress of export. Once we click on export option there is no response for some time , after few seconds the document will be downloaded. There is no way we can show to users that document has been downloaded or at least the progress of download. Does anyone have any alternate hack/solution for this? The excel tools or any other plugins will show the progress option in browser tab, but we would like to use record export. Thanks, Karthik

Hi All, We have a new project coming up, it is expected to have almost around 600,000 records being created in a year. We have one existing application with let's say around 100,000 records using entity backed synced record. My concern here is that existing application performs very slow with 100,000 records and most of the times export to excel fails also with 20,000 records to be exported now if we talk about 600,000 cases I am not 100% sure to use Appian OOB records.  I know we can create different records based on the personas and default source filters to make it work but what if customer wants to see all the records? What could be the alternative approaches to deal with this? Thanks!

An error occurred while evaluating expression: =repeat(count(pv!ordersId), pv!invoice.id) (Expression evaluation error at function 'repeat': Cannot repeat list type) (Data Inputs) so I having many to many relationship names as invoice to ordersId so while mapping data into CDT using repeat function I am getting this above error I want to store 2,1 orderIds  within same invoice 

Hi all, we have a record based on a view in an oracle database. Some day ago we delete some data from the tables from which the view get the data and now the view has 253 rows, but if I open the record list we found 11583 rows. How is it possibile? With this scenario the record should execute the query every time we open it

Hello, I have a field for mobile numbers in my Appian application, but it is in text format instead of integer. Appian does not support 10 digits as an integer, so I cannot change it. I need to sort this mobile number field on a read-only grid, but it is sorting as a string due to the text format. I need it to be sorted as an integer field.

I have a map and a dictionary.. How can I merge them and save the output to a datasubset?

Hi Team, In records we can create a text filed filter. Thanks, Nagesh

a!richTextDisplayField( value: { a!richTextIcon( icon: "check-circle-o", caption: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], link: a!dynamicLink( saveInto: a!save( fv!row, a!update(fv!row, fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], not(fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'])) ) ), showWhen: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'] ), a!richTextIcon( icon: "times-circle", caption: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], showWhe

Hi, i would like to know what are the possible reasons why a record is not shown in a record type. Record Type is connected to a data store. This specific row does exist in the database, but is not shown in a record type. Thank you.

Hello, thank you for everything.There is something I would like to discuss with you today. Within the interface's expression mode, I am attempting to retrieve data from a record type, aggregate that data, and display it in a graph.The aggregation process is done in units of month and year, such as the total amount for each month in 2024.I prepared a temporary record type for practice. If all the target data contained in the record type is of date type, the implementation was successful. However, among the designed record types, there are fields that are text type and have date data. This is text type data such as "2024/11/04".I would like to convert the value of this item to date type data between acquisition and aggregation processing. If it is a text type, conversion can be achieved using todatetime(). However, this function does not work well for data obtained from record types. The error is that it is a record type type or a record field type, and that these types can

I am having trouble with the error "Export Data Store Entity to Excel Smart Service". I am using "Copy Document Service" and "Export Data Store Entity to Excel Smart Service" in the process model. The contents I want to process are as follows. ① Copy an Excel document. ② Paste the content exported from the Data Store Entity into the copied document. To achieve these goals, we first stored the document output by "Copy Document Service" as "pv!copyExcelTemplate".Thanks to this, ① was achieved. Next, I set "pv!copyExcelTemplate" to "Document to Update". This results in an error that says, "Please select a new document name, or if you want to access an existing document, select the document you want to update."(it's Japanese) The document should be configured correctly, so why am I getting this error? Note that if I leave "Document to Update" blank, I can export the contents o

We have a series of Records configured in one large relationship structure (50 + record types).  A third party process retrieves data from a SOAP webservice, extracts pertinent data and using a series of stored procedures inserts that into the database. Is there a way to capture those new entries and sync them into my records without having to examine 50 tables and perform 50 Sync Record operations?

Hi, I have a very strange issue with a RecordType and a Process. So I would have 2 questions : 1/ My recordType is based on a simple table Category(#categoryId, name, isActive, fkIconId, orderNo) and the corresponding ProstgreSQL table contains a Primary Key with SERIAL on the "categoryId" field. I've created a new RecordAction to call a process, and the RecordAction passes the rv!record to the process.{ myRecord: rv!record} I've created an Interface with a RecordType based Grid, to try my recordAction :but when I click on the button on a grid row, the process is launched with the bad parameters : Example1 : Click on row(categoryId=4, name="CAR", isActive=true, orderNo=2) => but in the process instance I see this log : changed to {categoryId=2, name=BICYCLE} Example2 : Click on row(categoryId=2, name="BICYCLE", isActive=true, orderNo=4)=> but in the process instance I see this log : changed to {categoryId=4, name=CAR} It is exaclty like

is there a way to retrieve more than 4000 characters from database using either records type or data store entity 

Hi team, I have a requirement where I need to add multiple assignees to a request. To do that I have created a child record for Assignees and with "id", "Assignee" and "isActive" fields. To do this I have created a rule input and added this child record as an array. I have added a user picker field "Assignee" where I was not able to save multiple values to Rule input. Can anyone please help me. Thanks!!

Hi everybody,I want to put some multiple default values into a Record Filter, but I don't know how.I see that with only one default option works correctly, but in the case in the screen didn't work.

Hi Team, I understood how index function works, but can someone please write a code(with example) using index function with cdt.

Hi there, I am getting this error while writing data to data store entity. An error occurred while trying to write to the data store [IPA Main DS]. No values have been written. Details: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): IPAIRRIntegrationLogDT11401 (APNX-1-4208-004) Thanks