General

Hi everyone, CDT with 6 columns and database with 5 columns, Can we map that CDT to database table without adding 6th column in database? Thank you all in advance! Regards, Kiran Sajjan

Hi All,  I am using a simple gridfield where I am constructing its data . I can't able to sort the columns. Label and data for the grid is based on a condition. I am attaching the code snippet and the inputs. a!localVariables( local!unrecognizedPaging:a!pagingInfo(startIndex:1,batchSize:20), local!searchIdValuesUnrecognized:ri!searchIdValue, local!searchIdValuesUnrecognizedDs:todatasubset(ri!searchIdValue,local!unrecognizedPaging), a!gridField( data:todatasubset(local!searchIdValuesUnrecognizedDs,fv!pagingInfo), columns:{ a!gridColumn( label: if(ri!searchIdField = cons!GOS_CPD_IDENTIFIER_TEXT, "Compound ID", if(ri!searchIdField = cons!GOS_BAT_IDENTIFIER_TEXT, "Batch ID", "Batch Reference")), sortField:"cpdIdentifier", value:fv!row ) }, pageSize:2, pagingSaveInto:{fv!pagingInfo, a!save(local!unrecognizedPaging,fv!pagingInfo)}, selectionSaveInto: { local!unrecognizedPaging, a!save(local!searchIdValu

Hi, am showing list of tasks in read only grid. which is showing data in grid for all users in DEV,UAT and STG but in Production users are not able to see it only few users (belongs to some grp) are able to see the grid how can i find solution for it any suggestions. 

Hi Team, I am facing  below issue while executing jar file of Cucmber from command line prompt. could you please help me on this.

i need to  add a signature image to a  random pdf that could be uploaded to my app  is there any way to achieve  this ?

{a!localVariables(local!item:0,a!forEach( items: enumerate(2), expression: a!columnsLayout( columns: a!localVariables( local!outerIndex: fv!item, local!item:1, a!forEach( items: 1+enumerate(3), expression: a!columnLayout( contents: a!cardLayout( style: "INFO", contents: { a!textField( value:local!item, saveInto:a!save(local!item,tointeger(local!item)+1), ), a!richTextDisplayField( labelPosition: "COLLAPSED", align: "CENTER", value: a!richTextItem( text:local!item, color: "#1a1a00", size: "MEDIUM", ), ), }, height: "MEDIUM", shape: "ROUNDED", ), ) ) ) )),)} The above code will have 2 columns and 3 rows. it is giving the below output. but i want to display 1 2 3                                   4 5 6. If i apply some logic , i will get 1 2 3                          

Reading through the Query Database Smart Service documentation, it appears that an explicit transaction wraps every execution: https://docs.appian.com/suite/help/22.2/Query_Database_Smart_Service.html#:~:text=Activity%20execution,by%20the%20node Is there a way to shut this behavior off?  We have created a logging framework with all of our procedures, and can even get the error messages we're producing out of the process flows via the Outputs tab, but when all is said and done our logging messages are missing.  If I'm interpreting the above correctly, it's because the overall transaction is rolling back our logging inserts too. I'd really prefer to let errors be errors and just stop this behavior, but if that's not possible my catches will have to swallow the error and return my messaging through OUTPUT variables instead (an idea if anyone else is facing this same issue). Thanks! -Eric Rubeck

how to print fv!index in reverse order in foreach loop. E.g 5,4,3,2,1

Hi, In welcome to query data after following the below steps: Sign in to Community, and head to the My Learning Journey page. Click Get My Site in the My Community Edition Site card I Am not getting this option: Select your Cloud Region dialog, select a region for the instance and agree to the terms and conditions. Click Get My Site. can anyone help me with this?

Is there any solution or idea how to populate a rich text editor with some text? 

Is there a limit for the number of objects in an appian application ? will there be performance decrement if the number of object is increased from 100 to 500 ?

Hi Team, I want to calculate time in hours between two date time like on  18th 8am to 18th 10am :- 2 hours 18th 12pm to 18th 8pm :- 8 hours  total :- 10 hours Can anyone please help calworkhours is not working properly.

Hello,  how can I access to my expression editor? I already got my appian community, but couldn't access to the expression editor 

I have the below sample json variable. i want to get the number of values under tags.  local!Json:{ tags:{ "description": " ", "displayName": "" }, { "description": "", "displayName": "" }, { "description": "", "displayName": "" }, }, To achieve this, i have tried using  count(local!Json.tags.displayName). it is throwing the below error. "Cannot index property 'displayName' of type String into type List of Variant". How to resolve this?

Hi everyone, Hope everyone is doing well and safe. Can any one help me with Leveraging activity-chaining with example.? How can we pass data from one process to other process by using start process smart service? Thank you all in advance! Regards, Kiran Sajjan

I'm trying to insert one  image to my word document i have seen a lot of post about this topic but any of them work for me most of them tell how to add an array  of images  but i  just have  one image that i want to be shown in my word y  updated the field in the word document i also edited the fields i have the image as a bookmark i sent the  image as dinamic cdt  with and without the index added i made sure this constant has a value also this constant is referring to a image  i tried to pass in xmlformat  converting my pv variable and converting it into a document to make sure and nothing i also tried to  add the image as xml . i also tried everything  with this template an nothing

Hi all, As per my understanding these objects Query Rule and Expression rule are same, then Why it's given in filter panel for Query Rule? Is it any other way to create QR? We can filter by Expression Rule on filter panel. It doesn't show any objects if I filter with Query Rule. What is the purpose of this filter Query Rule? Please clarify on this... thank you in advance!

I'm trying to use the file upload functionality in Appian Interface and is there any way I can restrict from uploading the file with the same name which already exists in the db or even if it allows the upload is there a way to over write the existing file with the latest file?

Hi Everyone, I am getting a variable of type Map from Appian RPA Integration in Execute Robotic Process smart service, the values are coming like below as a single Map variable: { varABCIndex=26, varSiteNameIndex=16, varCurrentMonthTotal=64, varProjectIdIndex=24, varExcelModifySourceFilePath=, varOutputDocId=164646} Suppose I want to fetch value of varOutputDocId from this map variable, so how I can fetch this value. Please suggest.

Updated to "Arial" font and size "small", but when inspect the content in mail it is showing me Arial, Helvetica, sans-serif. If Arial then it should be only Arial, why all these right?

HI am getting like this error  what might be the reason?

Hi   Is there any option in appian to  sync user role information from UI to DB and viceversa. Thanks in Advance

I would like to know if there is any limitations in terms of number of rows or the memory limit to export the data to excel by using export DSE to excel smart service. As I am aware there is a limitation of 50 in terms of columns. I am curious to know if there is such limitations in terms of rows or the data limit.

i have 3 columnslayout i will show 2nd columnlayout when i click a link on first columnlayout, using showwhen:not(isnull(local!selectedcards)).---->it is working fine Same way, if i click a link on 2nd columnlayout i want to show 3rd columnlayout(using same showwhen()).------->it is working , but it is not hiding 2nd columnlayout. it is displaying both 2nd and 3rd layout. How to give condition for this in showwhen?

Hii Guys!! where we can find the saved draft forms in process model can anybody help me to share about this please