General

Hi Champs, I need to fetch only unique value from a dictionary with the latest data. Below is the sample of the output Here you can see color highlighted ones are same value of training name. So instead of 5 dictionary I want only 3 with unique training name . For unique data I want to fetch the latest of duplicate data.

Fitnesse supported Appian 23.1 version to select a value from drop-down but the upgraded version 24.1 is not supporting Fitnesse to pick a value from drop-down. Can anyone help how to resolve this issue? Syntax not working:  populate field FIELD_LABEL or [INDEX] or FIELD_LABEL[INDEX] with VALUE(S) populate dropdown FIELD_LABEL or [INDEX] or FIELD_LABEL[INDEX] search box withVALUE

Hi All, I have a query that "Do we have any limit on number of rows to display in an editable grid?".  I have a requirement where I am fetching the data from DB and showing in editable grid for user to edit and update but after few months it might be possible that the number reaches to 10k. So just wanted to know if we have the limit of rows in editable grid. 

Hello. I am making calls with an integration to an external system and I am unable to use Appian's built-in JSON formatter to do so. As far as I have read on the documentation, I am also unable to do the type of string manipulation necessary to dynamically construct the JSON from scratch so that it is compatible. I am only able to statically send text as JSON for it to work. Here are the bodies and results for a success and failure: Body (Content Type: JSON):  "[ { ""startPublicationDate"": ""2021-09-05"", ""endPublicationDate"": ""2021-09-05"" } ]" Result: Body (Content Type: JSON):  concat( "[ ", a!toJson( value: a!map( startPublicationDate: concat( text(ri!startPublicationDate, "yyyy"), "-", text(ri!startPublicationDate, "mm"), "-", text(ri!startPublicationDate, "dd") ), endPublicationdate: concat( text(ri!endPublicationDate, "yyyy"), "-", text(ri!endPublicationDate, "mm"), "-", text(ri!endPublicationDate, "dd") ) ) ), " ]" ) Result: Again, the def

Hi All , Need to send the data from appian to external system and set flag to yes for all the rows which has been sent successfully in Appian table to ignore these rows for next set of data to send. What is the best way to do this.

