Records

I have an interface that stores the data in a record type, which has several fields. Once the interface is submitted, I want it to be saved in the database using a write record. And I get the following error: Unable to write to or delete from the source due to a data integrity violation.Error Details: Field 'Detalles_Trasladado' doesn't have a default value. That Field is not in that interface, but it is in other interface of the process.  How should I write the new record in the record type? Thanks in advance

I have a simple PM to write single record using a Write to record smart service. It has been working fine in our lower env's Dev and SIT. First ran into the below error after promoting this Pm to UAT.  Error: Unable to write to or delete from the source due to system error.Error Details: Invalid argument(s) in call I am pretty sure the cause for this is not configure the sequence in the Record Type(couldn't test/push changes to UAT yet) . Do you guys agree this will solve the problem? if not please share your thoughts.  if this is indeed the root cause of the issue, it raises a different question. How did this NOT cause a issue in our dev or SIT env's ?? Pm is working fine writing new records into DB with out sequence being configured in the record type in both the env's. Kindly shed some wisdom on this.  Note: 1.Exact same table and sequence structure used across ENV's. 2. Only non nullable column in the table is primary key. Thank

Hi everyone,  I'm not sure if you guys have the same problem as mine, but haven't found any similar topic in the forum... I am having an interface, which is using a recordtype as data source. The record type already had 5 user filters to be used in the interface.  Appian's recordtype based interface is currently providing a prebuilt feature that allows users to Manage Filters (Save/ Set as Default/ Reset filters), and we are using this feature to save some filter choices. However, recently I added a new user filter, and realise all my saved filters were removed from the filter tab. It brings quite an issue to some users, as they have saved lots of filters to customize their reports.  Have you seen this issue before? And is there any way that I can retrieve the filters back/ or prevent this issue when deploying the new user filter to PROD? 

I am trying to make a field unique by following these instructions - (source : 24.3 24.3 Case Mgmt Studio (CMS) Common Customization and Configuration Guidance) How can I navigate to the db table corresponding to CMGT_Agency? These are the options I see in source settings.  

In Case Management Studio, the due date utilities, objects and interfaces are dependent on the SLA field that is configured when creating a case type.  For my use case, I would like a user entered due date(from data intake form) to be set as due date( and connect to the calendar interface, show overdue message etc). What is the best way to achieve this? Similarly, I would like a user entered "Assignee" to be saved and used instead of the default field. 

I have few record which I build them in Appian and save into DB. Below are records which I build in Appian which has "doddapap" my id for created by and updated by fields. But on writing these records DB these fields are getting updated with "Administrator.   Can Someone help me fixing this. 

hi, I'm trying to create the custome field as screenshot below. my goal is for the same task, preparer cannot be the reviewer. so I need the ID so I can filter the record out based on loggedInUser() the criteria: same date, same task, different Stage also it would be easier to change the status from Preparer to Reviewer. Thanks,

My record type title displays some dynamic data that needs to be refreshed before the related action is completed, does anyone know any way to achieve this?

I have a record type which contains about 45000 records. I need to build a dropdown that shows all 45000 records but maximum limit in batchsize in queryRecordType() function is 5000. How can I display 45000 records in a dropdown list?

HI, i'm devloping an application to store and track all the devices in the comapny, and users needs to update device details like current assignee, status, location and device condition, My question is what if one of the users wants to update the asignee and location or device condition at one time how can i capture the event ID in this case? i need to store in the logs that assignee has been updated and location has been changed, what is the best solution here? 

Why does the below peice of code does not work with records as rule input.  if( fn!isnull(ri!array), true(), length(ri!array) = 0) If I pass empty record in ri!array it should return me true, but it is returning false.

Looking to create a DSE to existing Appian cloud database or any recordset in the Appian Community Version. Not able to find any instruction or guidance where I can accomplish this. Can I get some information or help on this?

We have a synced entity based records with 13,000 and 50,000 rows respectively. However when trying to export the excel from the record list without applying filters will not do anything (not downloading even a blank excel), However in some cases applying filters download the excel but sometimes not. I looked into tomcat-stdOut.log I see this error message. 2024-03-28 17:52:52 WARNING [http-nio-8080-exec-558] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI example.appiancloud.com/.../download-grid, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected. Not sure how to resolve this or what needs to be corrected. Any ideas or suggestions?

