Data Fabric

Hi, Is there a possibility to connect Appian Cloud Database from outside. Thanks, Sadhu Surendra

I have Room (roomID column) and a Key (with keyID, roomID, and keyDescription columns) . A room can have multiple keys. I setup a one to many relationship between the Room and a Key using the roomID.  I used the Room record to populate a gridField. The search is not returning anything if I put an information that should match the keyDescription. I have the code below. I am only after for keys that are active which is one active key per room. Even if I remove the filter in the code, it does not return anything. Is this expected for a One to Many relationship?    { a!gridField( data: a!recordData( recordType: <room_record>, relatedRecordData: a!relatedRecordData(relationship: '<roomRecord-keyRecord>', filters: { a!queryFilter( field: '<keyRecord.isActive>', operator: "=", value: true ) } ), columns: { a!gridColumn( label: "Room ID", sortField: 'roomRecord.roomID', value: fv!row['roomRecord.roomID'], ), a!grid

I am using export DSE to Excel smart service, but the output data is not the full data the Table is having. I am having around 21k data in table where as the excel that was generated through the smart service is having only 20k rows.Are there any limitations for smart service?

Hi, We have a record type based on a service. Data syncs every morning 3AM. Today morning data synced well. We are using this data on a UI. The issue is, CaseInvalid on UI. When we look at the cause of it, we found the service is down. Is it mandatory to have the backed service up to use the already synced data from Record type to be used on UI? Thanks, Keerthi

HII'm trying to count the number of records in the data entity HVSDC_PlanesMejoramiento_Entity that meet a specific filter on the field CodigoSIRECISujetodeControl. This is the SQL query, which works fine: SELECT CodigoSIRECISujetodeControl, COUNT(NombreAccion) AS total_accionesFROM HVSC_V_PlanesMejoramientoWHERE CodigoSIRECISujetodeControl = '11745' GROUP BY CodigoSIRECISujetodeControl; This is the query in Appian: local!count: a!queryEntity( entity: cons!HVSDC_PlanesMejoramiento_Entity, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "CodigoSIRECISujetodeControl", operator: "=", value: tostring(ri!codigoSireci) ) } ), aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "NombreAccion", aggregationFunction: "COUNT" ) }, groupingColumns: { a!queryGroupingColumn(field: "CodigoSIRECISujetodeControl") } ), pagi

I have an endpoint which returns data consists of 5 columns (text and date fields). I want to keep an text field and then when I enter values in the text field, I want to filter the data based on the value I entered. It should filter dates if possible

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

HI,  I need to download a Ui page in site as a pdf doc, how can i achieve this. Eg:  I have a report in a page like showed above, By a click i need to download this page as a pdf.

Can any one explain how to generate PDF from reports with grid data.

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. 

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