Hi, As mentioned in the Appian docs (https://docs.appian.com/suite/help/23.4/Customizing_Application_Logging.html ) if we have Appian server installed on premise, we can edit appian_log4j.propertie to customize logging change  i.e.  changing logging level, appending new logger etc. If we have our Appian cloud instance how we can achieve this ?   Does it allow to redirect log messages to separate log files, by defining separate log appender when we have appian cloud instance? For this how can we configure appian_log4j.propertie property files in cloud?      

Hello everyone, Just want to know if anyone have experience or have successfully Consume message from Kafka, I am trying to use the Plug-in "Consume from Kafka", however, the documentation is not have much information.  Especially not sure what should put for "Data Source Name" and "Transaction Table Name". For "Data Source Name":         -  I have create a dummy table along with data type & data store & Record Type, since the type is text, I have tried put the table name, data store name, even recordtype, non of them working For "Transaction Table Name":         -  Since it default linked to "tm_job_transaction", I tried leave there also tried use the table I created, nether of them work. When I run the PM, it do give me success, however nothing received, no message, no table got updated. Here are the log which mentioned some error:

Hi Team, Iam getting raw data when i use EXPORT DSE to excel,  example in table the priority are stores as 1, 2,3 in numbers. so when i use export DSE to excel, i get the values in Numbers in column of priority, but i need text values instead of numbers such as 1 - normal, 2- escalated etc My another Query  is  we are using record actions to export Functionality to call a process model and send exported excel to an email. how do i pass ri!timeperiod to record actions from Interface

Hey Techies, I have a Group 'User Group 1' with membership to include all the members of 'Subgroup 1'.  For testing purposes, I want to exclude selective members of 'Subgroup 1' from 'User Group 1' while maintaining the subgroup membership rule. Any pointers?

Hello,  I am saving the uploaded files to a local variable and wanted to push to a folder. used a!moveDocument service  a!moveDocument(document:local!uploadedDocs,destination:(constant pointing to folder),                               This does not do anything. Can you please help 

Appian says I have a List of Text with 2 items, but when I try to get its length it says it has only 1 item. I need to do a flatten here to achieve the right response with 2 items and its type is not even a List of List of Text. Code for reference:a!localVariables( local!test: index({ code: { "A", "B" } }, "code", null), length(local!test) ) Am I doing something wrong here ? I'm really not getting it :/ For me seems Appian is interpreting the type wrong here because of its dynamic typing and even if it says the list has 2 items on the local variables, the interpreter is doing something different. From time to time we are facing little consistence issues like those and defects are being opened by QA and they take a lot of time for us to find out what the problem really is. This is something so core to the platform that we assume that it's working, but here and there this kind of stuff keeps hapening. We are needing to defend ourselfs against the platform because o

Write a code to find the duplicate words in a string. input string = "Big black bug bit a big black dog on his big black nose" output:  Duplicate words in a given string : big black

Hi, I want to display the difference between today's date and created date in record type as an integer value. Further, I want to show the value in certain colors based on condition (like if the values is less than 3 then green color; if the values are in between 3 and 5 then yellow; and if the values are greater than 5 then red). This values will only come when the status is not completed. Can somebody guide me?. Many thank,

Hello all, I have an array of 3 items. local!array:{  { id: 1, deleted: true, activeStep: false },  { id: 2, deleted: false, activeStep: false },  { id: 3, deleted: false, activeStep: false },}, Now I want to concat text based on index. for index 2 concatenate "Active" and for index 3: " orderid" Eg: local!array:{  { id: 1, deleted: "Active true", activeStep: "orderid false" },  { id: 2, deleted:"Active false", activeStep: "orderid false" },  { id: 3, deleted: "Active false", activeStep: "orderid false" },}, How can I do this. Thank you in advance.

Hi All, I have a query regarding checkbox. There are three checkbox in interface as shown in snippet below, but only one of them should be selected at a time.  Can anyone please help me how to achieve this?

Hello everyone, Got an new error in an interface that existed for a while. It is a simple interface that takes several CDTs of data and displays it as well as taking some text input from users and passig it to a process, it does not have record headers or actions in it. This error refers to 'Headers' and 'body' that aren't used anywhere in code for that interface, so could anyone please help me make sense of it? Also, strangely enough it pops up only ocassionally and/or for different users, with same data.

Hi All, will appian integrate something like a reporting services?  A tool like SQL Server reporting services o Jasper , useful to easy design pdf or excel or any other file format, map data from database fields to these documents in order to download them dynamically via web API Thx

Did Appian remove sortintegerarray() ,sortdecimealarry() ,sorttextarray().       function 

The size of  a folder is showing 69 GB, while the sum of size of all document in it is less than 20 GB. Due to this, Disk Utilization is increasing . Is there any way to correct this and decrease the disk utilization?

Hi Everyone, I have a requirement where I need to generate a pdf from html.  To achieve this I am using Html to Pdf (Page Number and Custom Fonts) but it is Faling due to java.lang.NullPointerException. Can someone help me on this?

Hello,Is there a way to automate taking DB back up from Appian Cloud? We do take back up manually from Appian Cloud before PROD deployment every month.However, we now are looking for automating the process before every deployment.Please suggest if you know of any good way to take Appian Cloud DB backup without the intervention of Appian Support.(I know of "mysqldump" plugin but do not want to use it since it's not maintained for the latest versions of Appian - https://community.appian.com/b/appmarket/posts/mysqldump)

My requirement is as below: I have a set of Ids, and using an integration I am getting all details of the records of those Ids. After certain manipulation of the dataset, i am displaying the dataset on a grid. Now I want to download the same grid to an excel/csv document. Please note, I am not saving the data in any table so I can't use export to csv from DSE option. What I have tried is using an document WebApi where I pass my Ids and get the details and download the document.  The problem with this approach is: 1) I have to call the integration again and do those manipulations again 2) The Ids I am passing as query parameters. When there are more than 1000 ids, the url is becoming too long and the API is failing. Can anyone please suggest an alternative approach to resolve this issue TIA

Update class 8 to 9 { a!map(name: "X", class: 5, School: "ABC"), a!map(name: "Y", class: 6, School: "ADC"), a!map(name: "Z", class: 7, School: "AEC"), a!map(name: "K", class: 8, School: "AFC") }

Hi guys, Have question that we are having user login through SSO, also set-up the SAML. So when the user first time login, Appian will create this "New User" also add them to the group. So the issue is we also need update DB, just wondering is there anyway we can trigger a PM to update user DB once we have a new user or a group got update? Or it can be set-up via SAML? Any suggestions appreciated.  Thanks in Advance. 

is there any data flow from appian outlook add-in to appian cloud application. This is related to Task Viewer Add-in for Microsoft Outlook.