Records

Hi,I've already used the updatedictionary and update functions with CDT, but how it works with RecordType? Could you show me the correct syntax please ?/* works fine with CDT */ local!dataVehicles: a!queryEntity(...), local!vehicles: a!forEach( items: local!dataVehicles, expression: a!update( data: fv!item, index: { "id", "model" }, value: { 1, fv!item.model } ) ) /* does not work */ local!dataVeh: a!queryRecordType( recordType: 'recordType!Vehicles', fields: { 'Vehicles.fields.id', 'Vehicles.fields.model' }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!vehicles: a!forEach( items: local!dataVeh, expression: a!update( data: fv!item['recordType!Vehicle'], index: { 'recordType!Vehicle.fields.id', 'recordType!Vehicle.fields.model' }, value: { 1, fv!item.model } ) )

It is very difficult to figure out what should be the inputs of the mentioned fields on this page.Can someone please explain what input should be given in each of these fields and especially on the "Connection String"?P.S: Don't give links to documentations.Your help will be highly appreciated.Thanks

Hi Team, I have a record type for orders and it is pointing to orders table from maria DB. The data in the record type is not matching with the data in the DB, what could be the scenarios?

I created a grid with recordtype, I have 10 fields in my recordType but on grid am showing only five fields, when i click export to excel button it exports on five fields data, but i want all of the field should be exported.

Used a!RecordFilterList in a record type. It is working fine but a default dropdown option "any" is coming, want to remove it is there any way?

Hi EveryOne, when I'm Publish the Data Store Entity I am getting the following error: can you please help with this. Thanks...

I created a record type before in my application and right now I don't need anymore. I tried to delete from application but I got it this error. What is the problem?

Every where we can use the record over the cdt. what is use of cdt over record? where can  we use cdt instead of Record? 

I'm working with data via API that uses composite keys and need to store the data in Record type. However, I understand that composite keys are not supported in record types. Could anyone suggest a way to handle this situation or provide any workarounds?

I wasn't able to delete the last question previously, as it was not required anymore. Then I just turned it into to this new question, and I want to know if is that possible to delete a question in "Discuss" forum, or why it is not. Thanks in advance

Hi All, In the database the createdBy field holds "userid@test.com" which is the userid of the user. When i create a recordist using the respective table and have the OOTB search on createdBy field to get the record on  using  "John" or "Smith"  as the search value , it doesnt return any record. But if search on email return the data. ( Note: John and Smith is the first and last name of the user). The custom grid in front end holds the Display field using user function. But as the recordlist is created on userid , search on First or Last name is not returning any record. Multiple options tried: 1) Created a custom field , but user function cannot be called in custom field                                     2) Changed the data type field from text to User type  in the mapped fields of RecordType and called in recordlist . Still

Data I got from CDTdata=[date_month:1,templateId_count:3,templateName:Accident / Near Miss]; [date_month:1,templateId_count:22,templateName:DFTC Lousado]; [date_month:1,templateId_count:12,templateName:Duplicated items process]; [date_month:1,templateId_count:3,templateName:ESP Summary Report]; [date_month:1,templateId_count:2,templateName:Every Month]; \ Need to be transformed like data= [date_month:1,"Accident / Near Miss":3,]; [date_month:1,"DFTC Lousado":22]; [date_month:1,"Duplicated items process":12]; [date_month:1,"ESP Summary Report":3]; [date_month:1,"Every Month":2]; or  data= [date_month:1,"Accident / Near Miss":3,"DFTC Lousado":22,"Duplicated items process":12, "ESP Summary Report":3, ,"Every Month":2] To use it in a stack chart plot date_month on the 'x' axis. How to achieve this?

Hello folks,  I created a record action and showing the record type grid  with the record action as the landing page on site,  by default the record action is coming on the left side..Is there any option to shift it to the right side 

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

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 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?