General

i want to learn  PDF utilities appian and its new capabilities. can you help 

Hello! Nice to meet you! [emoticon:c4563cd7d5574777a71c318021cbbcc8] I want to take the Appian Analyst Certification exam, but I have some questions. I have already done the Appian Analyst learning path and I have done the practice test several times to train it. Since English is not my native language, I am a little worried. Is the official exam very different from the practice test questions? Or are they more complex? I have more problems with the multi-choice questions. Do you recommend anything else besides the Appian Analyst course? Thank you so much. Have a nice day.

I have API which returns me some responses based on parameters but the important point is when my database has any change then my Appian local variable which has API data also needs to get updated automatically, which means simply a WebSocket type connection with an API

Hi Everyone, Is that possible to store Multi dimensional of a record type? I have a requirement where i need to store like  below a[1][1]=2, a[1][2]=3, something lie this,With CDTs i see it is straight forward but when i am using with record type to save a[1][2] it is showing below error . Am i missing anything? Can someone please help me on this?

Hi Everyone, How to handle null values in a recordtype? My output is like this where first index is nul. To exlcude that in recordtype what needs to be done as i have used reject function as well but it will only work for an array. Can someone please help me on this?

Hi All, I have an interface where we are having paragraph field and grid . User will be giving data in the paragraph field in specific format and will click on add button, Once they clicked on it, it will be written into database and the grid will be refreshed with the added data. There are some use cases where user will be adding more than 2000 records at a time. Currently it is taking around 2 minutes to load the 500 records into database.  What is the best way to save the data into database with minimal time? Could someone please help me on this

Hi Everyone, I need to store the values of lablels in col1, corresponding to col2 and col3 which are checkboxes into database and retrive it when the interface is loaded. Can anyone please help me out how to achieve this?

Hello, I have an application with users that have multiple groups that describe their roles and teams. I have a group type that specifically targets which team a person is on. I have a pointer to that type. I want to get a member of another role (group) from this same team automatically. Technically what I am having a problem with is the following: union( a!groupsByType(cons!TA1_ProjectTeamsPointer).data, a!groupsForUser("testuser") ) This gives me the following error: Expression evaluation error at function 'union': Invalid types, can only act on data of the same type (Any Type, Key (Integer)) So the union arguments are of different types? But the documentation explicitly states for both methods that the type is 'list of group'. Is the documentation wrong? How do I convert 'Any type' to list of group? When I test the arguments individually, the raw outputs seem the same to me. Thank you in advance.

Hello, We have a read only grid with selection enabled. Users could navigate to a page(say 5th page), select certain rows and reassign the task to another user. Once the reassignment is done, the grid lands on the first page. Is there any way we could retain the Grid on the 5th page itself after reassignment.  TIA.

Appian doesn't allow me to add required permission levels to the groups instead it directly assigns the administrator level access to the groups. Why? Is there any way or process to do that.

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?