Data Fabric

How to show Record Sync History on the interface as read only?

Would it be possible to remove any option from the dropdown on the filter? Also, we have created a ‘Custodian’ dropdown and are passing that value into the record filter to filter the records dynamically. However, there seems to be an issue when we export, such as not showing that value in the filter because that value is not part of the filters. Would it be possible to set that value programmatically?

Hi All, I have a scenario where I want to use the filter logic configured in a record type by calling the filter on the interface.The filter is functional in the record type object, and I do not want to query record type and add filters indectly by creating a dropdown and linking the filter to that.But, I want a logic through which I can directly call the record type filter on the user interface.Is it possible?

Hi All, I am facing issue with record sync while writing dataset to the database table using write records.This works fine if we sync record manually , data is inserted , we get the primary key back to the process. The record is a simple record with no relationship defined. Going through the community posts , this issue comes when we have BIGINT type of datatypes defined in the table. So need to verify how to solve this issue without changing primary key column from int8/BIGINT to INT, as we need to store the values greater than int4 range in the database. Is there any way to make this sync work?Kindly guide.Attaching the screenshot. Thanks

Hi there, I have a map type process variable (maybe name it as "vv") in a process model, with data like this: {returned=[mat=111, pt=5555, sc=44, bn=EEE],[mat=222, pt=3333, sc=44, bn=III],PopUpText=No records found, LoginStatus=true, connection=xxx} A CDT "returned" is defined with the 4 fields (mat, pt, sc, bn). And I define a CDT process variable "r1" which can store multiple values. can I use the following to get the "returned" data in MAP variable "vv" to CDT variable "r1"?  save pv!vv.returned  into: pv!ri could anyone know? thanks! Lin

Can I ignore case sensitive in Query Record Type as I do automatically in Query Entity? The record type I'm using has data sync enabled and I need to put a validation on a text field to give evidence to the user that there is already a line with the string he is typing. I built the validation into an expression rule that invokes the Query Record Type and I noticed that the filter is case sensitive. Thanks

Hi, I have an Excel template and I want to add information in a column to the right of the document (custom values etc). The problem is that I put a statement that doesn't return anything because I don't want it to do it automatically (if it puts the values on the right it removes all the values on the left) and then I only add the values using the custom values. what do I want. Is there a way to not put the message (I have it below) "No data available due to empty data source, applied filter/selection criteria, or fields visibility."? Thanks

How could I query a database using a!queryFilter where the field it checks is an integer and would check if the search value is included in the whole integer?e.g. If I searched "123" and one of the record items had an Id that is 123456789, I would like that item to show up in the resulting list.

Hi everyone,  I'm having a CDT (CDT01) with fields: {id: int, name: text, information: {id: int,fieldId: int,address: text}} As you can see, the information field contains a different CDT (CDT02) that is nested inside CDT01.  I would like to sort a list of CDT01 based on CDT02.fieldId. Is there any solution for that? I tried toDataSubset and dataSubset but seems like I can only index the first layer of the CDT.  Thanks for helping :)

Hello,      Why and what is better to use data type or record type?   Thank you.

Hi i am getting 404 error when i am trying to use webapi/printRecordToPDF approach for printing record view from a safe link.  if anyone encountered same issue would appreciate steps to resolve the same. for safe link i am sending record url along with identifier and url stub and onclick i am trying to invoke windows print method for pdf. Thanks in Advance

When I try to add a Record Type Event it is impossible to add history and event type names : anaything I insert in those field get erased 

Hello, I was working through the documentation for the Demo and experienced the following:  For the demo the selection is for Reduce total process (not case) duration. When selected I receive an error message. Please Advise

Hi Everyone, Am having a Approval user input task which will be assigned to multiple persons and everyone needs to take action on it (Run one instance for each assignee). I have designed process report where every individual user can see the approval task in their queue. My query is if anyone user is rejecting the approval , all other active task assigned to multiple users need to be marked as completed in process report.Can anyone please help on this ? Thanks in Advance

Record Type Custom Field Column Creation: We have a one-to-many relationship between two tables and need to retrieve a particular record based on a condition. Please let us know if this is possible using a custom field.

An end-user needs to trigger a process model and act on the user task assigned to them. What is the minimum security permission needed?

I have created a task report. When I apply the 'Active' flter, what is the nature of the tasks which will be filtered out?

Hi everyone been struggling with this for a while, Is there a report or log that can return all process models in an application and the number of nodes associated with each? Thanks, Andrew

Hi all, I have in assumption that to write existing data into db using write record SS we only need the primary id and the field which need to be updated. But i am getting error  as there are couple of columns which were marked as required, so i have to add those columns as well along with primary key when using write records . Can anyone suggest if am missing anything or this is how it will work?

Is it possible to redact text from a textField component? I found some plugins for document redaction, but this wouldn't be a document, it's a field that users can fill out and oftentimes will include sensitive information like SSN, account #s, DOB, etc and need to be able to check to see if it includes any private information and redact if necessary. 

Hello! I'm curious whether or not the amount of data we pass in and out of an Expression Rule has any impact on performance. Consider the following scenario. I have a pv!recordType process variable, with three fields: recordType.field1, recordType.field2, recordType.field3. I want to use two of those fields in an Expression Rule to obtain an Output to use later in the Process Model. When configuring rule inputs for the Expression Rule, I am facing two options: 1. Pass the whole pv!recordType into the Expression and access the fields within the expression, resulting in one rule input "recordType". 2. Create two separate rule inputs, "field1" and "field2", and access the process variable fields when passing data into the Expression Rule. Now my question is basically this: is there a real difference between these two approaches, or is it a matter of convention?

We are getting an error on PROD saying "Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator". Checked the failed sync reason and it says "Unable to sync due to system failure".  And Event type for this error is "Write To source". This happened only on one particular day (17th September) and there is no error before or after that day.  We debugged and did not find any exact reason why it happened. The only reason we can see that there was some activity happened on DB side on that day and one of our scheduler Process in Appian runs everyday which updates the data in DB in batching of 65 rows so due to which this error might came. Can anyone please suggest on which logs we can refer to look out for root cause of this failure and find that this issue happened cause of some DB connection or any other reason. In tomcat-stdout.log also did not fou

Our Appian DB has setup for Enhanced Data Pipeline, follow the guide.We have a Python app that run through airflow to query data with a service account, and trying connect to Appian Dev Cloud Database. We're debugging right now on the connection and got this errorpymysql.err.OperationalError:(1045, "Access Denied for user 'appianViewer'@xx.xxx.xx.xxx' (using password: ***)") Is there anyway to connect to the dev DB through local machine to debug on the python library issue?

Process Report showing an error "The per-resource  time limit for generating this report has been exceeded" Please review the report performance details for guidance on tuning the report

Hi all, I'm trying to see what is the best way to check if a record already exists in the DB, specifically in a relationship table. I have 3 tables: manager, employess, managers_employess_relationship each manager can have multiple employees. Manager table : ID Name 1   Juan Employees Table ID Name 4   Liza 5  Emily managers_employess_relationship table ( has the foreign keys from both tables) ID   Manager_Id    Employee_Id 1         1                        4 2          1                        5 when a manager is adding its employees in a form what is the best way to check if its adding an already assigned employee, for example if manager juan tried to add Liza again, I want to make sure it gives him some type of validation saying that liza is already assigned to hi