Foundation

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.

Hi All When the user clicks the button on UI, the system has to load the same UI after executing certain logic/functionality in a sub process at backend.But system just closes the UI and a task is been assign to the user in task tab. On opening the task, it opens the same UI and works fine there after.No errors / warnings showing in the process models. Any thoughts / idea what could be the issue Thanks In Advance

How to UnArchive any Archive Process? Could you pls let me know the steps for that.  Thanks in Advance!

I am implementing an HTTP connected system that uses OAuth 2.0 Authorization Code Grant for authentication. When presenting our users with the Authorization Link I would like the interface component to also display the connected system's Name and System Logo.  Is there a function to retrieve Name and System Logo from a connected system object? Looking through the documentation there isn't an mention on publicly visible properties from the Connected System object.  The reason I am looking to retrieve these values from the Connected System object instead of passing hard coded values for Name and Logo is because I would like to create a Connected System agnostic interface to present users the authorization link.

I am trying below code. Here, expression rule GPO_questionDetails returns a list for a given number.a!gridLayout( label:"program",headerCells: { a!forEach( items: {"230108","230109","230110"}, expression:{ a!localVariables( local!list: rule!GPO_questionDetails(questionID: fv!item), a!gridLayoutHeaderCell(label: local!list.label) )} ), if(not(rule!APN_isTrue(ri!isReadOnly)),a!gridLayoutHeaderCell(label: ""),{}) },Error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridLayout [line 35]: A grid component [label="program"] has an invalid value for "headerCells". "headerCells" can only be of type GridLayoutHeaderCell. Received List of GridHeaderCell at index 1.Can some one help me to fix this ?

Expression evaluation error [evaluation ID = a667e:8b65e] in rule 'ntd_adminreportingdashboardmonthlycompliance' (called by rule 'ntd_adminreportingdashboard') at function a!forEach [line 42]: Error in a!forEach() expression during iteration 5: Expression evaluation error at function 'updatecdt' [line 44]: Length of input arrays must equal length of CDT/Dictionary array Interface Code: if( and(ri!isShowMonthlyCompliance = false,rule!GLB_isNotEmpty(ri!selectedMonthAndYear)), a!localVariables( local!searchVanpool, local!searchCoordinator, local!searchEmployer, local!searchOperationsContact, local!complianceData: a!refreshVariable( refreshOnVarChange: { ri!savedTripDataCounter, ri!selectedMonthAndYear }, value: rule!INT_TRP_getTransitMonthlyComplianceStats( transitAgencyCode: index(ri!selectedMonthAndYear,"transitAgencyCode",{}), month: index(ri!selectedMonthAndYear, "month", {}), yea

I have a table as follow:                        sno         department                         1             CS                         2             ME                         3             EI              I want the output after inserting a row between sno 1 and 2 as                           sno         department                         1             CS             &n

I have two viewer groups with end users in them. My goal is to have one group that can only view a specific page and another group that can view and interact with the functionality on the page (Add items, delete items, reorder items, etc.) How could I accomplish this? 

HI All, I am facing some issue while accessing Process Model. I am not able to view any properties or edit and publish, it shows blank, i am added to the all accessible groups, i have access still i am not able to access PM. I have cleared the cache and tried. Please let me know if anything else i can try on

Hi All, I am passing one dynamic value in expression rule in textField to display value but rule is not getiing refresh n taking old value only. Here below rule should take dynamic value n on t he basis of that should return respective value . Below field in in with(). What could be the root cause of that please share. a!textField( label: "Name", value:rule!getNamebyId(local!data.requestId), readonly: true() )

Interface Definition: Expression evaluation error [evaluation ID = c9564:63ac5] : An error occurred while executing a save: Expression evaluation error in rule 'TID_documentsquery' at function a!queryEntity_18r3 [line 2]: An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [TIDContentTagsVwDT31557], threshold: [1,048,576 bytes], objects successfully converted: [3,228])

I want to trigger  a process in blueprism from appian, can anyone  let me know the capablities of blueprism connected system, can i trigger the bots using blueprsim connected system. Or to trigger bots in blueprism from appian is there any other way, plz let me know.

Hi All,           My requirement is when I click on the download document link. I also need store some meta data in DB. Metadata like who downloaded the document, time, document name, process variables etc. On click of the document download link two action should to be performed.  1) Document should be downloaded. 2) Data should persisted in DB. What should be my design approach.       

Hi guys, I tried to use document picker to select documents, but its selecting the same document multiple times. I want the selected documents to be distinct. Thanks for the solutions in Advance.

I have a scenario where I need to somehow indicate in a lineChartField when a specific value on the X axis is selected.  Basically I need a chartReferenceLine, but on the X axis.  I have attached a photo as an example.  

[evaluation ID = bfc87:b5c51] : Expression evaluation error : The function 'isusermemberofgroup' is unavailable. (APNX-1-4198-000)Has anyone getting this error after Appian upgrade to 21.3. I checked in the code where ever isusermemberofgroup function was used it is now appearing as isusermemberofgroup_21r2, still for some user we are seeing above error.

Hi, while twiddling around with IDP, I went ahead and uploaded an invoice not provided in the community edition test environment. After a decent time of thinking the idp came back identifying not to much information out of the invoice, particullary missing out on the items/amount/price table in the middle of the document. I choose "edit table" in order to set the data up, and ran into the following problem (see screenshot). IDP was obviously not able to distinct all columns from each other, due to the layout amazon provided. Item count (Menge) and Item price (Stückpreis ohne MwSt) are identified in one column and tax pct (USt%) and price per item (Stückpreis mit MwSt) are also mixed in one column. It seems that I can only add/select to an identified column, but... how can I tell IDP to split one column with two headers in two colums with one header and go from there?Thx Greets Olaf

HI I'm getting below error when I downloaded the excel form a process backed record. Any suggestion appreciated. Note: I'm able to view the records on the UI but I see the error when I download the excel. I'm using the default functionality from Appian. Here is the log if it helps. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.NullPointerException at com.appiancorp.dataexport.ExcelDocumentCreator.getEvaluatedGridFieldColumns(ExcelDocumentCreator.java:727) at com.appiancorp.dataexport.ExcelDocumentCreator.writeToWorkbookFormattedGridField(ExcelDocumentCreator.java:701) at com.appiancorp.dataexport.strategy.WriteToWorkbookFormattedGridField.writeBatchToWorkbook(WriteToWorkbookFormattedGridField

I need to write a validation to avoid user from selecting past data and time. My problem is when I use today() for comparison I get 13/09/2021 10:00 as date and time. There is a GMT component of 10 hours. I am expecting  userInputDateTime >13/09/2021 00:00 

Hi All want to create Ann expression Rule to check weather the array of values say rollnumber with the column field in the database . Condition If 2 value passed and one is there and another is not there then i don't want user to continued

We've just started getting the following UI expression error in all our lower environments: Expression evaluation error [evaluation ID = 59de2:e8179] in rule 'u1b_com_workitemsgrid' (called by rule 'u1b_ui_workitemsdashboard') at function a!gridField [line 5]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Team"] has encountered an error. Expression evaluation error in rule 'u1b_getdirectgroupnamesforanuser' at function 'getgroupsformemberuser' [line 20]: The user Incorrect privileges to get groups for user. [User Context: test.user2] does not have sufficient privileges to perform the requested action. And the follow in the system logs: 2021-09-01 09:36:19,992 [Appian AppianServerThreadPoolProvider 2246648] ERROR com.appiancorp.ps.people.function.GetGroupsForMemberUser - Incorrect privileges to get groups for user. [User Context: test.user2]PrivilegeException[null=>null]: Insufficient permission

Hi All, I am using the Navigation pattern in my interface. I am having different tabs on the left navigation. I am referring to separate interfaces for each tab. So now when i am moving between the tabs, the content is not refreshing. (When I am changing from WorkSpace Tab and clicking back the Workspace tab i can see the content previously where i left.) I want to reload the content when we click on the tab each time. Here i am using rule!testPage1(), rule!testPage2() interfaces for different tabs. {  a!localVariables(    /* The selected navigation section */    local!activeNavSection: 1,    /* The navigation sections */    local!navSections: {      a!map(name: "Workspace", icon: "briefcase"),      a!map(name: "Tasks",     icon: "tasks"),      a!map(name: "Requests",  ico

Hello Guys, Can anyone help us on the below issue ASAP. We have created the backup script based on the Appian documentation. Below is the script #!/bin/bash source ../../../../server/_scripts/exports.sh INSTALLDIR=$AE_HOME/_admin/_scripts/tools/datamaintenance/antScripts ant -f $INSTALLDIR/aecopyfiles.xml -Dae.source.location=$AE_HOME -Dae.dest.location="/data/aebackups" - Created backup script in ‘/apps/appian/_admin/_scripts/tools/datamaintenance’ -> ‘appianbackup.sh’     But, while running the backup script getting below error : “appianbackup.sh: line 6: ant: command not found” Please suggest what we need to do on this issue.

Hi All, Is there any way to open an external link using safe link and Write operation into Data Base on Single Link from User Interface Read-only Grid level. Current functionality using two columns in Grid Column1: Link (safe link) will open the external URL Column2: Start Process Link Writing operation in Database User Requirement: Merge these two columns with single Click do both operations.  Thanks Vinod