General

I need to convert seconds to hh:mm:ss.  For example, 5565 seconds would be displayed as 01:32:45.  Does anyone have a good way to do this?

Hi there, I have a list of applications (n) which have to be equally distributed amongst users (n). Say there are 10 applications and 3 users where application is a CDT and I am using updatedictnary () for setting application.user : user1. Distribution should be like -->  application 1 : user 1 application 2 : user 2 application 3 : user 3 application 4 : user 1 application 5 : user 2 application 6 : user 3 application 7 : user 1 application 8 : user 2 application 9 : user 3 application 1 : user 1 How can this be achieved using only foreach? or is there any better way to do it?  Something I tried  local!i:1, local!UserList : {touser("ABC"),touser("PQR"),touser("GHJ")}, local!UserCount : count(local!UserList), a!forEach( items: local!LoanApplicationList, expression : updatedictionary( dictionary: fv!item, fieldsAndValues: { ApplicationUser : if(local!i=local!ListTotalUserCount, { local!i:sum(local!i,1),

Hi All,  I have a column  name created date in db as datetime . When I am creating filter in expression rule as createddatefrom and createddateto . I am not able to filter it .  Expression Rule: a!queryFilter(field: "createddate",operator: "between",value: {todate(ri!createddatefrom),todate(ri!createddatefrom)+ day()},applywhen: not(rule!APN_isEmpty(ri!createddatefrom))),a!queryFilter(field: "createddate",operator: "between",value: {todate(ri!createddateto),todate(ri!createddateto) + day()},applywhen: not(rule!APN_isEmpty(ri!createddateto))), Please help and thanks in Advance

Hi all, I'm working on poc, i have an appian process which needs to be triggered only when new items are added in the database.

I have a situation where we are assigning individual named users to a task from a database by role but the task isn't visible.  When I look at the process instance, there is no error showing with the task itself except there are no assigned users showing in the assignment tab.  Is there a limit to the number of individual users that can be assigned a task? The users are part of groups in Appian but the task is assigned to individual users instead of the group. 

Hi,       I have the following table as        sno     product    --------     -----------        1           product1        2           product2        3           product3        4           product4        I want to interchange the first two rows product sno as    2 for product1 and 1 for product2 and store the updated values in cdt again How can i do that?

So we want to invest in creating a print button that just calls javascript window.print().  Putting this in a customer interface component won't work, right?  The interface component cannot access outside it's context. What are other options?  Deploying a servlet with print that takes in the url for the form?  But then the form url has to be known each time and won't work for printing tasks, right?

I have a reference CDT for organization details. Here my requirements are when I select an organization name the tax id and address should be prepopulated.  Is there any way to get this requirement done!

My use case is as follows: I have a CDT of dates and number of days.  I have the first date, but the others are not populated yet.  My goal is to populate each subsequent date with the previous indexes date + the number of days of the current iteration. For example I start with the following: {9/27/2021, 0}, {null,3}, {null,5} I want the output to be as follows: {9/27/2021, 0}, {9/30/2021,3}, {10/5/2021,5} Each iteration will reference the previous iteration's date to generate its own date. I appreciate your time and help!

HI Im getting this error one the process model of Export Data Store Entity to CSV An error occurred while attempting to setup the export for ADDRESSUPDATE. Please contact your system administrator for additional details. (APNX-1-4505-054) Any ideas? Thanks Neil

Could someone please share any Appian Artificial Intelligence (AI) use cases within the the U.S. Government space? 

Hello, I am trying to create a connected system in Appian to connect a BluePrism, I am getting error trying to test the connection. Here are some additional details: i have created a bot in blueprism in my pc for demo, I have exposed a BluePrism process that I can access locally  by going to localhost:8181/.../. In Appian I have tried entering the Host URL in the following format: DESKTOP-NQK6NPJ:8181/.../ DESKTOP-NQK6NPJ:8181/.../ But I am not having any luck testing the connection. Any help would be much appreciated.

Hi, I am L2 certified and as per the new certification pattern , can i take the lead developer exam directly. But I have a query , my appian profile badge is showing A Score level 1. Please confirm Thanks

Hi All, What is the best way to point out missing features of Appian? I am just wondering if there is any feedback mechanism aside to the community and support cases specifically for this purpose. I do already experience good support from Appian in general, but I am wondering if there is any place where I can view (and vote) new requested features / Appian roadmap? For example I am missing: Adding a dynamic link in an empty grid message Disable future dates in the date input field, https://community.appian.com/discussions/f/rules/18008/calendar-blockout-disable-hide-of-future-dates/70841#70841 I understand there are other priorities, but it would be nice to have an official avenue for submitting ideas. See also this related thread https://community.appian.com/discussions/f/user-interface/12151/product-improvement-idea Thanks in advance, Jesper

Good afternoon We have a problem with the delay of a start timer, the timer has to run every X minutes (set to a constant).We have created a rule to delay us so that the process runs at the exact minute.For example, if it's 6:26 p.m. and we run every 15 minutes and publish right now, what we want is to set a 4-minute delay so that the process doesn't start until 6:30 p.m. The problem is that the process is not starting and we do not know what we are doing wrong. The code: load( local!intervalos: ( 60 / ri!duracion ) + 1, local!enumeration: enumerate( local!intervalos ), local!intervalosFinal: a!forEach( local!enumeration, fv!item * ri!duracion ), local!retardo: reject( fn!isnull, a!forEach( local!intervalosFinal, if( and( minute( local( now() ) ) > fv!item, minute( local( now() ) ) < local!intervalosFinal[fv!index + 1] ), local!intervalosFinal[fv!index + 1] - minute( local( now() ) ), null ) ) ), if( or( isnull( local!retardo ), local!retardo = "", length( lo

Hi All,  I have a Column Layout in that Card Layout . I just want to show a warning when he clicked on that before further process.  Help me out  Thanks in advance 

Hi I've started getting this error the last week or so - http error 503 when I click on Process activity, or indeed any of the other tabs in the image. Happens the first time I click, but not the second. What could be going on here? Browser issue? Network latency? It also happens in on of our applications in a record type sort - again the first time the user clicks on the column heading. Using chrome, 93.0.4577.63. Can make the error go away by cleaning out the cache, but this could be just coincidental? Seeing this in the tomcat log at around the same time, this is the first few lines. Any ideas? 2021-09-21 07:02:09,555 [ajp-nio-0.0.0.0-8009-exec-1619] ERROR com.appiancorp.rest.shared.FallbackExceptionMapper - Internal Server Error on REST API invocation. org.apache.catalina.connector.ClientAbortException: java.io.EOFException at org.apache.catalina.connector.InputBuffer.realReadBytes(InputBuffer.java:330) at org.apache.catalina.connector.InputBuffer.checkByteBufferEof(In

Received the following error:  Expression evaluation error [evaluation ID = Y74ZUD6M] in rule 'XX_getclientbyfilters' (called by rules 'XX_mailtracker' > ... > 'XX_form_contractremediation > 'XX_contract') at function a!queryEntity: An error occurred while retrieving the data. (APNX-1-4198-000) The log also contains the following: 2021-09-16 18:07:10,508 [ajp-nio-0.0.0.0-809-exec-9] ERROR com.appiancorp.rest.record.data.RecordRestService - Unable to retrieve record summary for record w/ type RecordType [id=3, uuid=4da5e8e6-d7ad-4bb5-a397-3888cf6e7898, name=XX Product, sourceTypeStr={http://www.appian.com/ae/types/2009}DataStoreEntity, sourceUuidStr=3e61f35-8eaa-4116-9fb6-cf12cf4ed77c@_a-0000ec9-1284-8000-9ba2-011c48011c48_22996] and id 901 What would cause the error - unable to retrieve record summary? I've tested the rule that is said to error and it can retrieve the record data

"Create a new folder, Appian, on your resource"  I would like help with the above statement. How can I create a folder on VM Resource and download the Agent as against doing it on the physical machine(PC)? Here is my Resource :

Hi Everyone , Need your help in solving below problem .  I have a requirement where i can insert data in between any rows but Type will always be Manager.  When i add new row, i need to generate a new id and want to update/increment sort id's  of all the rows which has Type as Manager accordingly. For example - I added a row after id = 3 or at 4th place  so my new row will have id = 6 , Type = Manager and sort id = 2 . Also, sort id for last row which has Type='Manager' gets updated with 3 . Thanks in advance

Hello everyone, Given any date for example 09182021 in a text format, I need to use it as a variable but change the format to 210918. Is there any way to do it. I'm having troubles finding the right function. Datetext worked fine for me, but I have another task where the date would be provided through rule input and in a text type. Any help will be appreciated. Thank you.

Assume the user is on a customized (Appian) task report, and clicking on a given (automatically initiated) task "Upload" triggers a manuel process (e.g. uploading a file). Once this manual task is completed (by clicking "Submit" on the Upload-interface), the user is directed back to the initial task report which sadly did not update. Once I hit F5 in my browser, everything is fine and I see the next task (e.g. approval of the uploaded file). My issue: After completing a task, I would like to be redirected to an up-to-date task report. Why is that not possible? References: https://community.appian.com/discussions/f/user-interface/10306/refresh-task-report-after-task-completion has only a single answer which is over 4 years old and suggest a not-so-amazing work-around, namely to add additional nodes in the process model.

Hey Appian devs! At Appian Europe this year I’ll be hosting a Live Build Lounge with some special guests. Luckily a virtual event means you don’t need to be in Europe to attend. It’ll be split into two parts. Part 1 - Launching Your Low-Code Development Career We’ve seen how Appian can transform businesses, but how can developing on Appian transform you as an individual? I’ll be joined by three amazing Appian developers to discuss what different Appian career paths can look like. During our conversation, we'll also show just how easy it is to get started building using a free and unlimited-time Appian Community Edition environment. Participants [mention:bad218cd233e44e3b04feb94ac483d80:e9ed411860ed4f2ba0265705b8793d05] - the developer behind the apps that support Appian Community Edition [mention:9dd46619e6e740f38c0ef1b9d839c75a:e9ed411860ed4f2ba0265705b8793d05] - one of the fearless competitors in the first ever Live Build C

Any suggestions on how to identify the root cause (offending query / objects) please? - Thanks. [pool-33-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter - The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. After enabling the Log4j DEBUG settings, it seems this is caused Appian generated query still unable to identify at what event / action causing this error. DEBUG org.hibernate.SQL - select this_.id as id78_0_, this_.obj_type as obj2_78_0_, this_.obj_uuid as obj3_78_0_, this_.obj_version_id as obj4_78_0_, this_.outdated_status as outdated5_78_0_, this_.test_result_id as test6_78_0_ from last_test_result this_ where this_.obj_uuid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, this "?" goes beyond 2100 limit.