General

Hi Team, I'm using API Key approach to access web api, is there a automated way to disable the web API to show error between 4pm to 8pm. Is there a approach to do that?

I have a requirement to generate a PPT files from Appian. Did anyone come across similar requirement. Will appreciate any suggestions.

I had written some logic that queried a record (expecting, and getting a single record, by passing a unique filter value) The query actually could return multiple records, so returns a List of the relevant cdt Then I tested a boolean field in that record is true or false, and returns one of two lists of items, for example something like this: if ( index(my_cdt, "booleanField",false), list_one, list_other ) My list was being returned but only with the first item in it! The issue is that the query returns a list of records, so the if statement parameter 1 is on a list type. An example of the logic I was actually executing was therefore: if( {true}, {1,2,3}, {4,5,6} ) This actually returns {1}, not {1,2,3} if( true, {1,2,3} {4,5,6} ) will return {1,2,3} as expected. Further example to show what's actually happening: if( {true,false,true}, {1,2,3}, {4,5,6} ) This returns {1,5,3} !! An easy mistake to make, so hopefully some one wil

Hello, I'm currently building an audit history for my job. The way our client wants the history displayed is grouped by the date that the history action is created on. So that the list sometimes displays 1 action per timestamp and sometimes 2 or 3 actions by timestamp. We have found a way to do this but it is complicated. I get all the values in the histActionOn, then I uses union() to get only the unique values. From this point I can do more complex indexing to organize all the actions by date, or I can throw a a!queryRecordType() in a for loop and filter it by the histActionOn field. This gets exactly what I need. A record list with actions separated by date and time, but it's incredibly inefficient as it puts a query in a for loop. I'm sure there's a way to group all the actions by unique dates, but I don't know a way at this point. Any thoughts?Thank you Jason

Hey, I try to find components through Object View search that still uses 23.3 version as we updated to 23.4. But, when I searched(in the expression), nothing showed up and there are no of objects with what I searched. Searched for 'buttonWidget_23r3' and no object is available: Just one of the component that uses 23.3 version component.

Hello, I am currently working on an application for training purposes. I have a process for adding a record and editing it. I had a sub-process for both, where I am sending an email to a user group whenever a record has been added or edited. I was able to make parts of the email dynamic (e.g. "Information about [dynamicName] has been [changed/added]), but I would like to embed a record summary view link in that email, so that users can navigate straight to the updated record from that email. Now, the urlforrecord() function generates a working URL, but it links to Tempo, and not the summary view of my record. I have been trying a few things, but nothing seems to work. I would be very much obliged if someone helps me figure this out. To sum up: I need to dynamically generate a URL to a record summary view on my site to embed it within the email body. Thanks!

I want to complete my L1 exam but the account I'm using is created by company's mail Id ,is it possible to merge 2 id's to same account so that i can have my certification linked to my personal account as well

Hi there, I hope the title makes it a bit clear what I am currently struggling with. I would like to set up a process that is triggered by inbound e-mails. As part of the process some information of the mail shall be written into the database via the "Write to Data Store entity" smart service. When I tried it first I encountered the error 'Details:  An error occurred while trying to retrieve the data store entity [id=]. Verify that the data store and entity have not been deleted, and have the correct security settings. Details: User Does Not Have Rights to Perform this Operation '. After I adjusted the Data Store security settings to Viewer rights for ALL users, the process ran successfully and the data entry was written to the database. However, I have some concerns about keeping the security settings of the Data Store set up like this. Except for the handling of the inbound mails only dedicated users of the company shall/need access to the application

I am using the Create User Smart Service in my process model and passing the required parameters through the start process smart service on the interface,  and I am able to create an user with the username, first name, last name and email fields but I also need to set the Title field for the user during creation itself. Is there a way to do this without using Admin tab manually? 

Hi, I have a requirement to read uploaded DOCX file from appian uploads folder convert it to PDF and show in document viewer on richtext icon click. I have been able to convert DOCX file to PDF but not able to show it in document viewer. Please help.

write a program to check whether it is a palindrome or not ? Input : 12321 output : it is a palindrome input : mam output : it is a palindrome input : 12345 output: not a palindrome

Is it possible to create an article in the Appian Knowledge Base for everyone? or how to create an article in the Appian Knowledge Base. Thanks

Is it somehow possible to create a map or dictionary using variables for the keys? For example, is there some way for me to do something like a!map(localvar1:local!var2) to make a user generated map? Or maybe use a foreach loop over a 2d array to convert it to a map? 

Hi Everyone, I am getting the cdt rows through record type using expression rule. Is it possible to add more unique rows to cdt through expression rule. If yes, can anyone please help me out?

Hello. Would like to know if Appian Server supports Oracle 19g, and if so, what Oracle JDBC Driver can it support. Thanks in advance

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.