Foundation

Hi, Is there any way to display textField/radioButtonField 's in gridRowLayout based on satisfying given condition ? I have a column, it can be of either dropdown or text field or radiobutton. Type of row has to be decided based on column header selection (column header selection happens dynamically). I have tried using required option but its not working.   a!gridRowLayout( contents: { a!dropdownField( labelPosition: "COLLAPSED", placeholder: "Please select one", choiceLabels: {"A","B","C","D"}, choiceValues: {"A","B","C","D"}, value:"", saveInto: a!save(ri!answerList.answerValue,save!value), required: exact(fv!item.type = "grid",true(),false()), disabled: rule!APN_isTrue(ri!isReadOnly) ), a!radioButtonField( value: "", choiceLabels: {"False", "True"}, choiceValues: {false, true}, saveInto: a!save(local!gridQuestionsL

Hi, We have a requirement to change the background color of the grid row based on certain conditions. Looking for something like a!gridRowLayout(color:"POSITIVE", contents:{}). Any suggestions? Note: Not the text color using a!richtextdispaly field(). Thanks, Manjunath

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

Hello All, I was exploring if we have any option to use Windows Command in Interface. The requirement is to have print functionality through Appian. In the current solution a print icon is provide which opens up an interface through a process. The interface is added as start form to the process. Once the interface is launched users have to key-in "Control + P" to print. So my question - is it possible that if the clicks the print icon it runs the print command and the document is sent for printing. Thanks & Regards Girish Katti

Hi everyone. We are building a grid with data records in it. What we want to do is add a button above the grid, that when clicked, will unlock all the rows for editing and when clicked again will lock the rows. In other words, if a user clicks the button, all the fields will turn into text fields and if clicked again the fields would go back to read-only.   Any suggestions for how to go about this? 

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.

Hi Everyone,  As I try to use selection in read only grid with conditional user filters. But when I select the row first time, data is saving in the variable but in the UI it is not showing the selection. I try to remove the conditions from the user filters then it is working fine. Here on the basis of selection and showFilter , I try to handle condition userFilters: { if( rule!Test_IsNullOrEmpty(ri!selection), if( local!showFilters, { Test 1, Test 2, Test 3, Test 4, Test 5, Test 6 }, {Test 1, Test 2, Test 3 } ), null ) },

Hello Appian Community [emoticon:c4563cd7d5574777a71c318021cbbcc8] Goal : I'm looking for a way to call a specific sequence in my database without having a huge amount of process nodes for each sequence I have.Additional information : Depend on the context, I have to call a sequence. So for 50 contexts, I have 50 sequences. I previously made 50 nodes to call my specific sequence depend on the context.What I've newly done : In my process model, I have a node to create an SQL query where I inject this query to call the sequence I want, depend on a given context. As you can see, the query variable "ac!sequence" is my SQL where I try to get the NEXTVAL of a given known DB sequence.But by doing that, my process model rise an error : "There was a problem executing the SQL query. SQL Message : Invalid SQL type: sqlKind = UNINITIALIZED" Questions :I guess is not a proper way to do that, but what can I do to fix it (if it's possible) ? How to reach

Hi All, When im running processes random script tasks are failing if i restart the script task its working properly can anybody help me on this

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])