Data Fabric

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!

I want to generate a table inside a word doc, below is the config of the smart service "Text Doc from Template": 

I need to make a record-like query for a 1 to N relationship, in which it only returns the values ​​of the parent record if all the values ​​in the N relationship meet a condition. Example : I have a record called "Need" and it is related to another called "needchangestate" through a relationship 1 to N, I need it to return only the needs where all the needchangestate meet a condition, if all the elements of the relationship N do not meet the condition, the element Need should not appear Currently it returns me an investment where the condition is met in at least one of the records of the relationship N but this is not what I am looking for.

I need to deploy a series of datatypes to another environment. So I deployed the datatypes and then the datastore, and overwrote the original. Now the datatypes I needed are on the new datastore.But when I go on with the deployment sending the rest of the changes to my environment, the Data store entities constants related to the datatypes I recently sent to my other environment give me the following error: UnresolvedDataStoreEntityException: entity [...] in data store [id=... uuid=...] cannot be found.help, please!

Hi, I need help understanding why record sync is not occurring when using the "Write to Datastore" smart service in one environment, while the latest data appears in the records in another environment. In the environment where sync is not happening, a manual sync is required to view the latest data. Can someone help me understand the cause of this issue?

Hi, I'm using Appian 24.2.270.0 and trying to insert an eventHistoryListField with comments in an interface , but when I click in the field for comments, the buttons appears like in the image here below.By clicking, the comment is inserted fine but why those buttons?Any solution?Thanks!

I want to change the field name of a CDT to match the renamed field in the database. The old name was "FIRSTNAME" and the new one is "FIRST_NAME". Related to the best practices, the best way to do so is to download the CDT as XSD, change the field name in there, and re-upload the XSD, verify and publish the data store as a last step or is there any other best practice thing? Thanks in advance.

Can I add hidden record fields if data sync is NOT enabled on a record type?

Hi All, Hope you all are doing well, quick question, is it true that using a!queryEntity can skip the Record Type synchronization? I'm facing issues in my application cause I have an after insert trigger that is inserting a record based on some conditions, but the new record inserted is not being reflected in the application until I manually click Start Full Sync, wondering how can avoid this issue. By the way the version that I have is 23.4 Any help would be greatly appreciated. Thanks in advance, Jose Castellot

Hi Team., I have made changes in the DB for the column size changes, but in the Record type is not getting reflected in RT, or is any modifications need to be done here. note: no CDT used in the application only RT. thanks.

User uploads the word file with number of screenshots to APPAIN using file upload component in an interface, but some of the images in the word file is missing and facing the blank space in the place of image, what might the cause for it.

Hi, Am unable to use aggregate functions on child CDT having many to many relationships with parent CDT. Background I have a parent CDT called Campaign which has many to many relationship with child CDT called Channel. I have Campaign table, Channel table and mapping table as well to hold the relationship in database. Requirement I need to group the Campaigns based on Channels. Issue I am unable to use Aggregate functions on channels field in my Parent CDT - Campaign. How can I achieve this using CDT relationships. Thanks  

Hi team, I am fetching data from database for KPI and the field names that are showing on y axis taking lot spaces can anyone help in this. Requirement: "New product Development" field   Name taking lot of space and  the field name is dynamic it may be 20 characters or 30 characters. How can I restrict space on y axis