Records

Is there an option to delete an unused action? I was following the tutorial and adding a new action on Record Type. I realized, that I chose the wrong option, and created the action without auto-generated Process Model and Interface.I didn't know how to remove the action, so I thought, that maybe if I remove the empty Process Model and Interface associatedwith the action, it would dissapear. Doing that however only made things worse, as now I couldn't create a new action, due toan error on the existing one (Process Model not found), so I had to put it back in. Now I have two actions, one of which is not needed. How do I delete it?

I have a read only grid  contains 1 column with clickable link, when I will click on the link field then it will suppose to open a grid consist of related data below that row.   How I can achieve it ?

I was doing some User Filters for some not synced Record Types that sources from web requests And noticed that when there are two possible labels with the same text inside a a!recordFilterChoices it raises an error saying that the labels are duplicated even when its selection values are different. But, this behavior is not present on a!multipleDropdownField, it works just fine as shown below: Is it possible to replicate this behavior to a!recordFilterChoices as the label is something that the user can freely change and that change can lead to a more fragile and prone to error system ? Thanks in advance, Best regards [emoticon:c4563cd7d5574777a71c318021cbbcc8]

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