Data Fabric

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.

Hi, In the process model I am not able to get all data as the output. To replicate the issue please find below details The process details Could you please help me in this

Hi! I have made a process in which my Invoice Lines (Record 1) are set with the status "Billed" in the end, after passing multiple logics. Now, I would like to query the Purchase Order Lines (Record 2) from my process model and set their status to "Billed" too. In this case, I have to apply the following conditions: 1) The Purchase Order ID is the same as the used in my process  2) The materials of the Order Lines are the same as the ones created in the process I have been trying with the query database smart service (update-set-where) but it gives me problems when trying to filter by a more than one string (materials) How can I afford this "update" in my process? Which smart services do you recommend me to use?

I have a process variable of map type and i am getting data like below array.How can i cast this to map.{id=1, Name=,class=12, sub=, }

Hi All, I created a process report and one of the column definition is a record field(pv!record.orderNumber)  and am not able to see it in report. When i check in documentation, I could see as below But when i try to query using a!queryProcessAnalystics, the field is still showing blank for me. Am i missing anything? Thanks in advance!

I have a rule rule expression which returns a datasubset in which the data has repeating rows. Since the data is coming from a view in mysql backend, I want to handle this in appian by getting only unique rows and remove all duplicate rows while still maintaining the paging. The data should be unique for 'stateroomRequestId'. I have tried using union but it does not work with datasubsets and only data a!queryEntity( entity: cons!BUS_ENTITY_REQUEST_VIEW_DETAILS, fetchtotalcount: ri!fetchtotalcount, query: a!query( selection: if( rule!APN_isEmpty(ri!selection), null, a!querySelection( columns: a!forEach( items: ri!selection, expression: a!queryColumn( field: fv!item ) ) ) ), aggregation: ri!aggregation, logicalexpression: a!queryLogicalExpression( operator: "AND", logicalexpressions: ri!logicalexpressions, filters: { ri!filters }, ignorefi

Hi All, I currently have 3 tables, managers, employees, and a third table for foreign keys managers_employees where I have a primary key, a foreign key to the managers table and a foreign key to the employees table. When I'm trying to write to the DB I'm having an issue with the employees foreign keys since they can be multiple employees but they all belong to the same manager. So for example my tables should look like this: managers table:  ID name 6  Alan, Nus Employees Table: ID Name 10  Kim, Perez 11 Luz, Asos managers_employees table ID  Manager_key   Employees_key 1        6                       10 2         6                       11 When I'm doing this in my process model in a script task after writing to the employees table, I'm not able to retrieve the employee

Hi all, Is it possible to add cusomField1 to 10 into record type user ? My first approach was adding a custom record field but user function cannot be used inside. Any idea ? Regards  Jean-Alain

Hi! I have a summary view with a read-only grid (from Record 1). When I run my process model, I make a query (type "UPDATE" and "SET") to change the status of one of the fields, and I need the read-only grid to update After I run the process model, the value of the variable in my Record Type (Data Preview) changes succesfully... But it does not change in my read-only grid (based on this record I have shown in the last image). To make it "update", I have to go to "Sync Options" --> Start Full Sync manually. After doing this, the read only grid updates. Y tried to use the refresh button of the read only grid but doesn´t work, only full sync What can be happening? Thanks a lot!

Brief Summary: I have a CDT with near to 500 fields that holds some values and just to mentioned I am not using any nested CDTs. I'm using that CDT inside an interface to hold values. I am worried if the application could face any issues in the future if it grows larger. I would like to know even if I have more than 500 fields, is it safe to use that CDT in the application or is it causes any issues in the future. Note: I don't wish to proceed for partial CDTs by breaking the entire CDT into sub-CDTs. Please list down what kind of issues my application may face, if any, down in the comments. Please help me clearing this and I would be gratefully for your help, Thank you.

Hi! I have a site page created from a record list (invoices) When I click in one of the Invoices Id, I access to a summary view (interface), in which I created not only additional information of the record "invoices", but also a read-only grid from another record (Invoice Lines). My problem here is that, if I try to eliminate the record (related record action) from this interface, it does not occur anything and the following error appears I suppose it is caused because of the read-only grid generated in the interface (if I add no editable grid, it works fine). How can I solve this and being able to delete the invoices with the read-only grid inside?

I have to aggregate data based on a column. With aggregate will I get all the Data if the DB contains > 20,000 records. How to achieve it

Hi! I was trying to use a query to obtain a value from a database. Concretely, I want to return the value of a custom record field, with some conditions/filters (the Purchase Order ID should be equal to the one used in the process, and the Status of the Invoice should be accepted). All of this are conditions based in the same record type. I had to use the custom record field (total invoice price, Record 1) to obtain the sum of the price of each invoice line (Record 2).  As I said,  I have not only source fields in my records, but also custom record fields. The problem here is that I can´t refer to the custom record field (pointed in red in the last picture) via query, because that fields are not shown in the database (cloud console). And the querys directly point to the database.  So, what would you recommend me in order to get the value of the custom record field? Is it possible to add the custom record field to the database, in order to make it possible to

Hi All, I have a scenario where i have to populate related action in one of the column in read only grid. For instance, the row with identifier 1 i will populate related action for identifier 2 in that specific column. The issue am facing is that even though i can open that related action with identifier 2, the name of related action is still showing like related action of identifier 1, Note: Am only facing this issue when am using a!recordData as source but I could get desired result when am using a!query record type.You can try this scenario making one value in column as a!recordActionItem(action: record action, identifier: fv!identifier+1 Please suggest if am missing anything here. Thanks in advance!