Data Fabric

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? 

Hi, I have a cdt that stores a list of document ids that were uploaded, how can I display all the files using document view? Do I need to use a!foreach() or is there another way?

I'm currently trying to add a Pie chart into a reporting page.The report is doing a record type query and simply pulling back IdItemsThe issue is my Items are an array The DB table looks like  1 Widget 2 Widget / Whatsit 3 Whatsit / Dohicky i would like my pie to show a slice for each item, but at the moment I'm getting a slice per item (so 3 in total)How can i split the data so i have a slice for widgets (2 items), a slice for whatsits (2 items)and one for dohicky (i item)

I have record which has " created on "field. I wanted to filter all records that is created for this year. But when I try to convert the created on field to year for comparison. It shows error.  Expression evaluation error at function a!queryRecordType: Could not cast from Record Field to Date. Details: CastInvalidCould not cast from Record Field to Date. Details: CastInvalid Any help is appreciated

I am a beginner with Appian. In the interface, I input values for each field of a record type and save them to process variables. In the process model, I want to reference the same record, subtract a specific field from the corresponding process variable, and perform the following actions: If the result is 0 or below, I want to send an email without changing the value.If the result is 1 or above, I want to save the calculated result in a process variable and send an email.Can you guide me on how to achieve this in Appian?

I want to calculate number of working days between two dates (record field) and use the output as a custom field in the record. Getting stuck while trying to use calworkDays in a!customFieldDateDiff function. Can anyone please help

Simple explanation: I want to quickly see all of the objects belonging to the current application on one scrollable sheet of sorts (Spreadsheet, Interface, TXT, etc). Complex explanation: I can't seem to find any way to utilize readcsvpaging / readlogpaging with any of the system logs to get ALL of the application objects. I can muster up a list of Interfaces, Expression Rules, Integrations, Process Models, etc. but not ALL objects. It's already hard work to parse these individually (not that it isn't done), but I would like to know if there's a way to do this in the Community Edition / Paid Edition respectively. If anyone can provide a solution, or needs more information, I'd be happy to divulge further. Attached is a sample of retrieving information of one object. Utilizing UUID / Name, I am able to find a good amount of object information, but this does not cover all application objects. Thanks, Jacob

I  have created tables in dev but i don't have the sql scripts of those tables .is there a way to retrieve those sql scripts

Hi! I'm having trouble trying to modify this list of maps (which I get from a!queryRecordType with an aggregation). local!Grades: {a!map(Group: "A", Excellent: 0, Good: 0, Regular: 0),a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 0, Regular: 2),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 0),a!map(Group: "C", Excellent: 0, Good: 2, Regular: 0),}, The aggregation does not allow me to get each Group in only 1 row, because I need to "count" the grades by category (Excellent, Good, Regular) I would like to display that result in a read-only grid and am trying to prepare the data before displaying it there (as I read in some other suggestions). The result I am trying to obtain is this: local!Grades: {a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 2),a!map(Group: "C", Excellent: 0, Good: 2, Regu

 [mention:89ec515a02ff4fa28317edeb40cf0a4d:e9ed411860ed4f2ba0265705b8793d05]  [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  and [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] will be there - come ask them your questions live!

Hi Export Data Store entity to csv smart service cannot work expectedly. Export Data Store entity to csv smart service only 50 columns can be used. I have more than 50 columns ,so i want to select desire column . but got error and cannot fix error.pls help !! Thanks

Hi I am having 2,60,000 of data in MS SQL Server. How can I bring all the data from MS SQL Server and store it in Appian Cloud database.

What's the best way to have a process report that filters for all processes that have hit the end node and its blue. Basically, this sub process was kicked off by a parent wrapper process. The parent would kick off this sub process, the user would go to the first interface, we had a timeout mechanic where if the user didnt take action within a set time, it expired and hit the end node. However, going to this end event did not end the parent process and now the process is staying open. We have since fixed this and made this End Event node a terminate node, but in our process dashboard now, theres 10,000+ processes that are stuck in active status because the node was not properly terminated and the parent process is keeping it alive. This is taking up memory in the system, and I want to try to identify all the processes where this happened so I can delete them. Is there also an easy to way mass delete these process models once I have a good report that only includes them? Our