Data Fabric

Hi All,We faced one issue during deployment to production. We have an API which triggers a process model and we are saving into database using write to records. Yesterday we added a new column to that record and it was getting deployed. During that deployment window, we received some cases via API. Details were getting written to database but while trying to query data, no data was being retrieved. The record was being updated and sync was occuring during that time. This is the first time we are facing such issue. Has anyone faced similar issue? Any reason this might have occured??

I have the local variable called "encargo" to get a single record from a RecordType filtering by an id key. I want to get all the fields of the record type. Is there any way to tell it to the "fields" parameter or have I to list all of them instead?: local!encargo: a!queryRecordType(  recordType: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian',  fields: {    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{48d20aa7-6bfb-42ac-9ea0-0396fafa7ffd}fechasolicitud'  filters: a!queryFilter(    field: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    operator: "=",    value: ri!id  ),  pagingInfo: a!pagingInfo(startIndex: 1, ba

Felw amount fields i have created as DECIMAL in Database, but it got mapped as INTEGER in Appian record. How to get decimal as a datatype in Appian as well? What should be the source field datatype to achieve this?

The Appian product works with its own database in which it stores its internal process data or Record Type synchronization, right?So, if we want to have a database in which we store, for example, Master or audit data, is it advisable to use the Appian databaseor create another one for the project we are developing?Thanks.

Hi all. I'm starting a new app and I have big dilemma because I don't know if is better to use CDTs or Record Types. I won't connect directly to a database to get/post records but I'll connect to a webservice to do so. You have to keep in mind that the records can be added/modified/deleted from Appian calling webservices or from other non Appian applications. So, If I use Record Types, I'll get the refreshed records without sync every few minutes? Has anyone experience about this topic? Thanks in advance.

Hi Everyone,I have a table with one column type as JSON datatype and using to save the data through write to records. Now I have to export this table data into excel file and share it everyday so I have created a CDT for that table.In CDT it is defaulted to text even I have given longtext datatype. Now there is an issue with the data as the database table have more than 4000 characters the CDT is not allowing more the 4000 so my data into excel is not exceeding more than 4000 characters.Please suggest how to handle this or any alternate better approach.

Can I create Service-Backed_Record with POST API which returns data on input parameter, How differently it works from GET API. What could be the possible I may face if I use POST API for Service-Backed_Record.

Muy buenos dias  estoy realizando el curos de APPIAN y el comunity no me esta dejando crear nuevos recorda Type ya no aparece esta opcion como antes en la imagen adjunta les muesto como apareceia antes y como esta apareciendo ahora  Alguien me podria ayudar por favor ?  quedo super atenta 

HI. I attempted to do a rather large import of an application over our PP environments version. I looked over a record that had some Record Related Action name changes to it. Testing it afterwards, only half of the related action name updates took on import.  I confirmed the record was modified on import. Has anyone ever had this happen before?  I have no way to deploy proper changes due to this.

Yesterday I created a record from a Record Type list action. I can see the record in the database and when I open the Record Type View I see the record as well. My doubt is why I can see the record if the last sync was last month. As far a I know, when you use a Record Type it is necessary to sync the data. Is there any way you can configure an automatic sync or sometrhing like that? Thanks.

Hi All, I am working on a scheduled workflow where I have to check for existing active instance and if it is still active without any errors, I can skip my run. If it is errored out in any node, I can proceed with the current flow. I checked in https://docs.appian.com/suite/help/23.2/Process_and_Report_Data.html and can see there is a possibility to get the details only if the instance is Paused by Exception.Anyone have any workaround for my case?I am thinking if there is a possibility that Appian is showing the status as "Active with Errors" and Error count as "1". There should be some report option available to get the same data. Right?Anyone have any idea how to achieve this?

Please suggest  how can we calculate years given by days using record types

We have two separate databases: a legacy one (Oracle) and a current one (MariaDB). We do not want to import the legacy data into the current database. However, our customer wants to be able to search records across both databases. The requirement is to connect both databases to our current application and build a search interface on a single page. There is no relationship between the two databases; the cases exist independently in each database and need to be merged for the search. Is there a way to connect both schemas and build a unified search interface? How can we solve this problem using Appian?

Hi, I have a 2 record with one to many relationship. I am trying to write the parent and the related records. The child record will have multiple values . Each value should get inserted in different rows. When I tried foreach loop for the related record it is storing all  the values in the same row of child record. Please help me with this

Created new record type for subscriber Added relationship with base record type Eventhistory eventType event thread configured. flowed below steps  On the base record type, edit the record events configuration: Go to Events. Click EDIT. Configure the following Subscriber properties: there is no option to add subscriber record and unable to see the subscriber icon on event history in summary view  anyone implemented please post your suggestion  @Everyone  we upgraded now to 25.1.  while enabling subscriber am facing issue a!eventHistoryListField [line 736]: Unable to write to or delete from the source due to a data integrity violation. Error Details: Field 'ID' doesn't have a default value anyone faced the same issue, any suggestions or inputs helpful thanks in advance   

I have a process that needs to store entities and alerts in different tables. Flow of the process: First, I need to save the entity using the Write Record Smart Service. After the entity is saved, I need to get the ID of the created entity. Using this ID, I will then save the corresponding alert with another Write Record Smart Service. Question: Is there a way to get the ID of the newly created entity directly from the Write Record Smart Service, without having to perform an additional query from the record or database? Here is the example of process:

Hi all, I'm a bit new with custom record fields, so I'm probably doing something wrong. I have header and detail records (with a one-to-many relationship connected with a detail reference to the header key), and that data flows throughout the system just fine.  But I added a real-time aggregation / sum custom field (for totaling amounts in the detail record for presentation) and am having trouble getting data into the new fields. When pressing the 'Test' button in the Edit Custom Record Field screen, I see data grouped and summed as needed which is great! After saving the new custom field, the 'Data Preview' test button does NOT return any data in the new field, and that is also the case with an interface that references this. I've done resync on both records.  The new custom field exists on the detail side of the relationship and when defining the field, I use the format: headerRec.detailRec.amountToBeSummed. I've a

Hello, We need to export data from a database based on user-selected filters into an Excel sheet for reporting. Currently, our process queries data in batches of 500 rows and uses the deprecated "Export CDT to Excel" function to generate the report, as we need to export 80 columns. Since we are running in batches, we cannot keep the smart service into separate start process as we are appending the generated document with new values and incrementing the start index.  However, as the data volume has increased, users are exporting data upto 50,000 rows, leading to memory heap issues causing Appian server to go down. The latest export functions have a limitation of 50 columns, which does not meet our requirements. We made process variables as hidden but still memory is hitting upto 6k AMU. We are using mySQL as database which is hosted on AWS RDS. Currently we are using a!executeStoredProcedureForQuery() to query the data from database. Before we wer

So, I'm building a record where i have all the items in the store, then i can drill down to 1 item and update ir, but when i click on update item related action i get this error:  An error occurred while applying the context for the AS Items In Store related action [identifier=21]. Details: No process parameter found corresponding to override [name=pv!item]. Non-parameter process variables cannot be overridden. Any help?

Hi, I'm just getting started with learning Appian. Was trying to create a recordtype from scratch with v25.1 community edition. But, dont see an option to do so Can someone please help?

Hi team,Scenario - There are many table for our application and all of these tables have there respective Appian records. Now, if someone adds unique key constraint to any of the column on any table then we also need to re-map column on the respective records. Ask - Is there any direct way to generate a summary report to fetch all the records whose mapping of columns is breaking/ where we need to remap the columns in our record.

I want to add searchable filters in a recordtype, is there anyway to achieve this? For example, i have made a custom filter below which calls DB & gets the productionUnitCode upto 15 & then i can select multiple in it. I want same thing with record filter rather than custom making it.

hi, I was wondering if I can export data in process model  with expression rule? Data from expression rule: List of Dictionary - 2 items    Dictionary           name "John"(Text)           memberID"X123"(Text)    Dictionary         name "Jane"(Text)         memberID"X456"(Text) Export the below data to csv or txt file( without any header) John, X123 Jane, X456

Hello Appian Community, I've been given a somewhat complex JSON format to ingest into Appian and stage all the data into the DB.  The intention of the data is for reference/comparison/reporting.  I've tested the regular readtextfromfile/fromJson/jsonPath functions to grab each attribute but it feels very tedious/clunky to have an JSON path expression for ever attribute I need.  Could I get any advice on a more efficient way to parse this data and get it in the DB? Data Context: One JSON will have thousands of "FullProduct" entities so I will be dealing with files with a size of at most 25MB.  This structure is the final format so there is no altering the original file. JSON Sample: { "FULLPRODUCTFILE": [ { "FullProduct": { "ID": "*dfg333", "Details": { "StatusType": "LIVE", "Status": "ACTIVE" }, "Classification": [

I have a View in the Appian Cloud database with a column that concatenates some values, lets call it column "CODES". I started in our dev environments creating a CDT from Table/View and verifying the datastore. I then did a distribution to the test environment of the CDT, View and Datastore. While verifying in test environment I get an error that CODES is not a MEDIUMTEXT, it's a LONGTEXT. Not knowing what to do I try to create the CDT in test environment and actually the generated CDT in this environment is different that the one that was generated in dev, even though the database view is the same. Any suggestions on how to solve this issue? The thing is that I don't know in a production environment which datatype Appian will choose, and I don't want to create objects manually in production, I shouldn't even be able to. Thank you!