Data Fabric

HI  I am trying to duplicate a field in database table along with data Can any one suggest me how to do this?

Hi, I have a record type whose structutre is: Start: local!RecordA ( - field 1, - field n, - Relationship: Record b1 ( --- field 1, --- field 2 ) Record a --> b 1:m relationship. After some manipulation, I want record a to become: End local!recordA ( - field 1, - field n, - Relationship: { record b1 (field 1, field2), record b2 (field 1: null, field2: null)} How can i go from start to End? Could you help me? I hope the aim is clear. Thanks a lot

can we use this record sync history to display in interface?

I'm currently working on a functionality that involves view with huge dataset in Appian and I am planning to replace it with record relationship. I have a situation where I'm using a left join with a table and implementing a self-join with three conditions using the AND operator. Here's the view that I want to replace. SELECT `snapFrom`.`id` AS `id`, `snapFrom`.`material` AS `material`, CAST( `snapFrom`.`FCFinalTotal` AS DOUBLE ) AS `FCFinalTotalFrom`, CAST(`snapTo`.`FCFinalTotal` AS DOUBLE) AS `FCFinalTotalTo`, `snapFrom`.`snapshot` AS `snapFrom`, `snapTo`.`snapshot` AS `snapTo`, `snapTo`.`FCFinalTotal` - `snapFrom`.`FCFinalTotal` AS `diffValue`, CONCAT( SUBSTRING_INDEX(`snapFrom`.`calWeek`, '.', -1), '.', SUBSTRING_INDEX(`snapFrom`.`calWeek`, '.', 1) ) AS `calWeek`, `m`.`basecode` AS `baseCode`FROM ( ( `Appian`.`SOE_STAGING_FORECAST_WEEKLY` `snapFrom` LEFT JOIN `Appian`.`SOE_STAGING_FORECAST_WEEKLY` `snapTo` ON ( `snapFrom`.`calWeek` = `s

Hi All,  One of our process report is not showing correct data, it was working fine few days back but suddenly it is removing few data.  In process report performance details have got this error: Comparison (Evaluation of Status) (EVAL:@reason=rank)  What does this error means and how to resolve this. Thanks.

On the click of a button, we are populating values from the process model back to the interface. This is working perfectly for some users. But for some users, its throwing expression evaluation error even when the data is same in both cases. Could this be related to any permission or security issue?Update : This is occuring for users who only have access to site page.Thanks in advance

Hi, Wanted to understand on how Appian parses an Expression Rule that uses a!queryAggregation and a!queryAggregationColumn against a Table/View? Does it convert and send a query as-is with GROUP By to the database SQL engine or does it get the data and then do the grouping on-fly in its memory? Thank you in advance for your response.

I need to store a user id, along side several picture uploads all in a relational database. My solution for storing the pictures would be to save the pictures locally on appian and save the document ids on the database alongside the user id. However, with the way I have it implemented right now it seems I cannot pass in the user id into the body alongside the picture upload as it takes up the entire body. I also cannot attach several pictures for upload. I need a way to be able to pass in the user id and atleast 3 pictures into the body to be saved in the database.

Hi team, I've tried to run the following query in Appian DB and im getting syntax errors. Please advise  CREATE PROCEDURE process_batches()BEGIN DECLARE batch_size INT DEFAULT 0; SET batch_size = 10; SET batch_limit = 51; WHILE batch_size <= batch_limit DECLARE CONTINUE HANDLER FOR SQLEXCEPTION; BEGIN ROLLBACK; -- Rollback transaction on error END; START TRANSACTION; UPDATE `CM_AH_Segmentation` SET `Handled`=1 WHERE `RecordID`<= batch_size ; UPDATE `CM_AccountHolder` as ah join `CM_AH_Segmentation` as cas ON ah.AccountHolderID = cas.AccountHolderID and cas.OldSegment <> cas.NewSegment SET ah.Segment= cas.NewSegment WHERE cas.handled = 1; INSERT INTO `GLB_AuditInfo`( `ReferenceID`, `Event`, `Action`, `ActorLoginID`, `AppName`, `Comment`, `CreatedOn` ) SELECT cahl.CaseID, 'Risk Investigation', 'Update Segmentation', 'System Admin', 'Risk Investigation', CONCAT( 'Update segment for AH ', cas.AccountHolderID, ' from &#3

a!localVariables( local!emails:{ "def@gmail.com","abc@gmail.com"}, local!a, a!formLayout( label: "Form", contents: {}, buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", submit: true, saveInto: { a!forEach(items: local!emails, expression: a!writeRecords( records: 'recordType!{c5b11a4d-cd52-43c4-ab87-2e1ef53bfcee}BMA Emails'( 'recordType!{c5b11a4d-cd52-43c4-ab87-2e1ef53bfcee}BMA Emails.fields.{20167940-35f1-4106-9a3b-6a585ba2fff2}email': fv!item, ), onSuccess: {a!save(local!a,append(local!a,1))}, onError: {} ))}, style: "SOLID", loadingIndicator: true ) }, secondaryButtons: { a!buttonWidget( label: "Cancel", value: true, saveInto: {}, submit: true, style: "OUTLINE", validate: false

Hi team, i have requirement to implement of column chart to show number of cases created with in the year, by highlighting the current month with different color. i couldn't able to complete logic here a!chartseries (color:?), a!localVariables( local!casescountbyyear: { 4, 5, 6, 7, 8,5,7,8,3,2,8,9}, { a!cardLayout( contents: { a!columnChartField( categories: { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }, series: { a!chartSeries( label: "Cases", data: local!casescountbyyear ) }, showLegend: false, showTooltips: true, allowImageDownload: true, colorScheme: a!colorSchemeCustom(colors: { "#3d85c6", "#9d225f", }) ), },

Hi All, I have 2 tables TABLE1 and TABLE1_HISTORY. I need to combine latest 1 row from TABLE1 and few historical rows from TABLE1_HISTORY and display the values in a single grid. Instead of using UNION to combine the 2 tables using DB views or querying the 2 tables separately and combine in Appian side , is there a way to union 2 tables using recordtypes ?  relationship creation is not working as the PK / FK  relationship doesn't exist. Note Here: As per our current design , the common field between the 2 tables are not a PK field in either of the tables because of which i am not able to create relationship as join / union in SQL.  Appreciate the suggestions. Thanks in advance  Raj

in a paragraph field i will provide input as  test1 test2 test3 How this data will be stored in db ,is it will be in line by line as separate string or as a single string

Hi, If I update an existing CDT in dev, do I need to deploy data store too while deploying CDT in Test or other regions?

a!formLayout( label: if( ri!isUpdate, "Update Assessment", "Create Assessment" ), contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField(label: local!consequence), a!dateField( label: "Perform Date", labelPosition: "ABOVE", required: true, value: ri!record['recordType!{c09e0e7e-5af6-43ec-b8ba-7fae37884015}PVS Assessment.fields.{d5ec6e7b-3eb6-4ff9-80d8-e8d66785f8a5}performDate'], saveInto: ri!record['recordType!{c09e0e7e-5af6-43ec-b8ba-7fae37884015}PVS Assessment.fields.{d5ec6e7b-3eb6-4ff9-80d8-e8d66785f8a5}performDate'] ), a!radioButtonField( label: "Assessed", choicelabels: "People", choiceValues: { 1 }, value: ri!record['recordType!{c09e0e7e-5af6-43ec-b8ba-7fae37884015}PVS Assessment.

HI All, I am trying to fetch data from the appian report and report has around 50k records. So I am using loop of batchsize 2500 to fetch the data from the Appian report using queryProcessAnalytics(), but when the startIndex becomes 10001 (i.e greater then 10k( it's giving me the following error. What's the possible solution for the same ? And is there a way if I can do it without changing any system configuration.

v21.4 Cloud I am getting the below error when updating data of a synced record using a process that has Write to Data Store Entity nodes and Write to Multiple Data Store Entities nodes. [Appian Work Item - 773428 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.record.service.RecordReplicaUpdateService - Loading updates to synced record type(s) in ADS failed, invalidated record type(s): [(da0a35ad-c98f-40e7-975c-47ff016a2084,WMS Request)] com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. Issue identifier: [8d98eb66-d7a7-4786-b881-d48850c684cb] (APNX-1-4521-016) ...com.appian.data.client.AdsUserInputException: APNX-3-1000-030: Invalid transaction data. Cannot update the same entity multiple times in the same transaction. Invalid id(s): (100218067) This error is not covered in the docs so unable to find guidance on how to resolve it - docs.appian.com/suite/help/21.4/Records_Monitoring_Details.html#other-sync-er

In the above image i am trying to show the monthly trend of production time in minutes , but i need to show this in percentage , can any one help me with this?

Hi What is the best way to convert it the time from 12hr AM/PM format to 24hr format as the users are getting confused and incorrectly inputting AM/PM leading to challenges. What is the best way then to represent this as a date and time picker in minute intervals for users. Thank you.

Hello everyone,  I have a table with several fields 'year_field' and 'month_field' forming the table's primmary key. It's mandatory that the fields remain as primary key. When I do that, Appian doesn't allow you create record or cdt associated with the data store. I have come up with a solution, but it might not be the optimal one. I will show it to you just in case either you have something to add or different way to make it better. The idea is to create a procedure to write, update and delete data in the table. Instead of using 'Write Record' node, the procedure would be triggered based on the operation you want to perform. For reading purposes, I have thought to create a 'Materialize View' where the view includes the primary key. That is my solution. If you have a smarter way to do this, please let me know. King regards and thanks

I establish a One-to-One parent-child relationship in Appian by including a reference field for the child Custom Data Type (CDT) within the parent CDT during creation. Although the parent CDT is successfully published in the database, initially, the child lacks a primary key. Appian generates the primary key in the child after publication, associating it as a foreign key in the parent table. However, an issue arises during parent  table updates; instead of updating the child table, it consistently creates new records. Recognizing this is likely due to the absence of a primary key in the child CDT, I added the necessary primary key during the update of child table  and the child table continues to create new records rather than updating existing ones. Seeking a solution for this behavior.

Hi!, We have a web service based record type that needs to be synced overnight in batches as we need to sync more than a thousand records. Batch 1 returns information that needs to be used while calling subsequent batches. We have not been able to find a way to store this information as the record data source expression rule is not allowing to call write record smart service or do a post call to a web API. Any help is greatly appreciated. Thank you!

Hi, I got this error when try to verify Data Store. However it is working in Dev environment and fails in UAT. Thanks

Reframing the whole question, can we change the datatype of column from one datatype to another datatype? 

At this year's Appian Government, Michael Beckley alluded to existing solutions for government Appian configurations to facilitate data transfer from low-side (unclassified) environments to high-side (classified) environments. Our use case is exactly this - move data from low-side systems to air-gapped high-side systems so the both datasets can be accessed from one place. [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05]  [mention:3f2c284660224ff9b6f64736624c289d:e9ed411860ed4f2ba0265705b8793d05]  [mention:7fe03aa321af4cadbca97d8d1fc1a492:e9ed411860ed4f2ba0265705b8793d05]  Do you know whether such a solution exists?