Records

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?

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

Hi Readers, I have two tables Table-A with columns:- ID_A, Job_Role, Company_NameTable-B with columns:- Member_ID, Name, PhoneNumber, ID_A which are related as one to many relations I have created record type for different these tables and added relation ships in the record type as well, Would like to know can we consolidate them as below requirement rows which i want to display are  Member_ID Job_Role Company_Name Name Phone_Number 1 DBA ABC.ltd SSR 1234567890 2 DBA ABC.ltd RC 0987654321 3 SysAdmin ABC.ltd NTR 6789054321 4 SysAdmin ABC.ltd RRR 1234567098 5 HR ABC.ltd MB 0984562348 Below are the tables structure Table-A is as below ID_A(PK) Job_Role Company_Name 1 DBA ABC.ltd 2 SysAdmin ABC.ltd 3 HR ABC.ltd Table - B is as below Member_ID Name Phone_Number ID_A(FK) 1 SSR 1234567890 1 2 RC 0987654321 1 3 NTR 6789054321 2 4 RRR 1234567098 2 5 MB 0984562348 3

can we calculate batchsize based on datalength(Bytes) from table and amount of data we retrive from Appian query  ? because i have a requirement to send data from multiple tables to API Ex: For one table i have table with 235417 of data in that and datalength is (18366464 Bytes) . As we know we can retrieve only 1MB(1000000Bytes) of data at a time from query entity , So i am expecting my batch size should be dynamically decided based on datalength(18366464) and amount of data retrived at a time (1000000bytes) to send whole data in chunks . If i give hardcore value as 10k or 5k this may again cause issue for some other table with large data or large column . So my thought is it's better to decide batchsize dynamically based on tablelength  

Hi, I have a read only grid with recordType as data source. The total records are N, more than 5000. I have the need to show a column in the grid with a progressive index, from 1 to N. Is there a way to achieve this using the recordType and without loosing some functionalities like user filters, excel export, etc.? Thanks!

I am uploading a csv file with a cdate type column, I changed the format in the csv to be "yyyy-mm-dd" which coincides with the format shown in cloud database. However when I upload it the column with date is not uploading correctly. The rest of the columns are OK except for that one. Any help would be useful. Thanks!

Hi! I´m trying to import a CSV to Appian via Cloud Database When I finish to enter my data and try to import, the following error appears: It seems like the table has been created but I have no access for some reason/permissions (I´m the admin of my site so I don´t know what to do). I wanted to ask: 1) ¿How can I correct fix this error? 2) ¿Is this the correct way to create a database in appian from a CSV? Thanks a lot

I have a record with all text columns, even the integer/decimal data is being saved in text type fields. In appian I want to sort ascending/descending properly but it is taking the ASCII value of string & sorting them on that basis. Is there any work around in "gridField" with data as recordType?

Hello,  We are testing the waters for a DB migration.  ( MySQL to Amazon RDS ).  Within one of our environments, we plan to make a copy of our existing apps, and point the copies to the new DB for testing purposes.   We realized this would entail updated all object references for the copied objects, which is labor intensive.  Is there a tool tailored for this scenario, or a better approach we could try? Thanks.

Hello, I'm retrieving from DB base64 documents by record types from CDT queries and using it in the app, and I am having a problem when retrieving them. The application should be able to work with documents up to 2 MB, but the limit for queries is 1MB. Is there any way to increase this limit?

Hi! I have created two different Records (R1, R2). In my site, I have a summary view of R1, which shows some info + a Read-Only Grid of R2 (filtered by R1 primary key) Besides I have a related action (of R1) to delete the records of R1 My problem here is that, when I try to delete R1 I have faced different "errors" among the time: A) nothing happens B) an error appears (not able to delete) C) It deletes the summary view and the R1 field, but NOT the R2 fields Something similar occurs when I try to update records So, which recommendations would you give me in order to be able to delete/update two different records at the same time? I would like to hear the best practices. I was thinking about re-making each process model (delete-update) and add a delete/update records of R2 in each case. Would this be a good approach? Thanks a lot!

