Records

Hi all,We are using record type PVs in our process model and passing the same to user input task. In the task, we are updating the values and after submit is clicked, we are updating the variables to database using write to records smart service. But when we are doing the same, the values are getting updated in pv level, but not getting updated in database. All configurations are correct inside the process model. Not sure what is the gap in this? Please provide your insights.

Hi All, We are using "write to data store entity" smart service for storing the data into the database and getting the below error and there are no unique constraints declared in the XSD and Table. Below are the two requests which occurred while executing the smart service Error 1: An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=VT_TASK_MASTER (id=3112)] (data store: VT Tables). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIANBUSINESS_PROD.SYS_C0059560507) violatedData: TypedValue[it=3113,v={{<null>,43,Initiation,initiation,1,Employee,User(s),7,1,ltideploymentAccount,2024-08-05 14:47:12.64,,<null>,1,[Group:1261],0}}] Error 2: An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=

On 24.2 - I have a Product Record Type with a 1:n relationship to a Assignment Record Type. I need a custom record field on Product to show the "current assignee", which is one of the many Assignments, based on the product's current status and assignmentType. Since custom record fields do not support 1:n relationships, I thought to create a composite key following this recipe https://docs.appian.com/suite/help/24.2/custom-record-fields.html#create-a-composite-key.  The problem is I cannot find where to mark the new custom record field as unique. What am I missing? 

How can we display more than 5000 records in interface and search by custom picker? Anyone having Idea? 

I want to add  a field in db which should store data in array format . I will get this data via integration and i want it to be in an array. can someone help Integration output : { email :Test,addid:1193u, remove id:123, status:success, statausmessage:{     {          message :test1 success,           date:       }         {             message : test2 failed,             date:          }       }}

Hi All, I am getting the below error at write to multiple data story entities node ( Note ISRJMeetingAdhocReviewer --This is not a new table ) An error occurred while trying to write to the data store [ISR Data Store].  No values have been written. Details: org.hibernate.PropertyValueException: not-null property references a null or transient value : ISRJMeetingAdhocReviewerDT8605.studyRequestId (APNX-1-4208-004) Thanks in advance

Hi, Our requirement is to store the choice value selections from Multiple dropdown with choices from a record type into a separate join table rather than semi colon separated. We are using 23.3 version and the application is built on top of record types instead of CDT's and configured the records using many to many relationship between main & join tables.  Problem here is the choice value selection neither deleting nor updating in the join table, it's always keep inserting as a new values in the join table every time when we reselect the choice selection.  Is there a way to handle this issue to delete  or update the unselected choice selection?.

Hi Folks, I want to provide OOTB export functionality of record in my interface; but seems like there is limitation in grid, we can only use it if data is sourced from record.  I am getting my record data by using a!queryRecordType instead of a!recordData as a!recorddata doesn't have parameters for grouping.  Is there any easy way to achieve the same instead of again creating a view and using as DSE and doing export functionality separately as we were doing earlier. Regards, Ghanashyam

Hi Champ, I have a map variable and the same is used in the table. So I can see it was coded as todatasubset to the map variable with a local defined pagination variable. It's working fine if the map is having less no of rows then pagination ;but getting errorrdout when it's having more rows..message says like "batc size was 0 but te largest column data array had 12 items." So FYI: We are not using datasubset rather using todatasubset. Regards, Ghanashyam

Hi Folks, I am trying to import around 15mb of data (via a .sql file) in maria db through the import functionality; but it's not allowing and showing error message as shown below. Anyone knows what the alternative for this is as we are gonna import gb of data from the legacy system to appian as part of data migration.  What is the max size that Appian maria db allows? Regards, Ghanashyam

Hi, I'm looking for a way to start a process by a given url, the process is now in a record action, in any case I can start it as process model, without any record action's relation because of I can send parameters to the process model. Any idea how to build this url? Thanks in advance

Hello Team, In data model of a record not able to add or create a table.

In a hypothetical scenario, I have two Record Types. 'Program' is a parent Record Type of 'Course', linked by 'Program ID'. (i.e., one-to-many relationship between Program and Course) In the Program Record Type, I need to have two Views; one for Program, and another for Course(s). To make it clear, the need here is to have the View "tabs" sitting next to each other on the UI for an easy navigation between the two views. Extending on these Views, I'd like to also add the 'Create', 'Update' and 'Delete' Record Actions for both Record Types. So far so good. Where I've been stuck in my implementation is figuring out a way to pass in the 'Program ID' to the Record Actions for the Course. I have no problem invoking the Record Action using the a!recordActionItem() function, but I'll need to somehow pass in the 'Program ID' to tie newly created Courses to a Program. Am I stuck here because this