Hi all, I was wondering if it's possible to provide context to and between user filters in a record? So if the user enters a value somewhere on the interface, can this value then be used to update a record filter? Like to update the list of options that are available? And is it possible to change the list of options in a filter based on what's been entered in another? Looking at the documentation I don't think you can, but I just wanted to double check. Thanks!

Hi, I have a long process (long running task) which calls a User Input Task to display a Main form with a text field. In that Interface I have a Related Action which calls a process to display a modal form, and when it is submitted, this later saves a new Text value in DB. When the modal form is closed, and I get back to the main form, my text field is not refreshed with the new data. So I've tried this little test in the Main form  : - On the saveInto of my textField I've added a writeRecords smartService to save data in the DB, and I've added a "GET" Button to get Data from DB (dynamicLink). If I enter a new value in my TextField, I can see that WriteRecords works fine, and the new value is well saved in DB (viewing it in phpMyAdmin), Then, if I click on the GET button, the underlying Expression Rule (EXPR1) gets some old data (why ? if the DB shows me correct data) If I execute the same EXPR1 outside of m

Hi All, I am preparing a weekly report for User login frequency. The data is fetched from a cloud DB table which is getting enriched (picking data) from login_audit.csv. The intention of the report is to fetch all active users, and the entitlement mapped to these users. Following query is used to fetch the data and we have a requirement to add the last login details to this query. SELECT USER_NAME, FIL_UNIQUE_ID, GROUP_NAME, IS_ACTIVE, LAST_LOGIN FROM UAGR_USER_GROUP_MAPPING 

I cannot able to use user filter in a!eventhistoryList(), even though i have added only one a!eventdata() why is that, how can i solve this ??

Hi everyone. I added a new Decimal field to one of my DB tables, but when I try to map this source field to the corresponding record field in Appian the Number (Decimal) type is not available in the dropdown (please see the screenshot below). Does anyone know what could be the reason for that? Even Appian recognizes the source field as Decimal, but still doesn't give me a proper option in the choice list. I would appreciate any advice on this matter. Thank you.

I´m doing the Appian Developer Course, and in the Build an Application Step by Step part 5 I have this error, related to the Record Type: Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 52]: User Does Not Have Rights to Perform this Operation. Can someone help me with this error?

Hi, I have a very simple need : I have a main Interface (Intf_A) displayed from an User Input task user of a process (Pr_A). In that interface I have a Button (related Action) used to display another Interface (Intf_B) which is a start Form of another Process (Pr_B). In Intf_A I have a Text field, and when I click on the Button, I need the text value to be passed to the IntF B. How may I do this without saving first the Text value in DB ?

Question : we have a employee table , we applied the partitions and indexes on the table to certain field. But the employee table is sync able record type , will the partition and indexes really gonna make any impact when i execute Query record on it  ?

With CDT, we can use @Version annotation for optimistic locking. Optimistic locking is a concurrency control mechanism in which it ensures that concurrent transactions will not conflict with each other. If there is a chance of conflict during transactions, the transaction having an older version number will be aborted. Can we achieve a similar thing using Records?

Is it recommended to store all record types in a folder  e.g. RecordType folder?

I need help creating a process model to evaluate and batch update the status of a large group of users (30,000+ records) based on detailed criteria. The workflow logic is as follows, with any identifying info removed: User Status Evaluation Process Initial Conditions If either of the following conditions is true: There is an entry in a related table where the status is not equal to "denied", OR A specific approval flag is set to true. Then: No further action is needed for this record — it can be skipped. Handling Rejected Entries If an entry exists in the related table but its status is equal to "denied": Check if there is another flag indicating confirmation of a related process or action. No Entry and No Approval If no entry exists in the related table and the specific approval flag is false: First, check if a secondary task or decision exists with a status of "approved." If no approved secondary task or decision exists, check for th

Hi, Thanks for your help in advance & much appreciated if someone has faced this design scenario already . Bit of background , We have a significant number of historical cases in a DB as we are decommissioning an outdated system . In a nut shell, These cases are not going to change or case count is not going to increase. case count is significant (10,000 or a million) & number of end users not too much ( around 100 ). We have a REST Api which exposes the DB (containing historical cases) mentioned earlier. I am creating a site to display this historical case data . I am planning to use record sync to load the data in to a record. As data is not going to change or increase, all I need is data load to the record, not really data sync , Can I still use Appian's record "data sync" facility? Do the "data sync" needs to be run daily ? or I can just load the data once and query the record to filter for example if the data remains static ? This is the interface