I am trying to get a temporary table data by executing a stored procedure. This stored procedure is responsible to create a temporary table, insert some hard cored values (id and name as fields) and then dropping the temporary table. Before dropping Inam using select all statement so to get my data before dropping the table. But somehow I got the data which is similar to this, { { id = 1, name = Abc }, { id = 1, name = Pqr }, { id = 1, name = Uvw }, { id = 1, name = Xyz }, { id = 1, name = Ijk } } It looks like 2D list of map. can anyone help me in binding the data to excel using Export DataStoreEntity to Excel and Execute Stored Procedure smart services.

hello all, I am trying t write to a table using write records smart service. The data is being written in DB table but I do not have the records updated captured in my output variables of node. I am doing a single entry at a time and record has no relationship defined. One thing to note here that we have configured triggers on this table which updates some columns for the same table. We are using Postgres DB. has anyone else experienced the same situation. Node Configurations:

I have a read only grid sourced from expression which is getting data from an integration. I want to export this grid data to excel. So can someone please help how to do this. Stuck here as Export CDT to excel is deprecated. 

Hi good day, I'm trying to create a download csv/excel file from a list of dictionary from my data.1st Step - Fetch Data from DSE2nd Step - Transform Fetched Data to Specific Dictionary (with Formula).3rd Step - Convert Transformed Data (Dictionary) to CSV/Excel Document.4th Step - Put Document in Document Download Link.Note: This is going to be perform in Interface.

Hi! I would like to change the primary key in my record and use another field instead (the created field would be a concat() from other two fields). Even though I have been trying, I´m finding trouble when trying to change the condition of primary key and give it to another field. I don´t want this primary key to be AUTO-INCREMENT and, when I try to put another field as primary key, an error occurs. Is it possible to eliminate the primary key and convert the other one into a primary key? Otherwise, how can I solve this?

Hi Team,I have a requirement for creating an audit table in that i need compare the existing data and updated data and need to add only changed field values. for this 1st I'm querying the existing data in a local var, then after changing some fields in the UI, I'm performing a save into operation which involves a!foreach which compares the queried data & UI rule input fields so when there is a difference I'm appending one row for that changed field in audit record type rule input(array). but if there is no change I no need empty- row in audit table. but some how my code appending empty rows for fields with no changes. Kindly provide suggestion it'll be helpful.Thanks in advance here I didn't change anything in one field but it gets adding null value

Hi! I´m trying to make a query in order to update certain rows of a column in one Record (CPF_Lineas_Pedido) with the exact values of the columns of Record 2 (CPF_Lineas_Recepcion), where the variables "IdPedido" and "Material" are the ones used in the process Query: " UPDATE CPF_LINEAS_PEDIDO, CPF_LINEAS_RECEPCIONES_V3 SET CPF_LINEAS_PEDIDO.CANT_RECEP_ACUM =  CPF_LINEAS_RECEPCIONES_V3.CANTIDAD_RECEP WHERE CPF_LINEAS_PEDIDO.ID_PEDIDO = ac!pedido AND  CPF_LINEAS_PEDIDO.MATERIAL IN (SELECT material FROM CPF_LINEAS_RECEPCIONES_V3 WHERE ID_PEDIDO = ac!pedido) " The query changes the values of the desired rows of CPF_Lineas_Pedido,  but instead of picking the same value of the other table, it takes random values 1) I introduce the value of "Cantidad Recepcionada" for each Line, and the record is written 2) Database CPF_Lineas_Recepcion written (ok) 3) Database CPF_Lineas_Pedido written (not ok) How would you link this fie

hi! I´m trying to update a field of a record with new data (stored in local variable in my interface and passed correctly as a rule input) Even though the values are correctly saved, when I use the write records smart service it duplicates the rows and stores the value, with the rest of fields in null I just want to update that field of my record, not to create new entries. Should I use the a!update function? How and where can I configure it in my code? My interface code is the following: a!localVariables( local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido', fields: { 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{fcfa4b36-4398-4430-8055-ecfa59daf13a}idLineaPedido','recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido', 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{69e