Data Fabric

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

Hi, my client wants the search box and the filter style of a common Record Type. We implemented a gridfield with a!recordData as "data", but with time, it became very slow. I would like to implement the pagination, but with the a!recordData is not possible. Even, I tried to use the a!queryRecordType() and it works fine (it's very fast!) but in this way, we lose the possibility of having the checkbox and the user filters and the Excel export button, and so on... Does anyone know how to help me? I already tried to maximize the performance of the record type with default filters, but I don't know how to face this issue. Thank you to whom will help me!

Hello, For storing date and time for (dateTime type variable) in record I'm using now() function. But in record type its format is like : 9/10/2023 12:50 PM GMT+05:30 and in database it is of this format : 2023-09-10 08:06:33.100000. I want in record type and database should have same format like this : 9/10/2023 12:50 PM GMT+05:30.  As I'm using stored procedure to get data between two dates, but I'm passing the date format as 9/10/2023 12:50 PM GMT+05:30 and in database it is in this format 2023-09-10 08:06:33.100000, so not getting the data after executing stored procedure. Thank you.

the error appear when insert the data from the interface into the table

Trying to find new info and gather more information on Tempo, browsing through docs and community posts, I have a feeling that Tempo isn't used anymore. Is Tempo deprecated? What could be the reason for it? From what I've understood is Tempo was used in Tasks, reports, Records & record actions. We now have Summary, News Fields shown from the record actions. I a newbie, correct me if I'm wrong anywhere. Also, is Appian more inclined towards embedded interfaces and sites rather than Tempo? If so, should I be investing more time in learning Tempo. Last question, from exams perspective, ACD100 if Tempo is legacy(or about to be) can the questions be based on older versions of Appian, where Tempo was more extensively used?

local!quarterFindFactor:roundup((month(today())/3),0), local!startingQuarterdate:todatetime({eomonth(datetime(year(today()) - 3, 12, 31),- local!quarterFindFactor) + 1}), local!end: todatetime(now()), enumerate(elapsedmonths(local!startingQuarterdate, local!end)+1) if i pass the hardcoded value then it is working fine. If i use the above code it is throwing the below error. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'elapsedmonths' [line 13]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB failure trying to convert typed value TypedValue[it=109,v={2020-10-01 00:00:00.0}] to java class java.sql.Timestamp. Pls any suggestions

Hi! I have created a node with the SyncRecords Smart Service My record to update is called: "CPF_Lineas_Pedido" My primary key is a concat() from another two fields of the record: "CONCAT_PEDIDO_MATERIAL" (f.example, "Pedido1-Rueda"). This primary key is saved in the first interface of the process The process variable which I use to "Collect" the primary keys is correctly saved:  And as you can see, all the values are the same as the records primary key By now, all the field (in which I have created/updates via Query Database Smart Service) changes are correctly saved in my DB, but not sync (I have to do it manually to see the results in my Site) Do you think the problem is because I´m using a complex primary key (Text and concat value)? What can I do to fix and automatize my sync?

I have starting quarter, ending quarter ,startyear and end year. Need to get the quarter names dynamically in x axsis. For example, 01-10-2020 (4th quarter) to 08-09-2023(third quarter) Xaxsis categoreis should be Qtr4,Qtr1 2021, Qtr2,Qtr3,Qtr4,Qtr1 2022,Qtr2,....Qtr3 2023 Please any suggestions.

Hi everyone, On a process instance, I'm trying to Write on Data Store Entity a string value with the following characters: Ω μs. But instead, I have the following error: "javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: java.sql.SQLSyntaxErrorException: (conn=364712) Incorrect string value: '\xF0\x9D\x9B\xBA\x0A ...' " The field where I'm trying to store the value is varchar(4000), in Appian's database cloud mariadb.