Records

Hi All, I have a requirement in which i am opening summary page in new tab, and from previous tab i have deleted that record through record action. Now, when I am going on summary page tab of same record, and reloading the UI, It is showing error like  "An Error has occurred. Record does not exist, either deleted or don't have permission " Please help me if there is any way i can replace this message with custom appian UI showing This URL does not exist and 404 - not found  Thanks in Advance, Shree Krishna Tiwari 

Hi Experts, I am using a grid layout and I have rule input of array type, I want to select data present at specific index in rule input, Please help  me how can I get index of array type rule input? Thanks in advance.

Hi there, I need to export data to an excel file shown below. I know it's easy to use "Export Data Store Entity to Excel" smart service to export the material list at the bottom, but could anyone know how to combine the upper and bottom parts together to export to an excel file? regards, L

Yeloow, I am currently working in a use case, I have an array of Entity data where entites from different datastores will be inside this array, I want to segregate or group the entities by their datastore so I noticed one thing while trying this out, [Data Store Entity:"xxxxxxxxx-xxxxxxxxf-9143-xxxxx8c102b00@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxx-xxxxx-43a9-a20d-3xxxx744b9aae@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxx-4adc-b46f-axxxxa5990bd@6308"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxxxx-4c81-9ddc-axxxx0d18e9@6308"](Data Store Entity) after the @ every entities belong to same Datastore have the same 4 digit number so I assume entites belong to same Data store have these 4 digit number common, is my assumption right ? can any Appian legend confirm this [emoticon:4191f5ee34e248a29fa0dbe8d975f74a].  

How to query table count from oracle DB and display the result in appian screen? I have used the below "Query Database" smart service to fetch the number of table count from DB. But I receive the below error: "You should enter only a single query in a row." My query - SELECT COUNT(1) AS NO_OF_TABLE_CNT FROM USER_TABLES;   Please help me to get the table count. Is there any other option available apart from using this Query Database smart service?

Hi there, I am trying to convert a CDT to excel,  but notice the smart service "Export CDT To Excel" is "Deprecated". I dont want to save the data into database, then use "Export Data Store Entity to Excel". could you please let me know what I can do here? Regards, Lin

Hello Everyone, We have a use case where in we need to nightly refresh our look up tables( truncate existing data and update if integgration is success)on daily basis. As our application is record centric I am planning to use service backed record to external system.However I have below questions to clarify before I proceed. Do we need to hit the API twice? once to check if it’s success and second to populate the record? To truncate the existing data I am thinking to use delete records. Also, Unsure how serviceback record handles if integration fails. Please let me if this approach is suggestable for the above use case. Thanks in advance.

How can we find difference between 2 cdts and capture the changes in Audit table . what could be the best way to do it . TIA

Hi folks! Good day!! I am facing one issue while configuring the record directly in read-only grid and configure the recordActions But while clicking the Add new role button and clicking the Create or cancel button, I am facing the below issue. Note: This will work properly in the Record under the Tempo site. Could you please help me with this?

Hi I have below code: when i am clicking on add row link value is getting save in CDT structure but not displaying added row in design preview what is wrong in that?

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.