Process: In Process Model, there is a ui task in which a main record is getting stored, now after this node there is an xorThe problem which I'm getting is in write to Records node after the xor, I have to write related record data of main record, I have configured in the input node and I'm getting the error 'The input “Records” must refer to record types with data sync enabled that use a database as the source. Received (*The record Type Name which is related to the the record given in Input)'the process will repeat based on xor, for 3 times it worked fine, got error in 4th timeThe source is db and is sync enabled.

hi,  I have a some data stored in a local variable which is of type ( Text List ) , this has the fields similar to a record type and I wanted to update the database. if I pass the local variable to process model , I get an error due to different types. how to cast the local variable to record type. Any help is appreciated. 

I have two variables of list type,  local!selecteddata: { id:1, name:test1, id:4,name:test4}.   local!data:{id:1,name:test1,                  id:2,name:test2,                  id2,name:test3,                  id4,name:test4 } if I update the "name" fields of local!selecteddata,How do I index local!data and update the field "name" for ids : 1 and 4 . Any help is appreciated 

Hello,  I'm trying to use a dynamic field to allow users to add more text inputs for email addresses. Currently, the email address fields all show whatever the most recent text added is--only showing the same email address in all of the boxes.  What am I doing wrong? Thank you for any help.    { a!columnsLayout( columns: a!columnLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: "Notification Recipients", style: "STRONG" ) } ), a!forEach( items: local!emailNotify, expression: { a!sideBySideLayout( items:

Hi, I have a variable of type document and another of data entity type where I need to store the documents, in all the process models I have this: but in just one case the documentId is not filled hence I am getting an error when trying to use the cmcDocument variable. In database it is inserted as expected: the instance:  I don't know what can be the problem as in other process models it is working and there is no difference between those processes

Hi All I want to create custom search box for my main record type, whenever any user enter any value in the search box the data should be filter by the this value, this value should be compare with all the record types which have the relationship with my main record type  

Hi, Could you please help me with the below requirement Sample Table and Data RequestTable id name       email                 createdOn            createdBy1    N1   n1@mail.com 2020-07-27 13:15:30 n1@mail.com2    N2   n2@mail.com 2020-07-27 13:15:30 n2@mail.com3    N3   n3@mail.com 2020-07-27 13:15:30 n3@mail.com4    N4   n4@mail.com 2020-07-27 13:15:30 n4@mail.com2    N5   n5@mail.com 2020-07-27 13:15:30 n5@mail.com Conversation: id  reqId    message       sentBy 1    1            Xyz         n1@mail.com2    1            abc         reviewer1@mail.com3    1            pqr  &nbsp

Does anyone know why apprian would show that a table has multiple primary keys, when the table only has 1 primary key, 3 foreign keys and an alternate key?

Hello all, Just checking to see if anyone knows how to sort a grid's field when the data property is not a typical query. Please see code below for what I mean. The grid displays as expected with values and all, but when trying to sort the fields I get the error in the Subject above. Are there any other ways to sort other than [recordType.field] or [recordType.relationship.field]? I did see an earlier post solution on here with similar error, but that scenario was quite direct working with recordData for the data property of the grid. Any input regarding this particular scenario would be much appreciated. Thanks a!gridField( label: "Grid for ", labelPosition: "COLLAPSED", emptyGridMessage: "No reports for this day", data: index(local!reportsPerDayOfLastSevenDays, local!selectedDay), columns: { a!gridColumn( label: cons!LABEL_NAME, sortField: 'recordType!{8360b17d-94c9-478d-af7a-8e685ada463b}LNU Rep Sched.fields.{f

You need to create a record type with data sync enabled. What are the supported data sources. Options:- A- Web services, Salesforce, Database B- Web Services, Process Models, Database C- Salesforce, Process Models, Database

I've a record with a title that contains reference number and status of the record. On the summary view, I've a checkbox with a button something similar to "I agree to terms and conditions....". I configured the button to trigger a process using start process smart service where the details about the acceptance of the above terms along with the status updated. Inspite of activity chaining in the process, the status of the record doesn't get refreshed, until I refresh the page manually. Is there way we can update and refresh the record status in the record title? Note: This record status updates automatically if I use any related actions on the record. However, the above is not a related action, but just a button to trigger a process.

Hi, I wanted to ask something related to this sync data in record types. As we know, after the record type exceeds 4 million rows, the record data will become unavailable. But we need more than 4 million rows of data from the database, and now I want to use source filters to divide up that large data source into multiple record types, based on timestamp. And the question is how would you do this and what could be the best way so we can have only 4 million latest data synced, but others to be stored in another record type? Thank you