Data Fabric

One of the requirements requested from our team is to add print button to print the whole request information available in the interface by the end user. Could you please give us the best approach to do this task and what is your suggestions to achieve such these requests putting in your consideration that the interface is a combination of multiple interfaces each interface has its own rule inputs while some interfaces retrieve the data from web service and the others from record type in deferent representations and formats like grids, labels and so on

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

 Business Objective: When Speakers apply to speak at one of our parishes, they supply documents to support their application to be a speaker.  Many of Speaker will apply to speak year after year.  There are three types of documents General Documents that are required and are valid for many years.  (For example their background check is valid for 5 years). Event Documents that are required for each event they are applying for. (For example the contract for the events). Optional Documents to support their application and are not required.  These could be general documents or documents for a specific event. Required documents are customized for each of the Speakers.  For example, depending upon their country, there are different agencies that do background checks with their own forms and documents. There are two areas (interfaces) where the documents are uploaded; the Speaker Interface (this is NOT a portal, as we give the speakers Appian login credentials)

I have 3 records having one to many relationship  Timesheet(ID,IS_ACTIVE), Audit(ID,TIMESHEET_ID,IS_ACTIVE) and Comments(ID,AUDIT_ID,TIMESHEET_ID). When I tried to use single write records smart service, I am not able to populate value for TIMESHEET_ID column value in "Comments" table. Is it expected or do we have any other way to handle this?

While looking into the Dependents and precedents we found out that the issue was due to USER record type which is available by default in all environments. Has anyone faced similar scenario and how to work around it to successfully deploy the application from DEV to TEST ? FYI: 1. we have updated the instance version to latest release and also updated the User Record Type to latest version. 2. The missing precedent is the User record type fin the SS.

The total number of sync rows with the web source is 136,614 but in the Record List there are only 82,874. After each sync with the web source the number of rows in list are different (80,000 - 90,000).What could be the reason?